I am trying to create a Matrix that contains two static columns followed by x number of dynamic columns. Ex. (x, y and z just fill in space and are not relavent to my problem) staticCol1 staticCol2 dynamicCol1 dynamicCol2 ... row1 x x x ...more >>

Since I can not directly use a field value of a dataset in the header and footer section of a report, I'm trying to store this field value in a variable in the custom code. Is there a way to do this? Thanks......more >>

I need to generate hundreds of snapshot reports, which would be refreshed every night. Each employee would view a snapshot report pertaining to his employee number (which is the parameter in the report). The employee is not allowed to look at anyone else's report, and the company doesn't want ...more >>

I need to generate hundreds of snapshot reports, which would be refreshed every night. Each employee would view a snapshot report pertaining to his employee number (which is the parameter in the report). The employee is not allowed to look at anyone else's report, and the company doesn't want ...more >>

Hi, I have created a report that displays order summaries based on a parameter CustomerName. I have many customers and want to give them all access to this report. I've installed the Forms Authentication sample and am able to authenticate, so each customer has a login. The problem is...more >>

I try to modify the RSExplorer example by using form authentication. I have create a window logon form. Could anyone can help me how to integrate form authentication and the sample together ??? Actually I don't know how the report server can regonize the logon user. Thanks...more >>

Hi, Can someone tell me why Underlined text with bold comes as only underlined when exported to PDF Bold is missing Ponnurangam ...more >>

Hi, I'm trying to configure the RS's Security. i 've created two rules, one rule for administrators and the other one for IUSR_machine. I connect to Windows 2000 server as administrator. The problem is that when i access the Report Administrator via URL, it applies the rules of the IUSR_m...more >>

My CIO bought and is pushing for me to deploy Hyperion Performance suite reporting as the enterprise reporting tool... I farking hate it... Is MS SQL Reporting services mature enought to be relied on for enterprise wide reporting? I am risking my job on this fight... thanks ken...more >>

It seems like it is only possible to make a snapshot if I set default values to all parameters. What I want to do is: - The user generates a report manually after entering some parameters - The user can decide to save this report as a snapshot by pressing on the "New Snapshot" button Is it ...more >>

I am trying to use the generic query designer so that I can add dynamic parameters. My problem is that my query contains double quotes already, ie: SELECT PRODUCTION_DATE, TESTDATE, "524CLPRXD1_CONS", "524ALPRXD1_BRITE", "524ALPRXD1_PH", "524ALPRXD1_COND", "524TLPRXD1_TEMP", ...more >>

I have a report where I have a date parameter, with two non-queried available values. One is Today, which has a value of =Today(), the other is Yesterday, which has a value of =Today.AddDays(-1). Both work in the designer perfectly. However, when I deploy the report and try to set up a su...more >>

I googled around a bit today and couldn't find anyone with a wiki for Reporting Services. Has anyone considering putting one up? I think it could be very handy - a place for the community to contribute tips, bits of code, etc. It could also serve as a home for an up-to-date FAQ. (Some que...more >>

Hi all, I want to set parameter's value for the report using web service. I am not using URL access method to access reports. I am working on simple report which gives list of airlines. I have to pass airline range scope and from and to value, which i will get from user. I badly need some ...more >>

I know you cannot directly place data fields in the headers or footers with SQL server reporting services. You can trick it by putting a hidden text field in the body of the report and referencing it in the header or footer by using ReportItems. How do you display SQL server Image data fields...more >>

Hi! When I GetScheduleProperties, I would like to control the language of the returned schedule description. Any thoughts on how I might accomplish this? The language of this schedule description changes when I use Report Manager, so there must be a way to accomplish this. Thanks in a...more >>

I would like to hide the top part of the report viewer ( the section withthe tabs) and change the color of the bar that has the parameters and the "view report" button I seems that the Style sheet only affects the upper section ( the one I want to hide ) TIA Ray -- Illusion is the f...more >>

Hi, I'm wondering, is there any option/tool that could let me monitor a database's memory. There's a maximum amount that we can allow, and it would be nice to have some kind of alarm/warning message that would tell us we're at our maximum, or close to it. Thank you kindly. Marc...more >>

Hi, Does anyone know when Microsoft is releasing next version of Reporting Service with all the issues resolved Ponnurangam ...more >>

Hello, I want to setup authentication so that if any requests come from a certain ip address they are automattically accepted. Is there an easy way to do this or is using some kind of custom extension using forms the only way? Thanks, David...more >>

I have a main report with 2 subreports as the only items in a list control. I am linking the 2 reports to a field in the dataset of the main report. When I view the report from the report manager or just from the report URL it looks fine. When I export to PDF the first page is blank. T...more >>

I'm trying to add expressions that will highlight the highest/lowest values on a chart, but I'm having some difficulty. It's a simple bar chart showing total charges by customer. In an interesting twist, as I was writing this post VS.NET has screwed up my project, I get a 'object referen...more >>

Hi ! I've some parameters on my reports,and i want to filter my report on loading For example, i want to create reports for articles, i have 1 parameter => @Article Can I use the URL to get this parameter like this http://myserver/ReportServer?/Example/Report1&Article=2344 Is it possibl...more >>

Hi How can I generate report using XML file as Datasource? And I need to pass XML Filename dynamically at run-time.. -- Thanks in advance Bhavesh...more >>

I have been thru trial and error making adjustments to the htmlviewer.css to make the reportviewer appear to be more seemless within my asp page. However, the one peice that I have not been able to figure out yet is how to get rid of the fine line around the entire server control. is t...more >>

How can I have a footer on Odd pages only. I currently hide items in my footer on even pages, but there is still an empty footer on odd pages, wich end up by by splitting the odd pages content on 2 pages instead of one. What I wanna do is not display Footer on Odd pages. I now we can do this...more >>

I'm attempting to set up a file share subscription in RS and I'm getting the following error: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help The specified '@category_name' is invalid (valid values are returned by sp_hel...more >>

How can I sepcify a NULL value in a formula? I tried this but it told me to use system.dbnull and that doesn't work either =Iif( Fields!c_first_name.Value = NULL, Fields!c_last_name.Value, Fields!c_first_name.Value) THanks,...more >>

(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width Where does this piece of code actually go for resolving a page-skipping problem in PDF. I went into (Report Designer) Report Property ---> Layout Tab but could not locate where to paste the statement above. I know ...more >>

I'm new to Reporting Services (only about 2 1/2 weeks working with it, but I'm catching on quickly). However one really annoying thing that I can't figure out is how to prevent the report from resizing or "stretching" horizontally once I render my report. In the report layout designer, ever...more >>

For one report we've designed, an HTML rendering will produce 3 detail records. When this same report with the same parameters is rendered in CSV, the first detail row is missing from the output. All other aspects of the export seem to work as expected. This occurs with several reports we...more >>

Is there any way to turn off (or hide) the export function when viewing a report though report manager. There are certain reports that we would only like people to view through report manager, we do not want them to be able to export into PDF, Excel, etc.. Thanks,...more >>

I to am getting the above error when trying to action the following calculation. =iif(CostValue=0,0,Profit/CostValue) I have tried a number of the other solutions posted and these do not seem to work in my instance. Have tried to use Nz function but this is not included in Reporting S...more >>