Can we run two store procedures in the Query String under the Dataset section of SQL Reporting Service 2005? It seems like the Query String only allow one store procedure. Ww want to use a separate store procedure to open a symmetric key before we run the second store procedure to retrieve t...more >>

Norman Yuan helpe me very much with changing colors on alternate rows, but now I need help with a couple of other reports that use matrices. Is there an ""on group change" event that I can test so that I can determine when the group changes so that I can change the background color for all ...more >>

I have report with SubReport that his query get parameter from master report. when I run it on the server the Report Service run the Subreport query for each line on the Master report with proper value of parameter. But when I run it on Local , the Data came from my DataSet, So how it's can be w...more >>

I come from access development background and I am new to SQL Server. I am trying to learn it using the Developer edition. When I was installing SQL server 2005 Developer edition, I came to the "Components to Install, Select the components to install or upgrade"on the setup form , I noticed th...more >>

Please help. I need to distinguish blocks of information on some reports and I need to be able to altenate the colors. Please advise. Thank you....more >>

Hi, I need to query SSAS Cube from Reporting Services with a Data Source which use Windows Integrated Security, but I can't do this. I've installed Reporting Services on a Win2k3 Server (machine A). Reporting Services is configured to run with Network Service Identity. The security is to be ...more >>

From inside a custom assembly, is there any way to get information about the execution context of the report? Ideally I'd like to find out the name of the folder the report resides in....more >>

I have a subreport inside a table on the main report. It seems everything I try the subreport will keep together on a new page if it cannot fit itself on the rest of the first page. How can I have the subreport display it's data on the rest of the first page and continue on to the second pag...more >>

My main report customer doesn't want the records returned to be "paged" and have to use the navigation buttons in report manager (they're mouse adverse). They want to have all the returned records on just one page. I've seen how to limit the number displayed on a page but how do I display th...more >>

I just created a report with 2 subreports. I published all 3 in my Reporting Services. When I access the "main" report the subreports come back with errors. However, I can go individually to each SubReport and access them and they work fine but just not in my main report. When designing these ...more >>

We want all our reports to have the same header and footer, in crystal reports we could make a template report... can something similar be done in report services? Thanks! ...more >>

I have a report that has date from and to parameters but I would like to have them treated as optional so that if no dates are entered it would ignore the parameter and print all records. is this possible, and if so, how? Thanks. David ...more >>

I have a SQL Server 2005 install with the 64-bit Database Server, but I've had to install the 32-bit version of Reporting Services, since IIS is running in 32-bit mode. Everything's green in the Configuration Tool, but when I go to http://server/reportserver, I get the following error: The ve...more >>

Hi All, I am trying to run a report which has no parameters. it works fine in design and even on the report server. but as soon as i put it in a subreport it gives an error "Error: SubReport could not be shown" i have tried almost all of the help available on these group, i have put the ...more >>

I did the walkthrough wherein I created a Visual Studio .NET project, created an .rdlc report, dragged the ReportViewer control onto a form, and pulled in data via a query. This was all nice and good, but is it really a part of SQL Server Reporting Services? It seemed more like just a clie...more >>

Can someone show me some advanced Charting examples I want to embed a chart into a field in a table I want the result of the count to show ontop explain about the max - chart is not showing correct grading thank From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-servic...more >>

Can anyone supply me or direct me to examples: using RS 2005 - field for date is in a string (varchar) I want to use the calendar drop down in RS 2005 1. What are the steps I need to take to do this 2. I also do not want to hard code the date format - Internationalisation should occur any hel...more >>

I'm having problems implementing the following in reporting services 2005. My hierarchy looks like this (just to illustrate the problem...): University->Student->Exam My query returns the following fields: University, Student, StudentPayment, ExamName, ExamScore I need to create a rep...more >>

Hi MSDN say "Drillthrough links are not recommended for PDF output" (http://msdn2.microsoft.com/en-us/library/ms159713.aspx), but it's possible? How? ...more >>

Hi Gurus, I got the following error: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: > The stream cannot be found. The stream identifier that is provided to an > operation cannot be located in the report server database., ; The images not showing in the report m...more >>

I have a question regarding creating a datasource that connects to an Analysis Services Database. (AS and RS are both 2005 editions.) If I create a (shared) datasource to an Analysis server, and Specify the IP address (10.200.23.24) of that server, I have no problems. However, if I want to...more >>

Hello, Here is the situation. I have a table with a fieldname called VAL. I call a stored procedure to return 4 records from the table. Ok, the 4 records's field name VAL all have the same value , "Horray". I created a report with a table and only want to display the VAL column. ...more >>

Hi, I seem to be seeing the below error after having setup reporting services and visiting report manager. I'm not sure why it gives this particular message. In IIS, the virtual folder is pointing towards the C:\program files\microsoft sql server\... folder as is the default. For some reason ...more >>

I just started learning reporting server, but I have a large background in C# and VB.NET. I think this is possible, but dont know yet my book keeps eluding to it but never gets into it... but I want to write a report section to a program I am writing that lets users based on my programs auth...more >>

I have been trying various things I have read about in order to solve the problem of Report Manager being very slow to open for the first user. I have set the Idle Timeout section in IIS to 480 minutes. I have created a scheduled report to run every 8 hours. (My client is a 24/7 organization.) I...more >>

What would I need to create custom reports from SQL 2000 reporting services? I was told I would need Visual Studio to create the reports. It would be nice to do some ad hoc reporting without having to go to our developer each time we want to create a new report. ...more >>

I'm new to SQL Server Reporting Services and am looking for a simple walkthrough to get me started (i.e. from within a .NET Windows application). Thanks, Ron ...more >>