My reports are currently configured so that only certain users on the domain can access certain reports. I have installed another server at a remote location that will need to have the same permissions as the first one. Is there a way to replicate the security settings without having to set th...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

i had rendered a report and created a excel file and each page of the 2-page report generate a sheet in the workbook, which is great now i rendered the same report in PDF, the PDF only generates one page instead of the expected 2 pages. What am I doing wrong? Please help. FYI. Using C# in ...more >>

What happened to the hotfix required by Reporting Services for SQL Server 2000 SP3a? It looks like you have to contact PSS to get any hotfixes anymore. Does that mean anyone new to Reporting Services has to contact PSS just to be able to install Reporting Services?...more >>

Hi all I'm generating a column chart, lets say its CustomerID as a category and SUM(Sales.Value) as a values sorted by SUM(Sales.Value) DESC. That might give 100 column bars so we filter the category to show, say, Top 20. Can anyone see a way, convoluted or otherwise, of creating one more ...more >>

Occasionally and randomly, we receive some internal Reporting Service Error when run a report. The error message "An internal error occurred on the report server. See the error log for more details." shows up at the end of each report page. Some of the report data ddid get rendered. Especially on...more >>

Hello, I'm looking for anyone that might have created a web service data processing extension that handles ADO.NET datasets returned from the webmethods. There is a nice one created by RDL Componenets: http://rdlcomponents.com/DTE/Default.aspx?sm=a_a3 However, there are limitations to th...more >>

Is it possible to replace a subquery with a stored procedure? For example, instead of: SELECT a.col1, b.col2, c.col3 FROM (select col1 from t_1) a, (select col2 from t_2) b, (select col3 from t_3) c Could you have something like: SELECT a.col1, b.col2, c.col3 FROM (select col1 from...more >>

I have heard that calling several subreports in a report causes RS to use sequential query execution instead of parallel, but what can I do to avoid having a large report calling 10 subreports taking 3 minutes when each subreport individually takes <5 seconds? The datasets for each subreport a...more >>

I have report that generates a person's resume. The resume sections (experience, education, skills ...) do not page correctly when exported to PDF or TIFF. Instead of keeping sections together on the same page the sections is moved to the next page even though there is sufficient space left ...more >>

Hi all, Using SQL Server 2000, Visual Studio .NET and the Report Project Wizard I've nearly been able to create the kind of reports I like. What I'd like to do now is to create a custom control and have it appear on the Report Items toolbox along with the other report controls (Textbox, Lin...more >>

I have a report with a table in it, the table's fields are filled with subreports. I would like the data in the table to be kept together without additional page breaks. What is happening though is multiple page breaks when a subreport's data is too long to fit on the rest of the page. Any su...more >>

I have a report that takes values from a list box to generate the report. The list box gets its values from a table. If the user does not coose anything from the list box and hits 'View Report' It should be able to go and grab all data from the table. How do I make RS do this? I tried 'Allow Nu...more >>

Hello It works from the project in VS.NET It works from the Report Manager http://localhost/Reports It returns an Exception using the rs.Render(....) web method, after 3 minutes "The underlying connection was closed: An unexpected error occurred on a receive" If I reduce the repo...more >>

Can you still run scripts such as CancelRunningJobs.rss after implementing forms authentication? I have forms authentication implemented and tried running this script (CancelRunningJobs.rss) and I get the following error: Could not connect to server: http://xxx.xxx.xxx.xxx/reportserver/r...more >>

Is there any way to stop a subscription once it has started? Does the "CancelRunningJobs.rss" script included in the samples do this? I have tried searching on here and on google and have not come up with much. Thanks, Nick...more >>

SQL Server 2000, Reporting Service Pack 1 How can I export the rdl for a specific report from reporting services? ...more >>

I am currently completing a proposal to put reporting into large Telco whose end user client is a US government department. One of the problems I have is determining the correct sizing of reporting services. Let me outline some of the requirements: 600 concurrent users generating two types ...more >>

I have recently modified my ASP.NET application to use Web Services to display my reports. Previously, I was using URL Access. With URL Access, toggle items (+/-) displayed and worked without issues. However, now that I have moved to Web Services to display my reports, the toggle items on thes...more >>

Hello I have a problem where I set up a user subscription, putting in all the required fields for this to run correctly. I schedule it to run Once. I check in SQL Agent for the job and it exists, as expected. I check that the job has been run in SQL Agent, which is says it has done, successful...more >>