I have a calculated field in my data table as a percentage(%) value. This % value is with in a group called "year". My chart is consists of data group by year. How can bring this value to my chart? -- Message posted via http://www.sqlmonster.com...more >>

Hi, I have to prepare a deployment plan for a data warehouse solution which include this: * 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4 processors * 1 OLAP Server (Analysis Services) / 2 processors My reports target the database himself, the olap cubes are here for...more >>

I am trying to select the top n of a result where the date is a parameter and the top n needs to be a parameter. I keep getting an ado error on my sql query. Can someone tell me what I am doing wrong? I would appreciate it. Thanks in advance. if @Topn = ' ' BEGIN SELECT Defects.Def...more >>

I want to set permissions for a report via the SOAP interface. Is there a way to do it? Is there another way? Thanks Scott ...more >>

I am accessing a report via the RS Web Service. The report is based on a stored procedure that looks like this: exec documents_loaded '@begindate', '@enddate' I would like to change the parameters of the stored procedure in my VB.net application through the webservice. Any direction on w...more >>

REPOST: I posted this a while ago and no one responded...I still can't get it to work so I thought I'd try again. Thanks in advance! Hey, I've got the following folder structure that I'm working with. \Transaction Reports \Application 1 (contains reports linked from Transaction Reports)...more >>

Hello, I am trying to install Reporting Services on Windows 2003 server(web box) which is not on domain. Everything goes fine until it tried to create Reporting database on a remote SQL 2000 server(db box) which is on domain. I've searched, searched and searched. No luck so far. Th exa...more >>

Hi, I wonder if this is a wishlist as after a few trials, I can't get the behaviour I want so I suspect the behaviour is not there yet. Essentially, I have a table which I want two views. to stay at a fixed width as I dynamically show/hide a columns depending on the value of a parameter....more >>

I've noticed a formatting problem when exporting a report to PDF format (i.e. the report spans over two pages rather than the just one page as shown in report manager) at a client's site. The client does not have SRS SP 2 beta installed. However, we do have SP 2 beta installed in our home offi...more >>

Can Reporting Services talk to XMLA ? Has anyone done this before ? Doug...more >>

I wrote a long query and pasted it on the Data portion under Command Type: Text. I notice that I can not past to whole query and that it's cutting it at about 32,299 characters... Is this the limit? Or can I change that somewhere?...more >>

What is the best way to create multilingual reports? Other than creating another instance of the RDL file... ...more >>

I have a report layout : PRODUCT GROUP {textbox1} PRODUCT CODE {textbox2} <each intervention> Labour , Material SUM LABOUR {textbox3}, SUM MATERIAL {textbox4} ( sum according to product ) SUM LABOUR, SUM MA...more >>

I'm creating a pdf report that includes links to other reports. I've tried both navigation by url and by report but neither results in the links being 'hot'. Is there another way or a switch to get this to work? Thanks, Neil...more >>

When attempting to export a SQL Reporting Services SP1 report to EXCEL in my production environment I'm getting the following exception: Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help Exception of type Mic...more >>

Is it possible with SQL Reporting Serivces to open reports from a link on a web page and not open them from the folder view area? To clarify, can I make it so a user clicks on a button/hyperlink in vb.net and it opens the report in another window without seeing anything else? ...more >>

Hi, I have a sql syntax executes on query anlayzer and report server, the execution time: query analzyer uses 5 seconds but reporting service needs 3-5 minutes! So I use SQL Profiler to trace the sql executes on report server, the trace result found it uses exec sp_executesql and the part of ...more >>

i have a problem: I have a report and use a mdx code : SELECT {Hierarchize({{UNION({UNION({UNION({UNION({UNION({UNION({[Measures].[Store Invoice]},{[Measures].[Supply Time]})},{[Measures].[Units Ordered]})},{[Measures].[Units Shipped]})},{[Measures].[Warehouse Cost]})},{[Measures].[Wareho...more >>

Hello Is it possible to specify the attributes of the PDF Document Security when rendering a report to PDF? If it is possible how to do It? Thanks -- Carlos Eduardo Selonke de Souza http://carlos.geekbunker.org...more >>

I'm having no luck with Embedded images once a report has been deployed. Anyone have this working? What am I missing? I have simply added an embedded image, and used a image control to display it. The image is a small one. Of course it works just fine within the development preview. ...more >>

Hi, My reportserver machine is in network and i'm developing the report thru my workstation. While i'm deploying the report the message appears "Can not connect to reportserver database.A connection with reportserver database is required for processing." Whats should i do to overcome this prob...more >>

I started getting the above error when I try to preview a report in .NET 2003. I can open the reports and edit them just fine, but not preview. I have tried to create a blank report with no data and no object on the report, I still get the error. I reloaded my machine this morning and still ge...more >>

I have created a report that is generated statewide, grouped by district. I would like to display page numbers within each group and perferably total pages in group (Page X of Y). Any suggestions? Thanks! Mike...more >>

Have a specific problem and a more general request for info. I can view our reports through the Report Manager either on the host server or from my development browser. However, when I try to invoke the Service Render function to generate PDF, I get a permissions error: Microsoft.ReportingS...more >>

I have a recursive report and I want to change the color of the data based on the level its in . So I want the parent to be blue and each child to be red. ...more >>

I have a report, that in addition to its own components, has several sub-reports. This report will ultimately be published via PDF. The report and many sub-reports have an page orientation of portrait, but I have a few that need to be landscape. For formatting purposes, we are putting eac...more >>

I HATE writing stored procedures. I'd much rather write straight SQL with parameters. However, I need to loop a query for a range of dates, so is there any other way to do it than in a stored procedure? What do you call the code used to populate a dataset when it looks like ="SELECT car_typ...more >>

I would like to change the parameter Textbox to a multi-line textbox for a particular string parameter. I have already investigated all the visual studio options, so I think that there must be a code change. Any help would be appreciated. Thanks AuSable Brown Trout...more >>

Hi, when I want to export a report which takes some time to generate, Reporting comes with a login prompt to the server hosting the reports. If I enter a valid user name and password, it continues, but after a while it prompts again. After entering credentials I get a 'you are not allowed to ...more >>