Hi Guys, I need to split a tablerow. Currently, I have a table to display multiple rows, with a subreport to display detail rows associated with each row. Problem is, if the subreport is too large for the page it gets shunted to a new page leaving a big blank spot. It's most annoying...more >>

hi all, looking at the previous thread i know how to get a page sum in the footer , but is there any method for me to insert a total sum below the footer? as i cant place a text box in the footer and set the expression as sum of a field in the table.(footer wont allow sum of field) wha...more >>

I'm using an aspx page to call SSRS web services and render reports with in that aspx page. My code is for the most part like that in the book 'Hitchhiker's Guide to Microsoft SQL Server 2000 Reporting Services' on page 595 and for the most part, things are working pretty good. My problem is...more >>

I'm using web services to render a report from the code behind in an aspx page. Aside from images not showing (which is another issue), the page looks OK. however, when I copy the report's html into a test html page in VS 2003, there are some errors. one of which has to do with a colspan ...more >>

I'm trying to create a Report with a sub report of items that needs to be listed in multilple columns. The data is brought in through a sql query into the sub report. The list contains anywhere between 1 and 30 items. I can not get the list to do more than one column. I've tried setting th...more >>

I'm usring RS SP2 and have a cascading parameter. Both parameters are drop down list. When you change the first drop down, the dev environment goes into convulsions and starts flashing. I've done some research and found this issue in a few places on the net but have not found a solution. All ...more >>

We have a report that we want to have it in Excel format, we need export it from sql report and load in Excel and add some other elements like dropdown. The problem is the 100 pages report is 12M when I export it from sql report. After I load it into Excel and save it again, it is only 700k. Is t...more >>

I am trying to render a report with a barcode in it to pdf. When I open the pdf, the line with the barcode is not there. I know the font is on all the necessary machines. Does anyone have any ideas?...more >>

When I try to preview a report developed an on XP Pro box with Reporting Services evaluation installed (Visual Studio 2003), I get a blank screen with no preview. My SQL statement appears to be fine, because I get no errors when I execute it on the Data tab, and see the data that should be re...more >>

Could anyone tell me if you have had any success and are currently running MS Reporting Services on the Internet with Forms Authentication, using the Ufairs example from Microsoft? http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3 Can you ac...more >>

Greetings, I am trying to get the code below to work with no success, I googled the issue but docs popped up provided little help. Basically I am trying to create a directory in RS that uses Forms authentication. Everything works on the Forms authentication side, but it looks like the cooki...more >>

Hi gang, Heres the problem: When I try to run the setup for Reporting Services it fails near the end, stating the following: Product: Microsoft SQL Server 2000 Reporting Services Standard Edition -- Error 29581. SQL Setup failed to execute a command for server configuration. The error wa...more >>

I don't want users to have the "include report" option when setting up an email subscription. Is it possible? I want users to only be able to get a link to the report to avoid attachments in the inbox. I was expecting to be able to set it in RSReportServer.config file, but I didn't find an op...more >>

Hello, I'm having trouble getting the UserID parameter to work. I find that the data filters correctly for me when I log on, but when I test it with other users, they see no data. I have three tables within my report, all of which have seperte datasets. I've added the report parament...more >>

I have a report which uses data from a temp table which is populated by a stored procedure. Knowing that I cannot directly call this stored procedure as it returns multiple result sets, and SQL Reporting services will only return the first result set, I add the results to this temp table. My...more >>

I've come accross the same problem having also installed SP2. Still looking for the answer. I did notice that exporting via the preview window in Visual Studio works perfectly. It's only exporting to pdf via a browser that causes the scrambled images. Does anyone have a work around, bes...more >>

I have a report that is using the drill down feature. So i have 2 detail rows. The first row is field labels for the 2nd details row. What i would like to do is only show the first details row once. I know i can set the properties for each field to hide duplicates but then i'm still stuck with...more >>

We just installed SP2 on our SRS server. However, the client-side printing is returning an error. How can we disable this feature? ...more >>

HI, For setting the subscription features in SQL Reporting services, we have to set the user credentials that will be saved in the report server, instead of choosing Windows NT integrated security. I am able to render the report with data when I set Windows NT integrated security. But if I...more >>

Hi! My question is: I' want to open a PDF file when I click on a field of a table.The values that i have to pass to open the PDF is in the row of the table that I select. I'm using this expression http://ptlisws38/scripts/wfgen/pro/user/show.asp?QUERY=DATASET_FILE_DOWNLOAD&NO_CHARSET=Y&NO_...more >>

The data-driven subscription status looks something like this: Processing: 1546 processed of 4389 total; 1546 errors. Could someone explain where these numbers are coming from? I have a OrderID parameter with only 102 values. Each report is only one page each. Therefore there should only be...more >>

Hi, Firstly, I would like to know if there are any intentions to allow you to hide parameters from the report designer, without having to log into Report Manager after deployment and fiddle around? Secondly, I have a problem. I have a report with 2 parameters. One (userID) I want to set vi...more >>

The Result: Two people using the same computer running RS that connect to different instances on the on the SQL computer, so that one person has no indication that the other is present. The Question: How can I achieve the above result The Plead: All information regarding this problem i...more >>

Depending on the result of my stored procedure logic I need to display different number of lines on the chart in my report. I can not drop the data fileds into the chart design as suggested in the Help, because at design time I do not know their names and how many of them I will have when repo...more >>

how do i know if my version contain Service Pack 1? i can not found...more >>

On a shared schedule of 15 reports, this message is appearing hundreds of times throughout the log file. Typically increasing the logfile by 2.5MB per run! Despite these error messages the reports are still created as expected. The reports have undergone many changes and I think these messa...more >>

Hi I need to do a SQL Migration for a client and they use SQL Reporting Services. I cannot find anything on the web on how to move the Reporting services databases (reconfigure the front end to point to the new RPT Services databases). Can you please advise? Many Thanks -- Reg...more >>

In my ASP.Net application, I need to give the user an error message when a report is empty. Sometimes there is an exception that gets thrown and sometimes there is not. How can I tell if the stream coming back from RS contains an empty report?...more >>

Where do I locate the MDX queries for reporting services queries and reports? Is there a container that keeps track of this and how can I get at the MDX? ...more >>

Hi, I'm trying to deploy reports from the dev. environment and I'm getting the error: 'The permissions granted to users 'server\user' are insufficient for performing this operation.' That is not the user that I am logged onto my development machine, nor is it a user on the report server. W...more >>

How come I can't assing an ID as type Integer to any of my report parameters? It always tells me that the datatype is wrong. I want to make sure I am using the report parameters correctly. How do you add a parameter to a report that will either be selected from a drop down or passed in vi...more >>

I've posted this question 10 days ago, but nobody reply me, I know this is a not common question, but I need some help and I don't know were I can find it, documentation on reporting services is a litle poor on this tip. This is the question: I have a table report with 2 groups, like this: ...more >>