Reporting Services 2005 My layout is like this: I have the mainreport which contains a table This table has 3 groups it runs by, GrpLevel1, GrpLevel2, GrpLevel3 Sub-Reports are added to one of 3 groups and are executed passing that group key to the sub-report So, a particular sub-report will run at GrpLevel1 and for every level2 it...
I made a report with about 30 different rectangles and textboxes that have different visibility expressions depending on the parameters. (It's a student invoice and many different messages have to appear depending on the semester) When I made all the expressions I coded in the parameters in all upper case. Now I have a problem when us...
I have created a number of SSRS 2005 reports, and provided a number of parameters for each. Each of the parameters have default values, and therefore the report automatically renders when someone visits the report through the SSRS web site. What I'd like to do is have all the reports have their default values, but prevent the report fr...
Hi, I am generating a report that contains the version number. The version number is stored in the DB and retrieved/incremented as part of the report generation. The only problem is, I am calling SSRS via a web service call, which returns the generated report as a byte array. Is there any way to get the version number out of this gen...
I've been working with SSRS 2005 reports for a little while now, and I've had a few requests come across asking for individual users to be able to save the parameters they use for the next time they run the report. Is this feasible? Is it a part of the "My Reports" role? Any thoughts? ...
I have a report developer that is having some trouble with their Visual Studio 2005 SSRS IDE. The reports in question have mulit-select report parameters. When they click on "Preview" for the report all the options are selected in the drop-down, but they don't have a "Select All" option to check or un-check. Have any of you seen this b...
In one of our systems that uses Reporting Services 2005, the client is asking for reports to feature a watermark to ensure that reports which are printed out by the customer and sent in (example: A contract document generated by the system but then must be signed and mailed in) are authentic. I have not been able to find a clear-cut way...
How to call the ssrs data driven subscription from a stored procedure or a job? ...
In the "Layout" screen of an SSRS designer (Visual Studio 2005), the DataSets panel no longer displays. Previously it was in the same area as the general Toolbox panel. Anybody know how to get it back? ...
I have a requirement to show the statistic data such as sales, visitors of previous two months on a chart, of course the legend should show the name of the two months. And I decide to design the store table as: 1) Product Jan Feb and Jan Feb can be changed for March, Apr with time goes. So, for this design, every month, the column name ...
Hi, I want my report to display results from two select statements. Basicly, one select statement is active users, and the other is non-active users. How do I structure the data tab of the report (I am using SSRS-2005)? Thanks Frank ...
Hi, I have a SSRS 2005 rdl file, which contains a header section. The header section has a logo image. I need to know where in the rdl file is the logo image stored? The logo is to be used for other reports. Thanks FC ...
I used to be able to go to http://myserver/reports and after I supplied my local account information (which was a member of "Administrators"), I would get the "Home" page of SQL Server Reporting Services along with the "Site Settings" link at the top right. Now, when I login, that's gone and it seems I'm just a "regular user" because th...
Hi, Has anyone here used chart object in SSRS to display data graphically? I would like to know what are "Drop data fields here", "Drop serues fields here" & "Drop category fields here" ? What are data fields, series fields and category fields? FWC ...
Hi I'm trying to generate a report that has a solid legend table on top. I've tried to put it in the header section, so it wouldn't scroll down with the page but I can't put any table inside the header ...
I am getting a blank page, at the end of my report in SSRS 2005. I have a header logo and footer date values, and I have set the both to PrintOnLastPage = False, but I am still getting a blank last page. Any ideas how to eliminate it? FC ...
I have a problem with conditional page breaks in Grouping, actually now I'm using SSRS2005. My requirement was to give page break as per the parameter selection. I have three groups in by table, if the user selects page break at first group is True, then I need to give page break while the first group change... likewise I have to give...
So I've got a "daily dashboard" report in SSRS 2005. It has a parameter, @pDate, which defaults to "=Now". I'd like to use this same report in a linked report to show yesterday's final dashboard (which would then be mailed out via subscription), and override the parameter default with another expression, "=dateadd(d,-1,Now)." But when I...
How do I exclude one value from a grouping sum, based on a value of another field? ie I open Report=> Report Properties=>Code and insert my Custom Code, but how would I change the below code to exclude a numeric value of another field for the below case? Public Function ChangeWord(ByVal s As String) As String Dim strBuilder As New ...
Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this after some googleing: Changing the Sheet names in SQL Server RS Excel: QnD XSLT Will try...