Hi, Is it possible to sort a Table using value from subreport with in the table? My main report has the following structure: .... <Table> ... <Header> ... <ReportItems> <Subreprot> my_sub_report which executes its own stored procedure. <...more >>

I try to save in PDF. Everything is ok, but ... Chinese characters. In PDF, chinese characters will become strange symbols. Should I take some setting before exporting to PDF? I had updated RS Service Pack 2, and Acrobat 7.0 Thanks!!. -- work, lots of works...more >>

I've followed the instructions in Robert Bruckners earlier mail about this subject (http://support.microsoft.com/default.aspx?scid=kb;en-us;834305 and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontheadonetdatareader.asp ). But I can't get it to work. ...more >>

hi all, i got a table, how can i get the sum of total ONLY for each page?(not sum of the whole table) thanks in advance...more >>

Dear All, Since Reporting Service is part of SQL Server 2000. Is there any features difference of Reporting Services which is part of SQL Server 2000 Enterprise Edition and Reporting Services which is part of SQL Server 2000? Thanks Robert Lie ...more >>

Hello, I am looking for a way for users to click on a textbox and send an Email. I got that to work if I set up 'On action' URL to 'mailto:myemail@mycompany.com'. My problem is this email address is variable. If a user clicks next to A then Email should go to A@myemail.com and if they cl...more >>

when I create a subscription through report manager it work ,but if I create the subscription through my application (I'm using my own domain credentials to authenticate to the server).It dosen't work. Any idea? Thanks ...more >>

I have a report displayed within a frame. A different frame in the frameset is posting parameter values to this report display frame. The bookmarks on the report do not work when displayed within the frame. The onclick javascript command is not created for the bookmarks. I have the follow...more >>

Hello all - I have a report that I need to export to an existing Excel spreadsheet, but I haven't seen so far any options where I can accomplish that. For example, I have a generic skeleton spreadsheet that contains two worksheets, "PivotTable" and "DetailData". The PivotTable worksheet c...more >>

Is there any way to get a data-driven subscription to share the DB Connection between iterrations? The behaviour we're seeing currently is a new connection being opened/closed for each report delivered by our data-driven subscription. This is impacting our server perf. Suggestions? Pointer...more >>

I set up a view in my SQL Server so that i can query ADSI like in this article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp Everything works fine from Query analyzer, but when i try to select from the view in the Reporting Services Designer DataSo...more >>

Do you need to be running the Enterprise edition of SQL in order to use forms authentication or can it work with the standard edition? ...more >>

I have a set of emails in my app which I'd like to execute a report for them and send it to them "ONCE ONLY",next time emails are changed,parameter of the report is changed and I don't want to have schedules.At the same time I'd like to snapshot the report into the file system.How should I do ...more >>

I have RS 2000 with SP2 on Windows 2003 server. I am trying to directly print a report to a PDF using something like the following: https://ServerName/ReportServer?/GPO_Application/AFE%20v4.00.00&fcobAppID=20030010969&rs%3AFormat=PDF I know the report renders just fine without the PDF forma...more >>

I have a report that is designed with 3 matrices in it -- xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx x x x x x Item Data x x Aggregate x x x x Row Data x x xxxxxxxxxxx...more >>

My users have a lot of reports that they need to generate and save in PDF format. Each report is the same, except using different parameters. What I'd like to do is programatically generate a bunch of PDF report files to a folder on the network, each one using just a different set of paramete...more >>

Hi, We have a report with parameters which works fine but when we want to recover a hidden parameter which comes from a query (doesn't appears as a filter), an exception is thrown. In the report parameters properties, we left in blank the property "Prompt" so that it is not showed as a fil...more >>

In order to batch a group of standalone reports I have included them in a Master report, each as a Subreport. The data displays as expected in all the report Bodys responding correctly to shared timespan parameters, but no Subreport Pageheaders show. Is this a known problem? Is there another...more >>

Definitely a newbie question and I apologize. When I base my dataset on a stored procedure, I can return rows based on the parameters off the data tab. Column Headers and data look perfect. Now I want to add these Fields/Column Headers to the Layout of the Report. Unfortunately, when i cli...more >>

I have reports that users cannot access. They get an error that says rsProcessingAborted cannot create a connection to data source. I checked the security on the report and the user has browser security. I am not sure what else I need to check. Any help would be appreciated. Thanks, ...more >>

I have a dataset with a GROUP BY connected to my table. In the detailrow I want to add a accumulated value calculated from another field. Like this: MonthX ValueY Acc. value -------------------------------- Month 1 10 10 Month 2 20 30 Month 3 30 60 Mont...more >>

Hi, I have to connect to a foxpro file. What I've attempted thus far is set up a System DSN. It's pathed to the .dbf file, and I selected the Free Table Directory option under Database Type. In RS, I choose ODBC driver for my Provider and for Connection, I choose the DSN I set up. When I tr...more >>

Hi all I cant get my head round conditional parameters. I have a report with two parameters and I would like the user to be able to select either one or both of the parameters. IE. Param 1 Firstname Param 2 Lastname The user should be able to enter into the first parameter, or the sec...more >>

Okay, I'm stumped. How does one locate the Reporting Services Error Log so I can see what errors occurred during the Report Manager's rendering of a report? Thanks! Catadmin -- MCDBA, MCSA Random Thoughts: If a person is Microsoft Certified, does that mean that Microsoft pays the bi...more >>

Hi, I recently bought a server with Xeon EM64T-processors and installed the new Win Server 2003 x64 (to benefit from the improved memory structure) + SQL Server 2000 SP3 but found to my horror that the x64 ed. of Windows Server 2003 doesn't support .NET 1.1. We probably won't see .NET s...more >>

Hi All I have a matrix that goes no bigger than 4 colums and 4 rows big. I need to have different colours for certain cells within the matrix. e.g for the first row, i need: Cell1 = Yellow Cell2 = Blue Cell3 = Green Cell4 = Green for the 2nd row i need: Cell1 = Yellow Cell2 = Blu...more >>

I'm stumped on this one. Any help would be greatly appreciated I have a matrix with three row headers that appear like this: |Category 1 |Subcategory 1 |Event 1 | | | |Event 2 | | |Subcategory 2 |Event 3 | The r...more >>

I am trying to debug a problem where a report times out after 60 seconds; the report is calling a stored procedure via ADO.Net. The stored procedure is slow, but acceptable. I’ve set the report timeout settings to 300 in all the relevant config files and the report itself but this had no ...more >>

HELP! Anyone! I have a subreport which renders fine for the first 5 pages on my local site when I'm in Debug mode and previewing. The links to the report are good and the SP that is used to generate the data works both through QA and through Report Designer. But when I pushed the entir...more >>

I need to install the Reporting Service in a production site on the web server. Both web server and database server are mamber server in the same domain. When i install the Reporting Service in the web server in keep having below error SQL Setup failed to connect to the database service for s...more >>

Hi I'm working on a Matrix report in which i have a column grouping. I have added a subtotal for the column group. so this total comes as he last column i.e. after all the values in that column grouping. I want to have a subtotal after lets say 10 columns and then again a total at the end. ...more >>

Sorry if this topic came up before, but today my google search gave nothing useful. There is a report with some parameters, some combinations will give an empty dataset. I want to show the user a hint that there is nothing the reoprt can show because there is no data available. After some ...more >>

Hi, I have a crosstab report that displays the totals of specific data. I have totals on my groupings(rows). I also have made these totals a hyperlink to allow the user to drilldown to see the detail of the count. However, I do not want the totals to be a hyperlink, I need them to be just p...more >>

Dear all, When a user login the domain of server, i have the right to see the reports in reporting services WITHOUT entering the domain password into the I.E. Since it use the user domain from login, it is very convenient, and no need the user to enter the password once he passed the login. ...more >>

I created a table with merged cells - etc. tried to render it and got the following error: Deserialization failed: The table "table2" has rows that contain a different number of cells than the number of the columns in the table (including cells that span more than one column) Is there a wa...more >>

Is the Small Business Server SQL Server license sufficient for the use of the Reporting Services on the SBS (2000 or 2003 Premium) or there has to be separate SQL Server license? Thanks for info, Martin ...more >>

Hi All, I am subsrcibing a report through the Report Manager, before sending the mail, i need to encrypt the data in the report and send it to the user. I can do the encryption but passing the data to a function in a custom assembly and then return the encrypted data to the report and then s...more >>