hi all i m in need of a report definition language generator is there anyone who can suggest some download links or if u have it u can plss mail it to me senzy_phil@yahoo.com ...more >>

Hi, I’m using the report viewer object to view a report which works fine until I need to pass null values. When I use the following code I get “The 'reportId' parameter is missing a value”: ReportViewer1.ShowParameterPrompts = false; ...more >>

Dear Experts, Is there an executable file which we could run and deploy reports? This tool would ask which reports to deploy, where, using which datasources, etc and it would deploy them. Manually deploying reports through visual studio is inconvient for us and we want anybody to do it....more >>

I have seen this question asked several times but none of the solutions have worked for me. I am running SRS 2005 and have a very basic report written. I am wanting to sum a detail field in the footer. My code in the footer goes something like this: =sum(fields!<fieldname>.value) Wh...more >>

Hi Experts, We have a stored procedure that takes a long time to execute. It takes 4:45 sec. When we execute the report it shows "Reporting is generated!" for 5 minutes. Is there a way to generate dataset asynchronously as it is being executed? Show first page fast and keep getting ...more >>

I have a report that looks great, but when I export it as a Web Archive and try to print it, it won't pick up any background colors. They all show when I view it, but when I print, they all go away. I have conditional statements on color for different cells, and they're all showing the right ...more >>

I have a need to add a text box to a report. The text box will have an expression that I need to have that captues the value of a field from a second data set associated with the report. I add a text box but in the edit expresssion process I can't access any fields (from any data set) and i ...more >>

Is there any way to use style sheets on our reports we create with BIDS? Trying to have consistent template to re-use as we create new reports. ...more >>

Hi, I have just installed Reporting Services for SQL Server 2005. I went through the configuration tool and everything went smoothly. However... when I navigate to the report manager (http://MyReportServer/reports) I see the page OK and the header is all there (i.e. Labels like "SQL Serve...more >>

Hi, during the install of VSTS - I get the errror that Reporting services are not configured correctly. This seems to be due to the Web Service Identity not being configured. (This WAS configured and fine before installing SharePoint & attempting the VSTS install) If I try to edi...more >>

I've posted a topic twice now, and I still can't see it. If I change the settings from Topic Summary to Topic List, I can see it, but when I click it, it says There are no more messages on this topic. All messages in this topic may have expired or been deleted. Is this happening to anyone ...more >>

I want to combine my matrix and my chart for the current selection on a single page. As it is now, I'm stick with all of the results and the chart below in. I also have parenting on the left side... however... the only way for my chart to show the selection from the left, I have to put it o...more >>

Does anyone know of a way to assign alot of users to role assignment browser quickly? Anything would help...more >>

I n my report i need to have 3 tables, these tables using same dataset, the difference is between these tables is using different field names. I have parameter which is (All, 1, 2, 3),. So if i select All then i should view all 3 tables, if 1 then view first table t.e.. Please could you give m...more >>

Dear MSDN! I have designed a report in VS 2005 Report Server Projekt. The report connects to a Analysis 2005 server. Everything works fine in Layout tab and preview tab until i click data tab. After i have clicked the data tab the report starts to show errors in the output and error list wi...more >>

Hi, We are running SQL 2000 still and I would like to implement reporting services. When I install reporting services on the server will it require a reboot to complete the installation? This is a production machine and I'd like to install it during normal working hours but obviously can'...more >>

I have a data source with a column that is a boolean data type. When I render this data on the report the value of 0 displays as "False" and 1 displays as "True". I would like 0 to display as "No" and 1 to display as "Yes". I am assuming I have to set up an IIF statement that evaluates the va...more >>

Hi All, I am using SQL Reporting Services MOM Reporting. I set up some reports and they have been delivering flawlessley now for over a month. Now this morning I got the error: "Failure sending mail: The transport failed to connect to the server. " It isn't descriptive enough to know wh...more >>

Is there a way to apply special formats to alternate rows in a table in SSRS 2K? I want to set the background color different for the alternate rows. Thanks. -- moondaddy@newsgroup.nospam ...more >>

I have a report that shows product available for employees in the outlet store. A person who is responsible to price product is asking me if it's possible to enter prices in while he is looking at the report. I was thinking to have a link on the report that will open a new window with a simp...more >>

I have reportitems in my footer which reference fields embedded in a table. If I set the fields in the table to hidden since I do not want to display them there, even though they appear to display as expected in the footer, when I render the output to pdf or anything else the data does not sho...more >>

I've got a report that prompts the user for a few inputs through parameters. One of the fields is "Shift". The values are 1,2 or 3 and the user types what they want. Its not a drop down. What I would like to do is select all shifts if the user leaves it blank or selects "All" or whatever...more >>

I would like to sort the following matrix data: July-07 Aug-07 Sep-07 Type A 5 1 4 Type B 6 3 3 Type C 4 2 6 Other 5 5 5 by the maximum date column (i.e. Sep), please note this month will change each month July-07 Aug-07 Sep-07 Type C 4 2 6 Type A 5 1 4 Type B 6 3 3 Other 5 5 5 ...more >>

Anyone know how I can *not* save data with my SQL 2005 Reporting Services reports? I've looked everywhere, google'd, etc. You could do this with Crystal; can you do it with SSRS? I've got lots of reports and this just doubles the # of files to deal with... TIA, Mike...more >>

Does anyone out there know how to programatically determine the Role(s) of the Logged In User running a report? Thanks, Bill Mell ...more >>

Ok, I'm working on a report, it will give a list of pet charts, the main page will have all the data for the pet, and each pet visits an office for a checkup or problem. Each visit will be on its own page. I currently have this working with a sub report. What I need is the data from the pet ...more >>

Reporting Services functionality appears to be available for SQL Server 2005 Workgroup Edition; however, Workgroup Edition setup.exe does not present an installation option. Any advice would be much appreciated....more >>

I have several reports in a project that I deploy to a debug/development environment and to production. I'm writing some different kinds of reports so I created a new project. I've created different folders for these new reports to go to. I updated the project configuration to point debug a...more >>

I am running a stored procedure that calculate scores for each measure. What I would like to do is add all the measures together to get a total score. The problem is, if there is more than one row of detail, the score for that measure increases. The detail rows in my stored proc correspond ...more >>

How could not repeat the description over and over in report with description group? Regards -- Jose Valentin Rodriguez MCP-GP MCBMSS-GP...more >>

Hi I want to hide a part of the toolbar "the part where you can export" in my report, but I still want to have my parameters visible. I have searched for commands like &rc:Toolbar=False but that command disables even the parameter view. Any suggestions?? Thank You Lars...more >>

OK, I've finally integrated our reports with our application and everything is working as I want it except for one thing. I have a report that hides the employee id so that users can only run a voucher report against their own vouchers. This works like a charm except that the employeeid sh...more >>

In my Tabular Report i have 6 columns, for example; Column1, Column2, Column3, Column4, Column5, Column6, Column7. Seven different fields. My parameter is these 7 fields. So if i check only 3 fields, then i would like to see only 3 columns in my report. Is this posible? Thanks....more >>

I'm running ssrs 2k and need to put a sub report in a table row. I ran a simple test by creating a sub report with no data source and just has textboxes with different colored backgrounds and named it zColors.rdl. I dragged zColors into a table cell in the detail section. I also dragged a ...more >>

Is it possible to add hyperlinks to a table report. I have been asked to add a link for each result in a table report to a specific webpage. I build the link to the webpage using queried data. (i.e. ="www.mywebsite.com/mypage/transientkey=" & fields.transientkey.value & "&CompanyNum="...more >>

Is there a way to set the report description from the SQL Server Business Intelligence Development Studio? It would be nice to set the description there and have it deployed along with the report instead of having to create/update the description manually. If not can someone at Microsoft co...more >>

Hi experts, I am working on MSSRS 2005 and i want to know few things about it. I am developing reports on my system and deploying them on my client server. Now There are some reports which i dont have developed and i dont have their design and query. Now if i want to modify them how i ...more >>

Hi, I have 2 DBs with the same Tables (different Datas). Now I will create a report over the Tables of one DB. But the user should connect the report to the other DB. Can I create a dynamic Connection in a report? Or can I Use report parameter to set up the DSN? Thanks. Jens ...more >>

Hi I'm using the ReportViewer.Winform control verions 8.0.0.0 runtime version 2.0.50727 in my C#.NET client app. I'm experiencing extremely slow performance rendering simple reports 35sec. I'm using 'Remote' Processing mode, when I step through my code everything is fine until the SetParam...more >>

....Newbie alert... I am picking up a project that makes significant use of SQL2005 reporting services. The app, as it is currently, triggers the report by launching a new window with a URL pointing at the report server and including the parameters rs:Command=Render&rs:clearsession=true...more >>

I have installed the reporting services, configured them, created a demo report that previews. I cannot get a deployment to operate without an error. "Unable to connect to the remote server (Microsoft.ReportingServices.Designer)" If I go to my localhost/ReportingServices/Home.aspx it fail...more >>

Were working on a classic asp app and are trying to implement some reports through reporting service. I have a few questions. First the application were working on will have multiple instances, so one a single server there can be upto 15 identical apps connecting to different databases, is the...more >>

We use a scheduling package to coordinate the scheduling of our batch processes on most of our systems. Is there a way to trigger the running of an SSRS report this way? And, what the specifics of what is takes with some examples of how and what needs to be interfaced? Thanks, ...more >>

I have created a Custom Data Extention to query SharePoint List data directly from within Reporting Services. I would like to replace the Generic Query designer with my own code to make selecting columns or adding selection critera an easier and more friendly process and can see that Microsoft...more >>

I love the use of the iif statement for visiblity when certain criteria are met; however, when I apply this to columns in a table my page does not resize to either get smaller when the visible columns disappear. Is there a way to resize a page width when visible columns become invisible? -- ...more >>

I see that other people have had a problem with this, but I never saw a solution or a work around. Has anyone found a work around to this issue? I want to allow nulls in all the parameters, but I don't want the report to run by itself in Report Manager. And does anyone know if this is fixed ...more >>

I am running SQL Server 2000 Reporting Services SP2. I have data driven subscriptions that are being logged in the reporting services logs as being emailed successfully, but there is no record of them in the email server logs. Only some of the recipeints are not receiving the emails - most of...more >>

I wish to pass the current row to a custom function in reporting services....does anyone have the syntax for this? It would looking like: txtMybox.value = ParseInformation( current_row) Thanks ...more >>

Dear All, We are facing a really strange performance issue while dealing with the Reporting Services 2005. Here are the facts : -RS 2005 calls a stored procedure to display the report -the stored procedure takes around 30 seconds when executed from the Query Analyzer -the same stored proce...more >>

What does that mean: a.. Execution 'q31hav45ug5ptl553ott5tjl' cannot be found (rsExecutionNotFound) a.. a.. ...more >>