Hi Guys, I am a newbie on SQL 2000. Am installing MOM2005 reporting server on a test lab and one of the requirements in to install a SQL reporting server. After installing SQL Reporting services on a SQL 2000 server SP4, I am being ask to initialize reporting server on the first time. I've ...more >>

Hi All, Everytime when I run the report (by URL access), it need a very long time to wait. After such init step, then it return normal speed when I run another report! Anyone can help ! Thanks! Tony ...more >>

I get this error for some of my reports, it only happens for my MDX reports and even then it is not all of them. They have all worked at some point or another but recently this has started to happen The expression for the query 'DataSet1' contains an error: [BC306481] String constants must...more >>

We're building a replacement box for our existing SQL 2k5 report server, and I was wondering how I would go about transferring the existing database(s) to it. I'm hoping I won't have to re-deploy everything, re-configure all the settings, etc. The new system will also be SQL Server 2005, but i...more >>

Hi all Has anyone seen the following error - cannot run any reports - start then crashes Reporting Services Error -------------------------------------------------------------------------------- a.. An internal error occurred on the report server. See the error log for more detail...more >>

I understand the licensing part where installing the on the same server is free and if you move RS to another box a license is required. 1. Is it recommended to separate the DB from RS? I assume it will depend on the report load but for now I can say only RS, DB, and IIS would be on the b...more >>

We have multiple databases on the same server. When I publish a report to the Report Server how do I point to the database I want to run the report against?...more >>

Hello, We are developing our own ASP.NET 2.0 (C#) front-end for Reporting Services. We are trying to create an interface for setting up standard subscriptions that is similar to Report Manager. On Report Manager's Report Server File Share options page, there are two options Render Format and ...more >>

Was under the impression reporting services was free to a licensed SQL server. Downloaded the eval copy, great product, now a need a licensed copy how do I go about getting a licensed copy? Is there costs involved if so I'll need a product #. Were using SQL 2k Mike...more >>

Many of the MS links on Reporting Services are broken now that SQL 2005 has been released. I have two clients who already have SQL 2000 and are interested in using this tool, but I have no idea how to get it anymore. They have a nice page describing some licensing scenarios, but no information...more >>

I can preview reports on the server fine. The first time I clicked the print button, I got a message asking me to install SQL Server??? I said yes, then after a few minutes I got a print error. Now, every time I click the print button on the RS toolbar, I get this message: Print Err...more >>

I was reading the SP2 readme and I see this in section 4.1.1: "To use the Reporting Services SharePoint Web parts, Report Server and Report Manager must both be installed." My company's RS server is on it's own box (A). The RS Configuration db is on it's own box (B). Our intranet (Sharepoint...more >>

I'm using the interactive sort in a report. Can I pass in the previously sorted column so that a user could build a sort order of their choice using two or more columns by appending their prior selections to the sort? ...more >>

I have a report where, among other things, I want to show a multi-page table with some text on top of each page containing that table. So I placed a textbox above the table and set the RepeatWith property of that textbox to repeat with the table. But when I run the report , the textbox is ...more >>

I have upgraded to VS2K5 and I am now trying to open my report project solution files. It prompts me to convert, and it does so successfully, but afterwards it doesn't open the project file. It says "The application for project '<path>' is not installed. Make sure the application for the pr...more >>

Hello, I have a parameter and may sub-reports. I want to make one sub-report be visible or invisible based one of the parameter true or false. Can I do this? ...more >>

Is there a way to make Y axis gridlines intervals change dynamically? Basically increase/decrease base on numbers being graph. ...more >>

Hello, I have written this code to browse and show reports in local mode with the reportviewer control from VS2005. Only when I change the localreport the first report I have loaded keeps showing after RefreshReport. What am I doing wrong? Please help. Arjan private void button1_Click(ob...more >>

Hello, we are trying to use application roles inside reports. Using this kind of code does not work : Exec Sp_SetAppRole myrole,'mypass' Select field1, field2 from table where field1 = @param It gives us the following error : "application roles can only be activated at the ad hoc level...more >>

Does anyone know of a way to make the heading (title and column names) of the report move down with the report as the user scrolls down....more >>

Hi All, I am implementing forms authentication for my reports. I followed the sample code from Microsoft. Everything seems to be working fine except for the subcription. I am getting the following error: ERROR: Error occured processing notification. Request for the permission of type Syst...more >>

Hi, how do I in an easy way upgrade from 2k to 2k5. Today I have SQL 2k + RS2k running on box A. Now I want to upgrade to 2k5 on a new box (B). I have installed sql 2k5 + rs 2k5 on box (B). I tried to follow the migration path found on MSDN. And made an installation of RS 2k5 on box B with "In...more >>

Hi I have a report which displays skills per staff, I have placed staff details in the textbox with a list and also I have placed a table of skills for grouped by staffid. Basically I need to print out certificates like : Staff X -- then skills listed 1.skill A 2.skill B -- footer which ...more >>