all groups > sql server reporting services > may 2006 > threads for monday may 22
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
How to reset a RunningValue on Change of an Field without a group
Posted by Daniel Doerfel at 5/22/2006 10:57:01 PM
Hi All,
how can i make it that a running value is reseted when a value field is
changing (first 2 digits of a postal code).
The Report prints with a list with 3 rows of Labels. There is no group in
there and in the list i can only define a detailgroup whitch brings the wrong
result.
T... more >>
Display top N records and its total
Posted by Nergock NO[at]SPAM gmail.com at 5/22/2006 7:02:36 PM
For a given dataset, I know how to display the top-N records. Is there
a way in reporting services to then show the total of those top-N
records?
For example, let's suppose I have a dataset of sales people and their
sales totals. By grouping on the sales person, I am able to display
the top... more >>
Rendering a report to a specific form location within a page
Posted by T.Stanley at 5/22/2006 4:15:02 PM
Hi. This seems like a silly question, as I am sure it can be done. When I
render a SSRS 2000 report to a page from the Page_Load event, it simply
streams it ahead o all oher HTML. I would like to place this report within a
content section of a page that is associated with a master page (obviou... more >>
how can i install reporting services 2005
Posted by RP at 5/22/2006 2:12:01 PM
Hi,
I installed sql server 2005 enterprise edition and visual studion 2005
professional.
but i am unable to create any projects. how can i create a report project ??
(i cant find a business intelligence project anyw here
thanks in advance... more >>
FormatPercent Crashes
Posted by Gummy at 5/22/2006 1:36:53 PM
Hello,
When I try to view my result as a percent (using FormatPercent) and then
preview the report, it crashes.
Any ideas?
I am running SQL Server 2005 (no Service Packs) on XP Pro.
Thanks.
... more >>
An attempt has been made to use a rendering extension that is not registered for this report server.
Posted by vovikdrg NO[at]SPAM gmail.com at 5/22/2006 11:32:56 AM
Hi guys.
A have create the simply CSV rendr extesion
using System.IO;
using Microsoft.ReportingServices.ReportRendering;
using System.Reflection;
namespace CSVPsrExtesion
{
public class CsvExtesion: IRenderingExtension
{
private const string DEF_EXTENSION_NAME = "CSV (comma delimited)... more >>
Matrix Column Totals and Grouping
Posted by Andrew Murphy at 5/22/2006 10:09:02 AM
I am new to matrix reporting, andam trying to recreate a piviot table report
with counts of number of documents by location, pivoted against doc type
(horizontal axis).
I have created this ok but there are two outstanding issue; firstly i cannot
get the group total to diplay at the bottom... more >>
Problem setting variable in SQL Server Query statement Dataset
Posted by terry beckman at 5/22/2006 10:01:01 AM
I am having a problem getting a piece of code to work and looking for an
answer.
I keep getting various SQL Server errors when I try variations of this
following code.
@DetailSelected is a boolean field and I want to set variables for a
checkbox report based on the selection.
Code follows:
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Fileshare Data Driven subscription - Setting up report manager fil
Posted by Mark at 5/22/2006 7:21:01 AM
I am trying set up a data driven subscription that will render reports as
PDFs to specific folders in Report Manager. I have setup a fileshare to which
I am pushing reports, but I am having trouble relating specific Report
Manager folders to the fileshares and there is little documentation abo... more >>
Is SSRS 2000 compatible with any version of VS 2005??
Posted by tlyczko at 5/22/2006 7:07:28 AM
I am awaiting my free VS 2005 Standard that I'm supposed to get for
viewing online videos on an MS website, and I am curious if SSRS for
SQL Server 2000 can be used with VS 2005??
Thank you, Tom
... more >>
Export to PDF only showing 1 Page
Posted by Chris Hoare at 5/22/2006 4:16:02 AM
Hello,
I have a simple report (rdl available but the ms browser wont let me upload
it) that runs and displays fine on screen; when a user does an export to pdf
they only get the first page. On screen we are seeing 18 pages in total in
IE.
When we export to PDF we only get the first page... more >>
Group By Problem RS2005 using Report-Parameter?
Posted by Classgenerator at 5/22/2006 3:09:04 AM
Hi all,
my Report shows not the correct values, if i choose more than one
Products from my Parameter-Object (Products). Does RS2005 is having a
problem with GROUP BY?
The SqlProfiler does not show the filtered query which the Report is
executing???
I just want to have a small Report to show ... more >>
exporting to pdf without generating report
Posted by ter at 5/22/2006 2:02:01 AM
hi
I am calling a report from asp and if i click the button the report has to
be be stored in a specified location given by the user and report window
should not be generated.
It is very urgent please help me to solve the problem
thanks
terrance
... more >>
Allow Null Value
Posted by Pieter Coucke at 5/22/2006 12:00:00 AM
Hi,
A given column of my Report (reporting services 2005) contains clients or
null values. I want the user to be able to chose one or more clients for the
parameter, and than show only those records of this client. I also want to
be able to chose "NULL", which will show the records with the... more >>
|