Hi Does Microsoft have any standard naming conventions for SQL Reporting Services. If yes, does any one have link for the same ? Thanks, Param ...more >>

I need to sort a report in 3 ways 2 fields and one expression. When i add a field to a parameter it says the following: "Fields cannot be used in report parameter expressions" The expression I need to sort on is this =(sum(Fields!p1beløb.Value) - sum(Fields!p2beløb.Value)) / (0.001+sum(Fi...more >>

Hi All, I have a Chart line report that works great except when there are too many data points. The x-axis labels then get too cramped and become unreadable. I saw from another post that to fix this, you right mouse click on the chart object, select properties, select "X Axis" tab, set "Ma...more >>

I can't find a way to set user / group to a role thru the web service, this functionality is availible in the Reports interface, but not thru the web service? Just to note i'v implemented Custom Security, agains a users data store. We need to bulk load 1500 users. Can this be done thr...more >>

Hello, All! Is it possible to get cached dataset from Report server? Now I have to use different datasets: one for the Chart report in rsvcs and another for DataGrid control in ASP.NET. I cannot move DataGrid from ASP.NET to rsvcs. I want to query report server for dataset, which is used fo...more >>

I have a Matrix report that uses a second List box to group text boxes for sub totaling the group and the child columns of the group. The First List box is the underlying group for the report, the second list box is used to group the column (sub)categories. The report displays correctly, and s...more >>

I am using multi-value parameter in SQL 2005. The base query uses the parameter as "where column in @paramname" I don't have any problems in VS environment, but I seem to hit an upper limit problem when the report is deployed and I view the report on http://reportserver. When i chose the "Sel...more >>

Ok I have a sp that returns a number of records, each identfied as being part of a group based on the Type field. Type Name Amount 1 Test1 1.00 1 Test2 1.00 2 Test3 2.00 3 Test4 3.00 What I am using is iff(Type.value = 1, Price.value, 0) When I do this it w...more >>

Hi, I have problems with A4 printing from the RSClientPrint activex. I defined the size of my report to 21cm x 29,7cm (the A4 format) but when printing the printer is set on a "personalized paper" format instead of "A4" format. So the user need to specify the A4 format each time he need to ...more >>

I have run into an interesting situation, and I wanted to check if anyone else has experienced it or even if it is possibly a known issue. I have created a table with one group and I have selected the page break at start option for this group. Everything works fine until I try to put an ex...more >>

Hi, I want to create a setup program to deploy my rdl files onto the Reporting Server. Is this possible. Currently am using Report Manager to upload all the rdl files. Any comments will of great help to me. Thanks Ramki ...more >>

I have a report that groups by item number but then is filtered by a parameter to only show the top # the user has entered. Does anyone know if it is possible to number the results I return so that the user can see how that particular record ranks with other records? Basically I want to be able...more >>

When changing the values to a %, I add P0 to the "Show Labels". When pulling up in reporting services, I get 0 and 100% showing on the chart. Is there a way to show intervals on the chart (20%, 40%...)? Thanks, Phill...more >>

Is there a way to set the width of each bar on a barchart? Currently the bars run into the next bar on the graph. I want to be able to leave a blank space between bars. Can this be done? Thanks, Phill...more >>

OS: Mac 10.4 (Tiger), Browser: IE, Excel: MS Office 2004 and Office X Report was rendered to Excel through Reporting Services. I cannot open the Excel file on a Mac. I have tried Office 2004 and Office X. Both are capable of opening Excel 97 (PC) through Excel version 2004 (Mac). If I downl...more >>

Hi, I would like to move the RS database to a different server. Both the current server and the new server are in the same AD domain. What are the steps to follow? Thanks. -- Best regards, Jude...more >>

hey, I've recently deployed reporting services onto a web server running windows server 2003 and have noticed somet very strange behaviour. We've a custom .net web app which uses URL access to run reports from within the app. All works fine and a report can be displayed. However - after O...more >>

I have a report with a List with Group Headers i want to repeat on every page, even if the group spans more than one page. -In the Visual Studio preview the same group header won't repeat on every page. -In the Reporting services HTML preview the group header WILL repeat on every page (even i...more >>

I'm currently working on a project for a large bank that has many thousands of customers. I'm wondering if there is any way to use wildcards in a report parameter. Let's say I have a report that lists a customers transactions and that there are about 100 000 customers. What I would like to do ...more >>

HI All, I am trying to jump to a url using pdf as a format. I need to add a field value into the url as in ex. "http://localhost/reportserver?%2fESS+Reports%2fnum=" + Fields!num.Value + "&rs%3aCommand=Render&rs%3AFormat=PDF"" I cannot get the value to show, it only shows me the string as ...more >>

Hello! We have a big problem with our Reporting Services. Sometime we get following error when we try to run a report: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'PMO'. (rsErrorOpeningC...more >>