Hi All I have 2 questions regarding the printing of the report. 1) I have an asp.net apps in which there are some links which point to the report.when comming to the printing of the report only one user facing the problem while printing the report from the print button icon from ...more >>

Afternoon I am trying to do a "jump to URL" expression that works as follows: =IIF(isnothing( A FIELD ) , iif crm url etc etc....... , iif crm url etc etc ...........) But as yet can not get it to work. Has anyone tryed something simular? Thanks Steve D ...more >>

How can I align a field with the right margin of the report? With the = Matrix, the report width varies depending on the amount of data. I can = seem to find a way to specify that a control is anchored to the right = margin. Or maybe even centered in the page.. Help? Jerry...more >>

I have a parameter for displaying information from a particular = department, or from all departments. I can do the filter for a specific = department, but how do I set it up so that if the user selects all, I = basically ignore the deaprtment filter? Thanks. Jerry...more >>

I have gathered it is pretty tough to manually run a subscription. I have a shared schedule with about 50 jobs attached. I need to rerun about half of them. What is the best way to rerun specific reports in a shared schedule? I am running SRS 2005 Standard. Also, are there any fixs to t...more >>

Any idea how to have a Report Subscription only email the report or link if there are records returned by the reports query or dataset?...more >>

One of my staff members created a report and published it to the server. The original Visual Studio project has been lost. Is there a way to import the report definition from the server into Visual Studio for editing? I realize that we could hand edit the RDL. I just want to try and avoid thi...more >>

Hello, I published report model based on analysis services database. Everyting looks fine, except that if dimension is joined to measure group not at the lowest level, then this dimension does not work. I have date dimension that for some measure groups is at day level and for others and m...more >>

I have a dataset that queries an Oracle DB. I am getting an error when I try to set a parameter in the query. Basically I have the following: WHERE x.system_num = s.system_num and na.service_id = x.service_id and na.location_num = sl.location_num and sd.device_mux_id = dm2.device_mux_id a...more >>

Is this site supported by Microsoft, or are we just on our own out here?? I have a question for a Microsoft MVP-- http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a4a5ba04-774b-4d41-a035-1cf3487390a6&sloc=en-us...more >>

Hello, When I export to PDF or Tiff, I am getting an extra blank page at the bottom of the document. Any ideas what might be causing this blank page during my export? BTW...SSRS 2005 SP1 TIA!!!! ...more >>

If I specifiy a parameter in my report dataset like @status to filter the report based on a status selected by the user - I can't figure out how to give them the "ALL" option - so that the report ignores the status and displays all the records. -- Arkay...more >>

I have a simple report that outputs rows of data to a table. The data is real estate data and shows a bunch of homes in a community. One of the fields is status. I'd like to have each row in the report with a value of 'Closed' in the status field to appear with a bold font, while the rest of t...more >>

I want to enter part of a parameter value as an expression similar to formatting a global fields e.g. Format(Globals.ExecutionTime, "D"). My parameter is returning XXXX 2006, but I only want the year part of the parameter passed to the expression. Can this be done.? ...more >>

Hello, Is it possible to pass an XML document as a string parameter to a Reporting Services 2005 report and use this report as a data source for the report? I know you can source from a web service, the problem is that the effort needed to convert what I have into a web service will be mor...more >>

hi, I'm new to reporting services, and i'm using custom authorization. I need to create a windows application which will connect to the report server and gets list of all files and folders from the root directory and set policies. I want to know how to retrieve all the folders and files ...more >>

Hello, I have a Report with PageHeader and PageFooter. If i display the published report in IE there are no problems with my parameters there are two pages displayed. But if I export these two pages to PDF I have a blank page with only the header and footer beteen each site with data. Can y...more >>