Hi I have a "master" report that has 10 chart sub reports that don't have any parameter. I get a "Error: Subreport could not be shown" error if one of them are snapshot based. Any ideas? Regards, Andres ...more >>

When I start "SQL Server Business Intelligence Development Studio" I am getting the following message: This program has known compatibility issue Program: Visual Studio 2005 Publisher: Microsoft Location: .........................\ide\devenv.exe I am running Vista and SQL 2005 Express edi...more >>

Hi; is there a way to control the look of the printing based on the data?.. i want to change the look of a textbox in a table, based on the value in my query, for example: Job desc Name Income Emply John 5000 Emply Peter 5000 Sup Hugo ...more >>

I have a application that uses the Report Viewer control. I ran across a strange error executing a report. What does this error message mean and how do you fix it? w3wp!session!5!04/13/2007-22:38:55:: i INFO: LoadSnapshot: Item with session: yzyevt45bsjnhi55g1tpso45, reportPath: , userNam...more >>

Hi all, I made a report in RS 2000 that doesn't need parameters, it is feed by an SP. In my aspx page, if I open the report window in javascript (window.open) the report data is not refreshed, if I open a new browser and fill the url the report data is refreshed... I tried everything, I tri...more >>

I created a simple report to display the default value of a report parameter. But when I run in VS it works, but when I run it under the "Custom Report" in SQL Server Managment Studio the report parameter is not found. Below is the code what am I doing wrong. Thanks in advance for your help...more >>

I would like to add a footnote to a report in some circumstances. I've looked at font styles and decorations, but haven't found the subscript option. Does anyone know how I can add the subscript and superscript "properties"?...more >>

Hi guru, I am running into a problem where I have no solution. I have created weekly SQL subscription and choose delivery method to File Share which is working fine. My manager wants to have date on each published file. I have found on MSDN that I could use @Timestamp variable at the end of...more >>

I'm having a deployment timeout failure on one report. (after about 2 minutes) Other reports on the same project succeed, so I know I have URL and security logins correct. This report does have more components than most (13 tables and that many data sets), so it probably is bigger than m...more >>

I am using subreport techique to include in my report layout. I can see all the report and subreport (by clicking the toggle key) from the internet browser. After exporting to EXCEL format, i can't see the subreport items. What went wrong???? Thanks....more >>

Whenever I drag a field from the Fields List into the detail line of the layout table, it comes in as =First(Fields!columnname.value, "datasetname"). Therefore the first record is repeated over and over. If I edit the field to be =Fields!columnname.value, I get a message that says "The val...more >>

Hi. We seem to be having some recurring formatting issues with Reporting Services (SQL 2005) and Visual Studio (2005). We have a report that basically shows one record per page (it's used to produce award-type certificates). We want the info centered on the page, both horizontally and vertic...more >>

I have a mailing list and would like to print on envelopes through an hp printer. Has anyone done this? What would the template look like? thx...more >>

I am coming at this from a DBA perspective. Our report writer has taken to creating database as an intermediate step in report writing for large reports. So he has proposed adding 20 or so new databases onto our SQL servers to hold tables from which to report from. Is this the standard way of ...more >>

Hi Experts, I am working on SSRS 2005, and I am facing a problem in this. We are using an ASP.net application in which user fills a form. Some fields contain text fields and we are entering all the fields in our database through application. But when we are entering values from application th...more >>

Does anyone know how often we should backup our reporting services encryption key, rsdbkey.txt? Does it need backed up when a datasource is added, security is changed, new report added, etc???? I backed it up at installation time, but should it be backed once a week or month? Also, wh...more >>

Hi, my report looks great in MS VS preview and diploy to browser, however when i export to pdf or tif format, empty pages will occur after every actual pages. Please give me some advice. Thanks...more >>

Problem: When I try to access the report manager I get the following error. The request failed with HTTP status 400: Bad Request. The server is configured as follows. Windows 2003 Ent SP2 SQL 2k5 STD SP2 MOSS 2007 Ent IIS is installed. An MOSS Site runs on a second website that is ...more >>

I have deployed a report w/ a shared data source to the Reporting Server. The shared data source uses sql authentication to the database the report runs against. I have another developer that wants to create a report with the same shared data source from within BIDS/VS. When he opens a new ...more >>

is it possible that a matrix inside a listbox1 and the listbox1 inside another listbox2? ----------------------------------------- |list box2 | | ------------------------------- | | listbox1 | | ...more >>

I have kind of a quandry... There are 12 reports that are in a folder. One of these reports is the "main" report, the others are "detail" reports. When you choose a field in the main report, you are then presented with the detail. What I'd like to do is "hide" these details from the users' v...more >>

I just installed SP2 for 2005 standard edition and am getting the following error when trying to use report server: "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.43'. ...more >>

If I type in a query I get a fields list. However I do not with a stored procedure. I have tried pressing the Refresh button. This does not work. I have tried entering the fields manually, but when I get to the value column, the expression builder tells me that the dataset has no fields. ...more >>

Please, help me!! I have Win XP SP 2 and SQL Server 2005 including Reporting Services. Under the default settings it works properly. I need to implement Forms Authentication. I followed the step from http://msdn2.microsoft.com/en-us/library/ms160724.aspx. The UILogon page appears but when I ...more >>

We didn't backup the reportserver as we should. Today when enduser access the report server (web), it reported errors on connection to reportserver db. Is there a way to repair/recover the reportserver db? Can someone point me to directions? We can re-deploy the all the reports, but I leave i...more >>

I want to know with expression that how to add a txt file in report design so when report is viewed text of txt file can also be viewed in Browser. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200704/1 ...more >>

Can we show a ReportItem (e.g. TextBox) on every page of report? How could we achieve this -- asharma...more >>

How to change Chart type dynamically? -- asharma...more >>

How to use dual axes in Reporting? -- asharma...more >>

Is it possible that Expanded Columns remain in Expanded format while refreshing the report? When we refresh the report or navigate to same report, the expanded columns get Collaspe. -- asharma...more >>

Is it possible to set or change the location of any control at run-time? -- asharma...more >>

Is it possible to set the properties of report parameters? I want to show/hide parameters at run-time. -- asharma...more >>

Is it possible to fix the position of the Report Header and Footer while scrolling? -- asharma...more >>

In cascading parameters if we change the value of parent parameter then the child parameter must reflect the changes … means it should set “Select All” automatically as default. -- asharma...more >>

How to show the values of a group in charting using tool tip? -- asharma...more >>

Hi all, What is the best way to find out what SP a Report is calling? (Other then looking in VS project) thanks gv ...more >>

We have uploaded a report that works fine in development and works OK most of the time on the production server but produces this internal error from time to time. Any advice would be REALLY appreciated. cheers, Paul. w3wp!library!6!12/04/2007-19:15:56:: i INFO: Call to RenderNext( '...more >>

I input for "Jump to URL". But I don't want to open URL on same page. Is it possible to open new window for that URL page after click one which have a "Jump to URL". ...more >>

can you use a command like href="mailto:user.user@nzblood.co.nz" in a report as a hyperlink or "something else" to generate emails. Cheers ...more >>

I am having trouble with a simple date conversion in a table. I have a field that is stored in a legacy system as a text value. When I bring the data into reporting services I need to convert it to a date, however, some records have invalid date formats, which cannot be converted. I tried to ...more >>

Hi, I have a series of columns which I need to be able to change the background color of dynamically depending on a date which is computed dynamically when the report is created. I a using a textbox to display the dynamically calculated date (e.g. =DateAdd(DateInterval.Day,5,Today).ToString(...more >>

I am running SQL 2005 Reporting Services and designing reports via Visual Studio. Is there an easy way to reset/clear the report parameters back to the defaults while viewing the report in IE. Right now I have create a hyperlink which will re-direct to the URL of the report which thus se...more >>

Has anyone seen report-pack for Reporting Services? Similar to one that is available for IIS, GPS etc. Or other option is there any database schema description of the "ReportDB" for Reporting Services 2005? -- Thanks in advance - Sunil. ...more >>

The Reporting group in our company uses SRS 2005 to generate most reports for the Company. Many of these reports are distributed automatically to our clients. An increasing number of these reports are distributed as Excel spreadsheets. These Excel reports generally contain multiple workshee...more >>

I have an image defined as: ="http://server.name.com/images" & IIf((Left(First(Fields!logo_url.Value, "DeploymentDeliveryHeader"),1) = "/"),First(Fields!logo_url.Value, "DeploymentDeliveryHeader"),"/BlueBar_withGraphic.gif") I want to move this image to the report header. But am getting a m...more >>

We need to have the same basic report available both within the application and outside the application. We'd like to find a solution that does not require us to maintain 2 copies. Within the application, we do not need report header information as it will be supplied by the app page. Outsi...more >>

hi i would to get some help from you guys. i am doing an item catalog, basically the page will be full of pic and descriptions. i have done the horizontal part like 3 pic and their descriptions in a row by using matrix and list. my problem is, how can i display the header of each catagory just...more >>

I have a report developed using Reporting Services 2005 with SQL Server 2005. It runs just fine, and printed fine up until a few days ago. Now, after I run the report and it displays on the screen, clicking print causes the computer to reboot. Not all the reports do this, just this one. I ...more >>

I have a report that contains two watermarks. I need to modify the text in the watermarks but do not have the original GIF files. Are the image files saved somewhere in RS so that I can access them? ...more >>

Hi I want to add txt file in my report and it should view in Browser. I need the expression also. Thanks and Regards -- asharma...more >>

I have a report that runs the following in it's query: " (SELECT cast(d ..ACT_DT as TIMESTAMP) FROM GPROD.VSL_ACT d WHERE d .ses_num = gprod.vsl_act.ses_num AND d .seq_num = gprod.vsl_act.seq_num AND d .act_dt > gprod....more >>

I have a problem getting my reports working in the designer in vs.net 2005. I have migrated a sql server 2000 report server project to 2005 and added my custom data processing extension to the config files. The reports works in the report server but although I have added data extension to both R...more >>

When I run a report under Firefox, it works fine. If the report contains a drill through, and I drill through and then try to back up, the report will spin and never refresh unless I manually click refresh. Steps to repro: 1. Create two reports, one with a drill through and the second ...more >>

Hi Group, How can I get the page number while in report body ? I need to show/hide some controls, depending on the page number. Any solution is welcome ! Thank you, Cata ...more >>

I am attempting to set up SharePoint and Reporting Services to run in Integrated mode. I have successfully in stalled MOSS 2007 and Reporting Services. I've installed SP2 for SQL Server and configured Reporting Services to run in Integrated mode. For some reason I cannot get the Reportnig S...more >>

Is there a way to reuse a data set in a report? Example: report has 2 data sets, ds1 and ds2. ds1 calls a sproc that returns the data. ds2 use the same data but filters it and displays it in a different way. the queries that generate the data are long (over 1 hour) and I don't want to cal...more >>

I have a report with 6 parameters that the user can select. Each parameter is made with a separate dataset that goes out to the database and finds the distinct values for that field. When the user runs the report, they can select ANY combination of the parameters. They do not need to select...more >>

What is the difference between Report Server URL and Report Manager URL? What does the URL's look like when displayed? Thank you....more >>

Is it possible to run a .rdl report via command line? What would be the syntax? Thanks Bob ...more >>

Is it possible to print a report directly without having to first preview it using the ReportViewer control?...more >>

Is it possible to execute conditional drillthrough reports i.e. to execute a different report based on the values contained in the main report?...more >>

What is a way of obtaining and licensing SQL 200 Reporting Services? Is it available for a download? Thanks ...more >>

Can I have an instance of Reporting Services 2000 on the same server as an instance of Reporting Services 2005? I have a client that has two separate business units that share a server. One of which has the budget and desire to upgrade, the other does not. Thanks, Carla ...more >>

Message in Preview window (RS for sql server 2000) ------------------ The data set ‘Subscriber2’ contains a definition for the field ‘cnt1’. This field is missing from the returned result set from the data source. ------------------ I ran my query in the datasource window, and it r...more >>

Hello, I need to display a percentage calculation from some values in a table footer row, and I want to display that in a separate textbox not in the Report table. I hope this can be done simply without having to create an additional dataset and display the value from the additional datase...more >>

I need to impersonate to allow my asp.net ReportViewer control to load reports from my SQL 2005 reporting server. I have two ways of doing that and I was wondering which way was best practice (or if there is any better way): -------- Method1: impersonate in in web.config identity imperso...more >>

Hi All! has anyone succesfully goten RS to work with MySQL? I can get basics to work, but I keep failing when I try to use parameters. the stuff I have found on the web has not been helpful... any suggestions or help would be greatly appreciated. I sure don't want to go back to Crystal f...more >>

I have SSRS installed, but when I try to navigate to it via IE, I'm prompted for my username and password even though I'm using Windows integrated security for SQL Server. What do I need to do to create/access reports?...more >>

Each of my clients' data is in a separate database with the same structure but different data. I wrote a master report. I created links to this report for each client in separate client folders. I parameterized the data source connection string: ="data source=" & Parameters!SrvrName.Value &...more >>

Hi, I have 30 datasets in my report. But I will be using these datasets based on the input parameter. Say if the input parameter value is 10 then I will use first 10 datasets. if the parameter value is 15 i will be using first 15 datasets and so on. If the parameter value is 10. Then I am ...more >>

We have been using SQL 2005 reporting services for a while but recently when some one tries to print a report they will get a BSOD and the machine reboots. Any Ideas????? ...more >>

I have generated report containing two line text in textbox value: <Textbox Name="Label7"> <Value>FIRST LINE SECOND LINE</Value> Winforms ReportViewer preview breaks line in the middle of word: FIRST LINE SEC OND LINE How to force line break to occur after first line so that output is...more >>