On a line chart, I am trying to force the y axis to have a minimum of 0% and a maximum of 100%. I have set the min and max values to 0% and 100% respectively and turned on side margins but the chart is still showing a min of 0% and a maximum of 80%...more >>

Hi, I am in need of building reports on the MS SOX Accelerator Databases, does anyone have any idea how I can go about doing this or any idea how to export/transform the XML data? Thank you.......more >>

It seems like you don't need to specify SQL's ORDER BY to match Page and Group breaks in RS. I.e., RS does this handling by itself, with the added work and memory requirements to do it. My question is whether RS will understand that I do have ORDER BY in the query that matches my Page and Group ...more >>

Hello, I have written a stored proceudre where i declare @temptable table, and store the intermediate values therein. Also there are lots of calculations involved inside a stored proc. When i try to execute the stored proc i get an error message saying,"tempdb log file full". I have enough disk ...more >>

I went from having no "From Query" parameters to having about twenty, should this degrade the performance of the query... It sits and spins for quite awhile longer now than before.. What exactly is it doing to get these parameters populated with data...? It's taking about 15 times longer to run ...more >>

When I format my table cell as p0 my data looks like this: 3 (Hutchison Telecoms 3G) 634 22 347 % Orange Australia (Hutchison Telecomms) 253 47 1,858 % Telstra MobileNet 4502 1998 4,438 % Virgin Mobile Australia 523 249 4,761 % Vodafone Australia 2157 937 4,344 % yes optus 635...more >>

Hi, how do you suppress the group header row when there is no detail data? thanks Matt ...more >>

Here is what is happening. I have a working project PROG created using VS.Net. I create a new project for reports RPTPROJ under PROJ. I create several reports RPT1.RDL, RPT2.RDL under the new project RPTPROJ. Now I start the REPORT MANAGER and create a new folder (MYREPORTS) and upload a...more >>

I am rendering a report as HTML4.0 via Web Services interface and the report appears...but only the first page. I notice a small yellow error icon on the bottom of the page and if I double-click it reads: Line: 20 Error: 'Report' is undefined Code: 0 If I view the page source, around...more >>

I have this property set to true for several table header rows in a table that I want repeated on each page. It doesn't seem to be working. it displays on the first page and that's it... Any ideas...? TIA, Dan ...more >>

Hello there, I'm developing web based reports in Reporting Services which renders to an iframe in the browser using the ReportViewer component. When I run it in IE 6, it works perfectly and looks great. However when I run it in Netscape 7.1 (which supports iframes), the iframe doesn't show and...more >>

I have a simple ASP.Net Web App that is used from the internet. I need to give my users access to Reporting Services Reports once they have authenticated by my application. I am using forms authentication agaisnt an SQL Server User Table. My web application and RS are running on the same se...more >>

We have built a new front end to the report server to run reports. When making calls to the RS Web Service, is there anything special that needs to be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC OS X with Office v.x. We thought that SP1 would take care of their ...more >>

Can I merge table cells...? Similar to ROWSPAN and COLSPAN...? ...more >>

I currently have a table that contains one group (details group). The group is named "None3". I need to sum the contents of one textbox contained in the group and put the sum in the table footer. When I do Sum( Fields!AllowanceBunk.Value, "None3") in the table footer, the report gives me ...more >>

Hello... I can use the URL Access method to display my reports...but I want to change and use the web services interface. I can Render the report....but I am having trouble getting the report to display in a new browser window. I want to have the same User Interface (with the report toolb...more >>

i posted before, that the stylesheet parameter doesn't work on my server. i searched the logfiles and found this entry: aspnet_wp!configmanager!d60!08/09/2004-08:13:11:: i INFO: User specified style sheet does not exist: D:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\s...more >>

Report runs off of a stored procedure that is pulling a month, a year and a qty. I'm displaying the qty in a table row under a column heading for each month by using an expression to print in the proper monthly column. Now, I'd like to sum 3 months to show the QTY for a quarter.... how can I c...more >>

I am trying to build a new dataset based on existing set, by appending a total value to the original one. (So I could pass this new dataset into a bar chart to plot) I know the sum(Some_column) is in the report domain, since we can access this value in designer. But my question is how can...more >>

I have a bar chart, displaying different bar length with same value ( 5 input with exact same value but in different series group ). Please help. -- Sincerely...more >>

I have to use one report with several databases. So I've created several Shared Data Source objects with different database's names in connection strings. And now how can I switch between these Data Sources ?...more >>

I want to send the commandtext to a rdl report through vb.net/c# code. How can I do that ? Plz help with code thanks anand sagar...more >>

I am trying to have a horizontal bar graph which has a single bar, which has spacing top and bottom but none left and right of the bar, however the "side margings" doesnt seem to work, has anyone got any ideas how to do this also I need the single bar to be as tall as the grid almost, so I nee...more >>

I'm trying to get a value from a specific row something like:- =Fields[2]!Data.Value where the 2 is the row of data i'm after. Any ideas? TIA, DF...more >>