Reports

How to dynamically set the height of the report?
Hi I have a report of 8.5"(W) by 11"(H).The header and footer size are fixed. The header size is 4.75 in and footer size is 2.375in. In the report body I have a table where the data is dynamic. It looks fine in the preview but the real problem is when we export it to pdf. The problem is when the data is small ... 2 Feb 2006 10:53

Help with embedded code for SSRS Report
How can I create a VB.NET function to run my query below that my SSRS report can run to retreive TotalPostingDays so I can show that in a textbox in my report? I need help creating the function in the Report properties of my SSRS report and not sure how to call this stored procedure to return TotalPostingDays. ... 1 Feb 2006 20:50

Dynamic grouping problem
Hi all, I need a certain functionality in my Reporting service report. I need a report with 4 levels of grouping above the detail level. The initial visibility of all the lower levels should be hidden expect the top most level. For all the levels toggle item is set in the group properties. There should als... 6 Feb 2006 06:13

Using Reporting Services 2000 with Visual Studios 2005
We are using SQL2000 with Reporting Services 2000. I would like to be able to use Visual Studios 2005 to create my reports. After creating the reports and uploading the report to Reporting Services2000 we get the following error: The report definition is not valid. Please verify that the report defi... 30 Jan 2006 12:18

reportviewer error??
I am getting the following error when I call. Any help would be appreciated. ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out encoding, out extension, out streamIds, out warnings); Error: "Client found response content type of '', but expected 'text/xml'" below is the code I use. MyR... 28 Jan 2006 17:42

how to provide DataTable as DataSource
I am re-writing my Crystal reports into SS Reports. For Crystal, I had DataSets prepared from xml for the DataSource to the report. I want to use those same DataSource objects as the DataSource for the new SS Report. This code below is the smiplist way I have found from the posts on this forum, yet I am get... 25 Jan 2006 13:15

How to suppress a field if it is null
I have a report where it displays demographic information. The Address2 field is sometimes NULL and I haven't found a way to suppress this field. The only thing I can do is make it invisible/visible with an IIF statement. I know in Crystal Reports you could check a box that said "SUPPRESS IF BLANK" and this wou... 25 Jan 2006 10:06

The request failed with HTTP status 401: Unauthorized.
Hi, I am trying to install RS2005 and am working with W2k3 SP1 with SQL 2005 Std. I keep getting the unauthorized error. I am setup as the admin for the box and still cannot get the reports folder to display. I did add the IUSR account to my admin group and change the permissions to allow annomimious acce... 23 Jan 2006 16:21

multi-value string
I'm trying to pass multivalue string from report to stored procedure. I want to avoid using UDF function since it will complicate my logic ( i have several paramaters, dunamic SQL etc) Can anyone tell me if I selected Value1 Value2 Value3 from my multi-value combo box, how the parameter string that I will pass ... 23 Jan 2006 14:46

Reporting services Provider load failure (System.management)
Does anyone know why attempting to connect to Reporting Servies via SQL Server 2005 Management Studio or the Configuration tool raises this error? Here's the text of the error message: TITLE: Connect to Server ------------------------------ Cannot connect to HPNOTEBOOK01. ------------------------------ ... 2 Mar 2006 21:46