I'm having troubles when I choose the text color depending on a condition. The report is rendered fine in my VS viewer. Also it's rendered correctly in PDF and HTML formats. However, in Excel , all the rows have the default text color ("black"). I'm really confuse with this behavior... ideas?...more >>

Hi all, I will have to make it possible for one administrator to see one hundred user's report in just one time. What I have done is that I just embedded the module which was passing the parameter to sql reporting server in C# programming code by using looping statement . However,if it ...more >>

I've written an app that automatically prints reports but it takes forever to render and then dump to the print spooler. The code I'm using came as a sample with RS. I was dinking around with the "format" parameter to no avail (using PDF - etc.) This is something I think should take a cou...more >>

Hello, When I tried to deploy shared data sources, there is an error “A connection could not be made to report server to …” I don’t’ what is wrong…. Could anyone please help me to solve this problem? Thanks in advance Chieko ...more >>

Have a report that is working fine. Customer wants to add another field to it. I have a field name of navigationPK to get the field they want. Only problem is is that the navigationPK can be a primary key from any number of tables. Scenario....... Have a usertask displayed on dashbo...more >>

Does anyone know how to put a table within a table? I need to use multiple datasets within one table, but since it will only let me put one dataset within the table, I am trying to put a table within a table but I can't get it to work. Thank you for any help that you can give! ...more >>

When I changed machine name and restarted machine SQL Server is working fine But Reporting Services (Standard edition, SP2) was not working anymore. I ran rsconfig utility passing new name . But After that I am just receiving database and reporting service version are not correct error message...more >>

I'm using the Web service library's ReportingService.Render function to export a report to PDF format. After 90-100 seconds of processing, the call to Render throws an exception saying that "The operation has timed-out", but the ReportServer keeps on grinding at the report. The report is...more >>

I am creating a report using a matrix, and matrix subtotals. I give the user the option of including the reporting hierarchy in their reports. If they want to include it, I would like to hide the subtotal, completely. The reason for this is because if I include a hierarchy within a single fi...more >>

I have a number of fiscal reports that I am writing. Currently, the parameter for year is hard-coded. Ideally, I would like to be able to generate the parameter list so that it offers years in descending from the current year back 5 years or some defined period. In this manner, the report...more >>

I am trying to create a embedded function that will accept a dataset field value and based on the value, make an image visibility hidden or visible in the body of the report. I receive an error that the mathimage is not declared. How do I reference an image in the body of the report. The fiel...more >>

We are trying to use the navigation property to jump to a report. If we select a report from the drop down list we get the following Error: "report cannot be compiled. Verify the report name and that the report is in the current project". I have verified both and it does not work. I've also g...more >>

1).I got an error: subscription cannot be created because the credentials used to run the report are not stored, the report is using a user-defined parameter value.... However, can I solve this issue. 2). Is there any step by step guide to configure subscription. Thanks ...more >>

I have a report that contains a matrix control on it. The problem I'm having is when I export the report to Excel some of the data is not recognized a numeric and I get the green triangle in the corner of the cell. I believe this is due to the matrix having some blank columns along with numeri...more >>

Hi All, This is a repost from last Friday Has anyone used the "Jump to Report" to pull up any one report from a selection of 7 other sub-reports. I am trying to pull up a specific detail report from 7 sub-reports using an individual pin # and the "report type" from the main report. ...more >>

I am getting a "Damage to the file was so extensive that repairs were not possible. Excel attemted to recover your formulas and values, but some data may have been lost or corrupted." in some instances when exporting to excel. I have noticed that a couple other list members have also reporte...more >>

In my report i use many dataset, but i can use dataset more effectively buy using parameter and filter. This is the simple case: I could have many dataset of this select * from RefNr where RefNrID = N12 select * from RefNr where RefNrID = N13 select * from RefNr where RefNrID = N1...more >>

Hello, because I never got an answer on my previous threads on this topic, here is a very simple question to all out there: Has anyone ever been able to use a recursive hierarchy with a matrix (not just with a table)?? If anyone from MS is reading this: A simple "No, you can't do this" w...more >>

Dear Anyone, I want to generate RDLs on the fly. I've searched google and found some topics about it specifically Runtime RDL Generation but the problem is that all of them are just presentations (PPT or announcement for presentations) and no actual samples. Does anyone have any idea where ...more >>

Hello, I have 2 identical databases (identical structure) on the same sql server correspoding to 2 companies. Do I have to create 2 identical sets of reports or it is possible to choose database on runtime? Thank you, Lori ...more >>