I've run into a problem while converting an old Crystal report into a RS2005 version. The report in question gets a dataset from a SQL stored procedure. The stored procedure passes details on paper production by day, machine and grade. The report groups the data by grade and then by machine. ...more >>

Hi all, I've got a table, grouped on account numbers, with values and I've calculated a tax rate, and it all works fine. But.. while I can sum the 'values' in the footer, I'd like to sum the calculated values (tax rates) beside them. It seems access supports something called 'runningsum', b...more >>

Hi; i have this sentence on a reports's data section .... exec( 'Select top 1 s.*,c.*,(s.c01+s.c02+s.c03+s.c04+s.c05+s.c06+s.c07+s.c08+s.c09+s.c10+s.c11+s.c12) as '+ ' Totcargos,(s.a01+s.a02+s.a03+s.a04+s.a05+s.a06+s.a07+s.a08+s.a09+s.a10+s.a11+s.a12) as Totabonos '+ ' from ADMVDPV....more >>

Hello, My SQL Server 2005 error log is getting very, very large... Like 4 GB in 4 days... How can I recycle my error log so that it doesnt' overrun my c: drive. Also, if there's a way to move the error log from the c: drive to another drive, that would also help. Thanks. Adam F. Ha...more >>

OK, As an Admin on the server, domain, SQL Server and Reportin Services, when I log into the Report Manager website, I see the folder "User Folders". I can navigate into that and see everyone's personal "My Reports" folders. Now, I have made a developer a Reporting Services Admin by adding hi...more >>

Three boxes involved: BoxA: MOSS + SQL2005 + Reporting Services + MOSS integration add-in BoxB (act01projsrv01): SQL2k + SPS + Project server BoxC: XP workstation Objective: Run reports in MOSS library against Project server on BoxB on XP workstation. All bits are working on each box:) ...more >>

Does anyone know the ReportService web service API calls that are made by this method? RSClientPrint.Print(ReportServerURL, ReportPath, ShortReportNameForPrinter); RSClientPrint.Print('http://servername/ReportServer', '%2fReport1%2fSalesOrders', 'SalesOrders');...more >>

Hi, I have a server with sql server 2005 reporting services and reports are running fine. Sql server service and reporting service all are configured with domain user account. Now we have to deliver a report on excel format to a file share located in a different domain. We have a dif...more >>

The Report Server was previously installed. A backup of the encryption key had been taken but the password is unknown. The Reporting Services had to be re-installed but the existing database was kept. Now when I go to Report Services Configuration the Initialize option has a Red X. I click...more >>

Hej I'm new to Reporting Services. I'm using RS 2005, ASP 2.0 and VS 2003. I've created the reports and have been using a URL link in my ASP site to ReportServer/Pages/ReportViewer.aspx?%2fFOLDER%2fREPORT for viewing the reports. When the reports are accessed outside the server, the browser ...more >>

I create an Execute SQL Task and add a connection and the sql DROP TABLE Table1 Parse Query succeeds. But Build Query gives the error "The DROP TABLE SQL construt or statement is not supported." Baffling ... ...more >>

I would like to know if it's possible and, if it is, how to reposition parameters when viewing reports accessed through URL reporting and using the Report Viewer. For example, we have 5 parameters on a report. One is a drop down dynamic list of customer names, two are dates (start and end) a...more >>

We're running SQL Server 2005, sp2a on a Windows 2003 server. When I try to export a report based on a matrix I get this set of messages (from VS 2005 preview: An error occurred during local report processing; An error occurred during rendering of the report (2x); Object reference not set t...more >>

Hi everyone, I want to display the name of an expanded group within a seperate text box. The problem is that it doesn't work because my seperate text box is "not part of the group area" which the name/field belongs to. What should I do? How can I access report items of a group outside that...more >>

Hi, I'd like ot install reporting Services on one of our servers. What I need to know is what components of Visual Studio 2003 or 2005 do I need installed to build reports. How does licensing works for that instace of Visual Studio? Thanks a lot. Miguel Bluston Educa=E7=E3o & Tecnologia ...more >>

Report works in IE (deploy to report server, view with browser) but is not working in the VS.NET report designer preview. As soon as I select the first report parameter, the following error is displayed in the preview pane: "An error occured during local report processing. The value provid...more >>

Currently I am running SQL Server 2005 and Reporting Services 2005 on the same machine. When no reports are being run the CPU usage stays at 100% it is split between sql server and report services 10%/90%. If anyone can help me, as this seems like some sort of bug with reporting services, if the...more >>

How do I stop text from wrapping within a cell? or How do I make a cell automatically grow horizontally and not vertically? ...more >>

How do I go about connecting SQLRPS2005 in SPS3.0 integration mode to a SQL2k DB? (Actually I want to report from a Project server 2003 instance, which is based on sql2k. I have SQLRPS2k5 installed on the sharepoint server and have lots of green ticks for the installation. I have also installed...more >>

Is it possible to write a dtsx so that the destination of an "OLE DB Destination" Data Flow Destination is a temp table that is created earlier in the dtsx ? ...more >>

In a dtsx , is it possible to use a For Loop or ForEach loop to iterate through the rows of a table , extract the values of certain columns , and conditionally call a sproc ( that takes as parameters the values of some of the columns ) ? How to do this ? Or is a dtsx loop not the recommend...more >>

I know this is a new feature on RS 2005 to freeze headers when scrolling. However this works fine , when report returns data and when report doesn't return any results for the parameter values , i get a javascript error on ReportviewerWebclientcontrol.axd etc.. Disabling this options , does...more >>

I need to hide dropdown parameter values based on UserId. Any help with User!UserId and custom code will be helpful. This is a Non-queried dropdown and not based on query/dataset. Thanks!...more >>

Hello, Wondering if anyone has any ideas about this: I have ReportViewer on an ASP page with a report that has a list. The list shows me rows and I want to be able to toggle just one of the items in the list based on the type of item it is. Currently I can only show the toggle icon for all ...more >>

Hi, I installed the two virtual directories on a new, non default web with the RS Configuration Tool, what was well done and described on http://msdn2.microsoft.com/en-us/library/ms155921.aspx. If now I try to access the server by: http://<hostheader>/reportserver it looks up for a web.confi...more >>

I've created a simple stored procedure that accepts a uniqueidentifier as a single parm. Upon attempting to call the stored procedure from SQL Server Reporting Services (SSRS), I get an error stating that I cannot convert a string to a uniqueidentifier. I've attempted to place {} around the guid...more >>

I've uploaded a gif file to RS using Reports Manager, but when I go to view the image in RS/RM, it does not display. Only a red X displays. I'm using RS 2000 with Form based authentication. Please Help!!!!...more >>

I'd like to display the subtotal and Grand total rows of my Matrix report in grey, but I can't find a proprties box to change. I've changed the area that displays the text ie. "Grand Total", but there are not separate boxes for the subtotal values like you'd see with a table. I also seem ...more >>

Hi! My problem is since we update the server Daylight config with TZEDIT.EXE, the Sql Server Reporting Services engine return me an error for each report i try to execute. When i change back the daylight config to the original with TZEDIT.EXE, the problem goes away! The server config ...more >>

Hello, I am trying to hide the page header on a report for subsequent pages beyond page 1. When I check PrintOnFirstPage under page header properties, the page header is not displayed however, a huge blank gap is left where the page header was to be displayed before the rest of the report. Th...more >>

Okay...this is my last post for the week!! I've been follwoing the examples in BOL/MSDN and yet I'm encountering issues constantly. This one is actually occuring when I'm in VS and trying to create the actuall script. Here are the steps I'm taking: 1. Create a new empty VB project called Pr...more >>

Hi, I have several reports realized with SSRS, in general address lists. I'm trying to find a way to add to this reports the capability to produce mailing labels. I'd like to do it with a custom export format (it would be nice to have it in the "export as" dropdown with pdf, csv and excel for...more >>

When running a report I am noticing the following behaviour: As each parameter is selected, the report is doing some kind of postback or refresh despite the fact that none of the parameters are linked (cascading/dependent parameters). Why is this occuring? It is very annoying to the use...more >>

We currently using reporting services to generate excel reports. I was unable to switch on gridlines for my excel reports and reverted to the method where I gave each cell a border to simulate gridlines. These 'styles' prove to be problematic, especially with large spreadsheats. I have a larg...more >>

Dear all, Can anyone point me to some samples on aging reporting in reporting services? Thank you. Regards, Kueh. ...more >>

I try to use a report model for a report, I want to generate in Report designer. I choose type "Report Server model", but I don't know what to include in the connection string. The edit button is not available in that case. Thanks for every hint. Mike...more >>

I renamed my SQL server (MOM 2005 server) and everything works fine execpt the reporting services. If I type http://server/reports I get an error page which says: Error: The request failed with HTTP status 401: Unauthorized. ...more >>

Hi all, I have a report that currently outputs each doctor in the dataset, and counts the numbers of requests, and the total amounts for this request. My report is currently grouping by doctor to do this. However, I can't seem to add an interactive sort to allow the user to be able to so...more >>

How to write a dtsx that loads a list of ids from an xls and incorporates this list into sql ? For example, update table1 set column1 = false where id in ( {the list of ids } ) ...more >>

I have a table that is centered on the page. I have some conditional hiding on the columns in the table. Is there a way to keep my table centered when columns conditionally hide? I tried embedding the table inside another table, but that didn't work. I also tried embedding the table in a rec...more >>

I've just installed SQL Server 2005 Reporting Services on our development servers and the "Report Manager Virtual Directory" link is disabled in the configuration tool. Does anyone know why it is disabled, and how do I enable it? Also, the Web Service Identity link displays the following e...more >>

I am getting the "HTTP status 413: Request Entity Too Large." error when trying to deploy reports greater than 42KB in size to Reporting Services. In looking at this new group I have tried updating the UploadReadAhead by running "cscript adsutil.vbs set w3svc/1/ uploadreadaheadsize 204800" to n...more >>

Hi All, I'm using SQL Services 2000, and have a report with 3 tables. I export this to Excel and use Subscriptions to email this report daily. I have inserted page breaks after each table and so each table gets printed on separate sheets in the Excel spreadsheet. All this is fine. Now my pr...more >>

We are developing a web application that has to do a significant amount of data processing before a report can be run. Please would someone advise me as to the best place to put this custom data processing logic. Should I do it in my app beforehand or is there an appropriate hook in the report...more >>

Hi: I am working on a project where I would like to leverage the Outlook Custom forms and custom fields capabilities and use SRS to report off of these custom fields. While I can create the custom forms and fields, I can't figure out how to connect with SRS to report off of these items. ...more >>

After installing the Microsoft DST patch on the server running RS2000 we are getting the following error when trying to run reports: Specified argument was out of the range of valid values. Parameter name: date If I uncheck the observe DST on the date/time control panel app then all is OK. ...more >>

Hallo all, I have to create drill down cross tab reports. How can I create drill-down cross tab reports using Sql server reporting services 2005? I am very much in need of help. Can any one help me how i can create ? Please kindly some links if any drill down cross tab reports examples a...more >>

how do I add some extra pdf documents into my report pages it depends on db bit field value ? regards ilker...more >>

does anybody knows. how do I get report events and write some sub-code for that ? regards ilker...more >>

I am trying to do this with a web service but cant seem to figure out how, as there is no direct method or function for it, it seems. But I have a report I created programatically through the web services. Now I want to set up a history snapshot schedule for it, I already have schedules set u...more >>

Hello People...!!! I'm using the Sql 2005 SP1 Express Edition with DataBAse and Reporting Services implementations. I need to upgrade this to SP2. Is there an SP2 Upgrade Tool? Thanks afterhand... Carlos Maggiotti ...more >>

Hi, I have a matrix report that displays offices down the page and all the days in a month across the page, with a subreport in each cell displaying other data. The problem i am having is when i load the page the first time it will only display half the days, when i press refresh or change ...more >>

How do I create a report in SQL? I have a database created with a table that has names I would like to print the table out by last name in ascending order. Any ideas or help? Thanks Tom -------------------------------------------------------------------------------- I am using the...more >>

I would like to use SQL Server Reporting Services but SQL Server is hosted on web hosting services server (I use ASP.NET) and wondered if there is a way for me to get the report builder etc and use that against data on a remote server. I have SQL Server Express installed on my local machine. ...more >>

Hi, is it possible to format the @executiontime variable in the subject line of an email. I'm setting up a subscription and would like the subject line of the email to format the date in MMM yyyy format. Thanks...more >>

Hi, I want to show line numbers on report page in the first column of my report. I am working on microsoft reporting services 2000. How i can do this. Regards Dinesh ...more >>

We have users experiencing very slow to export SQL Reporting Service 2005 rendered data to EXCEL. Is there any way to improve the performance? Brian...more >>

So I installed sql 2005 standard edition on my windows xp work machine. When I go to http://machine/reports and run the report it work on my server. But if I go to a machine other than my work machine the report gives me the following error An error has occurred during report processing. ...more >>

Hello. Here's the background on my problem: 1) We are using Active Directory. 2) We have set up a domain user group in AD for viewing reports. 3) I set up a report on our report server and added a new role assignment for the report containing the user group added in step 2. 4) Reporting Servi...more >>

All, I have a matrix that is being populated by a sproc. The sproc returns data which are broken into sections by fields and then sorted by another field. The matrix is group on the section designator. However, each section is getting an initial row that is null. I want to drop out ...more >>

Hi, I am trying to hide a subreport based on certain conditions from the main report. When I hide the subreport actually I am getting a blank page instead of the sub report. How can I avoid that blank page? I dont need the page containing the subreport. Thank you, Lekshmi EggHeadCafe.com -...more >>

I have a report, say for example "Dummy report" which has its dataset to be a stored procedure SP1. This stored procedure SP1 gets its data from another stored procedure (SP2) that is nested in it. When I try to generate "Dummy report" from report designer for the first time, it fails. Wh...more >>

There is a developer here running a report using SQL reporting services, It is a fairly large report and it seems to run fine, But when he tries to export it to a CSV or EXCEL, it runs for two minutes then brings up an authentication window, After he inputs his credentials it runs approx anoth...more >>

Hello, We are using the security extensions to connect to the Reporting Services environment. By using this we have implemented a single - sing on. However When we start the reportbuilder we still have to log on. Can someone help me ?...more >>

Hi, I have been using Crystal and new to the reporting services, and I am stuck. What I am trying to do is use the total number of returned data (or rows) to calculate N, to be used for Top/Bottom N. If I try to use Count or RowCount function to get my desired N, I receive an error related t...more >>

Hi All, I am using SQL Reporting Services 2005. I have report parameters for reports. How can I show value "All" as default for report paramters? I have used single value paramters. I know in Multi value parameters it automatically comes as "Select All". But I need to show "All" for si...more >>

Hi all, In my web service call, I pass the date value to the reporting services in the format of yyyy-MM-dd. But the reporting service interpret the date value in a strange way. When I select 9 Mar 2007, It convert the date to 3 Sep 2007. However, when I select 13 Mar 2007, It remain as ...more >>

Hi, When I try to execute a report with large number of selections it gives a error saying the report width has exceeded 4064 mm . Is this the limitation of Reporting Services that it's body width cannot exceed more than this width. Please reply to it soon. Thanks in advance. regards, Hem...more >>

Hi Experts! I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned out quite nice. At least I know it allowed me do combination charts (e.g. points, line, coumn, etc) which the default RS cannot do. Based on your experience and opinions from others that you heard, which ...more >>

I have a report that lists companies from a table. I want to be able to print either active, inactive or all records. The table has a field named InactiveDate and if it is null the company is active. How can I setup report parameter(s) to get just active, just inactive, or all? Thanks. ...more >>

I am trying to setup a report that uses a Visual FoxPro database. I can get the report to work fine on my development machine, but when I deploy it to the web server I get different error message, depending on the data source setup. Here are some of the different error messages I get: S...more >>

When I add static columns to a matrix, there's no place to put column = header text. The top left corner field just expands to cover the space = all the way to the dynamic column, which does have it's own header. I need a matrix to display account order totals by month, but I also = want colu...more >>

Now that the Select All feature is working, I need to be able to display the text ALL when the end user checks select all (in a textbox that is designed to show values chosen for the parameter). Is this possible? I am able to do this when I add an all value to the drop down selection, but ...more >>

I have created a parameter for a report that displays a drop-down list of values to pick from. The parameter values are defined as being "loaded from a query." The problen is that I need to have the option of blanks as a valid value in this parameter so that the report can be generated for "...more >>

I want to backup an entire site in WSS 2.0 (including subsites and published web parts and documents). I haven't founded the documentation related that explains the use of the various options of STSADM command. Is it correct this statement? "C:\Programmi\File comuni\Microsoft Shared\web serve...more >>

Hi, I'm using SQL 2005 and I'm currently trying to create a report using VS 2005. I'm pulling the data from a CRM 3 database. So far it is going pretty well. I got a good base but I'm stuck. I want to create a report similar to the Sales Pipeline report. The problem with that report is th...more >>

I am not familiar with this tool. Can I create reports that can be run from a C# application with parameters passed to it? Any help is greatly appreciated....more >>

whats the future of notifications services? also if i'm building a messaging (notification) application, should i use SSNS or MSMQ??? Ofcourse i'll be using .NET. I just need to know what technology i should invest in? & whether investing in SSNS would be worth it ...more >>