I'm experiencing a problem with a webform which receives a binary steam back and display it as a PDF. The problem that is experienced is when the report reads parameters from the querystring passed to the webform. The parameters passed to the page will then be passed to the Reporting Ser...more >>

I have a report with a large result set that can be grouped multiple ways. Is there a way to give a user the option to change the grouping level at runtime. For example if my data was grouped like this: A B C C B C C But instead of seeing the grouping broken up ...more >>

I am attempting to add a date parameter to a RS MDX query. Below I have included my query. I have been following a olapasandrs.asp white paper on microsoft.com, but I keep receiving an error message - "The expression for the query 'query name' contains an error: [BC30648] String constants must end...more >>

Is it possible to call a web service in a reporting services report? I was thinking along the lines of somehow adding a web reference like you would for a normal project and then using it in the Code part of the report. Cheers, Dune....more >>

As we all know, SDL is represented as XML format. I found that representing the report layout in XML make the size of report grow very fast and hurt the performance significantly. I am currently working on a project with complicated reports. When the report size grow to several MB, editin...more >>

Hi there. I need to know if there's a proper setup to have SQL 2k Developer Edition and SQL 2k RS Developer Edition on top of Win XP Pro to demo some reports. I have locally installed VS .Net 2003 professional, SQL 2K Developer, SQL 2K RS Developer, SQL 2K AS and IIS on top of Windows XP a...more >>

I am an issue running reports through a Netscreen (Juniper) box and have found nothing on Juniper's website that addresses the issue. I can access the Report Manager easily and enter parameters for a report. However when I click on the View Report button I get a permission denied error when ...more >>

I want to install RS Report Server component but I don't want to install Visual Studio. Can it be done ? Because the installer always check for Visual Studio .Net in the beginning. Thanks...more >>

Hi All, I have just installed Reporting Services on our production environment. Everything is set up, the permissions etc and all seems fine until we try to publish a report I get the error : Error rsAccessDenied : The permissions granted to user '[User Name]' are insufficient for performing...more >>

How do I enable these for parameters? Thanks Frank Ashley ...more >>

I have 3 parameters which I populate from 3 sprocs. However, I want the value selected for sproc1 to determine the possible values in sproc2 and the selected value in sproc2 to determine the value in sprocs3. How do I go about this? Thanks Frank Ashley ...more >>

I have a report which has a table with 2 row groups, and a detail row. I would like the records to sort descending at the detail level, ignoring the groupings for the sort (this would probably have the groups repeating often, but that's okay), but still grouping sequental records together. Does ...more >>

I have a report that will print a cover page on card stock and supporting documentation following the cover page. The final report will contain many instances (records) of a cover page followed my supporting documents. Is there, or will there be a way to change the document settings from wit...more >>

I'm tying to get subscriptions to work, but am not having any luck. I can create a timedsubscription ok, but it never seems to execute. It does create a job on SQL that executes ok, but the 'Last Run' never gets updated in the Report Manager and the email never gets sent. Where can I look to s...more >>

Is it possible to perform an SQL query on a ReportingServices DataSet... I would like to write a statement like this: SELECT COUNT(DISTINCT ServiceID) FROM RS_DataSet WHERE ServiceStatus = "ACTIVE" I know it would be easy to create a new DataSet with this query... however RS it getting t...more >>

Hi I am having a lot of trouble getting reporting services to accept the format of my datetime parameters. I keep getting a cannot convert char string to small datetime errors either in visual studio when I preview the report or if builds correctly there then it errrors out when run through ...more >>

This Question is for Microsoft stuff. Can you please tell me if we will be able to include RTF formatted text in to reports? Thank you,...more >>

OK this is kinda confusing so I will try to be clear. I have multiple users of my site. They come in like: joe.mysite.com DBName=joe fred.mysite.com DBName=fred steve.mysite.com DBName=steve I have 2 questions.. 1) I would like to make my report 1 time and have the users have the option...more >>

Hi, I have report which requires a long body. But it seems RS doesnt allow body size more than 160 inches. Pz anybody suggests how can we overcome this problem. Thanks...more >>

Does anyone know of a way to dynamically show / hide a subreport based on the record count. I need to be able to hide the subreport if the dataset used for the subreport doesn't contain any records. Also, I'd like to dynamically change the order of subreports depending on data chosen for th...more >>

I have a report that shows/hides group detail with the + for expanding the group. When the report first displays the detail is hidden (as it should be) with the + showing. However ... the cursor will only change to a finger (pointer ... whatever) when the cursor is placed to the left of the ...more >>

We are trying to run Microsoft CRM and SQL Server Reporting on the same server. We have experiemented with several approaches but with no luck. Either SQL Server Reporting's Report Manager will not run with an error that session state in disenabled in ASP.Net or I get an error that there is a p...more >>

Is there a way to name a subscription? When I go to My Subscriptions tab, it just gives me all the subscriptions. Though they are the same report, and sent out to the same person, they have different parameters, and hence require different subscriptions. Right now, I have to go to each subscri...more >>

Hi, I have configured SQL Reporting Server to delivery my reports by smtp. It works correctly, but untill I use smtp authentication. I have changed: <SMTPAuthenticate></SMTPAuthenticate> to <SMTPAuthenticate>1 <postusername>di3</postusername> <postuserpassword>Di300</postuserpass...more >>

hi all I am trying to use the RS wizard to create a matrix report. I pass in the call to the stored proc " execute dbo.PAQS_01 @EndDate " and get this eror message. There is an error in the query. Implicit conversion from data type sql_variant to datetime is not allowed. Use the CONVERT f...more >>

I am new to reporting services Is there an example of how to obtain user logon information to use as input for queries before report renders. We will deploy reports to a portal and want to use the user logon info as a filter for initial queries ( for example to restrict information viewed by...more >>

Is it possible to have a parameter to run different reports depending on what the user select for the parameter? For example I want to have Employee, Customers, Inventory, etc for the report parameter. When the user clicks on Employee it will bring the employee report with all the paramete...more >>

The web service exposes GetPolicies and SetPolicies. Setting a policy for a folder item is pretty straight forward. However, there doesn't seem be to any AddPolicy functionality. If you use SetPolicies to say, add a policy for a new user, it deletes all existing policies. You have to basi...more >>

I have a .NET web app that uses the ReportingServices object to render reports. I receive a binary stream back and display as pdf. This is and has been working fine for months. This morning, I tried adding some logging to my SQL stored procs to see the usage on some of the reports and I fo...more >>

Currently - we have Action only in Data in graphs. I would like to specify a different Action for Category Groups and Series in graphs. Appreciate your answer on this. Thanks ...more >>

I have a problem with missing data as I created a matrix with column headings as MONTH and now if there is some data for a particular month missing, that month header is left off and whole data table is corrupted with future months data lying under the wrong month. Can somebody tell me a trick...more >>

I have a report with a data source that requires credentials to be stored in reporting service system. I use the CreateReport function to deploy this report but it doesn't store the credentials and these credentials are requested when it is about to render. How to store these credentials...more >>

I am creating a report in reporting services that will span over several pages. The report contains a group and then rows of items. The number of rows can vary from 1 to 20. If a new group is created and its rows will not fit on the page, I want it to create the next group on a new page i.e. in...more >>

Hi, I set up a standard subscription and am rendering the report to excel. After recieving the email, I open the excel report and it displays a bunch of garbage. Is there a known issue or a patch out for this?...more >>

Is there anyway to make a whole chart be a click-through to a report? In other words, I want the complete chart, the whole square, to be a link to another report. ...more >>

I have since modified a deployed report by putting a pie chart on it. I run the report on my develpoment PC and it shows fine, i deploy the new reoprt and it is not showing the updated information. I have tried deleting the the old report and uploading the new report, but still i get the old r...more >>

I am using Data-Driven Subcriptions to send a report to different recipients using different parameters. I would like to know if Reporting Services can: -- update a database on successful distribution of report. Simplest example: I have bit in table of recipients that determines whether t...more >>

Can you tell me if this is a bug? My browser language (Internet Explorer version 6) is set to English (United Kingdom) [en-gb]. I have 2 reports based on the AdventureWorks2000 database. The first report is: SELECT PurchaseOrderID, EmployeeID, OrderDate FROM PurchaseOrderHeader ...more >>

I am trying to create a recipe book report using Reporting Services that will show a photo for each recipe. The images are all stored in a folder on the web server, with the file names stored in a database table (SQL Server 2000). I don't want to embed images or have to include them in the p...more >>