Hi, I am working on a report in the Reporting Services. I was wondering if we can set alternate background color for a group of rows on the report. Let's see the example below. ID Name Month Field4 Field5 1 A Jan 8 9 --- Background color: r...more >>

Hi All, I have a FRESHLY installed Windows 2003 server and I have had this problem happen on every other server I've installed SQL2005 on. When it boots the SQL Reporting Service fails to start with event ID 7000. What can I do to fix this problem? Thanks, --GREG-- ...more >>

Hi All- In SQL Reporting Services is it possible to have a graph on each line of detail or only on summary (or total) data? If this question doesn't make sense, here's an example.... I want to make a disk space utilization report for MOM2005, I want each server to be on one line and then...more >>

i have an expression that i want to show text format and currency format i.e. =(field.name.textvalue) & " " & (field.name.currencyvalue) is there a way i can get it to display both of these formats? Randall...more >>

Hi, I need to come up with a query for some financial statement reports. The reports require current year $$ vs. previous year $$ by month, quarter and year. I'm building a stored procedure to produce the necessary dataset for my reports. So, in the sp, I build two temp tables – one fo...more >>

I have a 64 sql server box (data warehouse machine) which also serves as the meta data repostitory for reporting services. I'm running 2005 enterprise and I would like to upgrade to SP2. As reporting services is on a different server, do I need to do a separate install of SP2 on the reporting ...more >>

2007-09-07 08:30:00 - + [162] Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 91...more >>

Hi! I've got a small web app where an rdl file is modified and then executed via the LoadReportDefinition method on the ReportExectutionService2005 webservice (another server in the same domain). If I impersonate a user we use for services etc. (the same account the reportservice executes a...more >>

Hi, I am having a problem getting totals on my fields: I have a table on the report and in the Detail section I have my various columns of data. In each column I have an expression doing a calculation, e.g: =ReportItems!AverageSalesPerAgent.Value * Fields!TargetAgents.Value. Now the proble...more >>

Hi How is it possible to format a date field according to the Regional Settings Short (or Long) Date Format? It seema that I can hard-code the format as dd/MM/yyyy (which is the date format in my country), but dates formatted like that may be misleading if the report is run by users of our...more >>

Dear reader, I have a list of CUSTOMER_ID with PURCHASE_AMOUNT. With these information, I like to show on a bar chart the frequency of PURCHASE_AMOUNT (i.e. how many people spend $2, how many people spend $4, etc) At the same time, I like to quantize PURCHASE_AMOUNT to $0-$10, $10-$20...more >>

For the my report in dataset i am using union. For example: select * from tblOne Union All select * from tblTwo Union All select * from tblThree Union All select * from tblFour But when i view the report it shows in different group order select * from tblOne Union All select * from...more >>

Hi All- I figured out how to configure the SMTP to work but now when I try to subscribe to a report I'm getting credentials problem. So I went into the data source and put in the following connection string: Data Source=XXXXXX;Initial Catalog=SystemCenterReporting;Integrated Security=Fal...more >>

Is it possible to access a text box within a report? Something like this: Report.TextBoxName.Value Thanks ...more >>

I am having an issue for a single user when emailing reports using a subscription. He is able to view reports and create a subscription but when the report server runs the scheduled report the following error message appears on the subscription page in the report site: Failure sending mai...more >>

Hi EMartinez , A matrix table object cannot have a footer but if someone needs to put totals for all rows, he needs to right-click on the section of matrix table where it says "Rows" and then click "Subtotal" option. This would add a new row in the end of matrix table and bring totals automatical...more >>

Everyone, I am getting a recordset being sent through to SSRS that may or maynot have cell data in it, if I set it up as raw data, i.e. set no data conversion, CDEC(Fields!value.value) everything works fine, but when I export to excel the numbers are formatted as text and it is a requiremen...more >>

Is there any way to keep the SP's and other DB objects that Reports use; = inside the Solution? This way a developer; when he opens a specific solution has all the = related objects that the reports need. Or do most folks manage the DB = objects outside BIDS? Still not even clear how most ...more >>

Dear MSDN! We are trying to get Reporting Services working. But we get following error: The request failed with HTTP status 401: Unauthorized. Something that i've tested: -Allowed client computer "Trust for delegation" -Explicit set Me.ReportViewer1.ServerReport.ReportServerCred...more >>

Hello all I'm having an unusual problem, although I'm used to Server based reports so maybe it's a newbie thing. When trying to view a local report on a client PC, I'm doing this: reportViewer.LocalReport.ReportPath = @"MyReport.rdl"; reportViewer.LocalReport.DataSources.Add(new ReportDa...more >>

Hi, i'm creating a windows application With Vb2005 and Sql 2005 express editions. The basic point is to create 5 reports each one having several subreports. These reports have to be exported to Excel as per requirement.Currently I'm able to manually save each report as an individual file and la...more >>

Hello all, I'm trying to find solution to show sub-report title on every page of that subreport. What I have in the subreport is the text containing title and two tables underneath. The first table is a summary table and will only be shown on the first page. The second table goes over few p...more >>

Hi All, Is it possible without a lot of customized programming to send reports automagically via SMTP as a PDF attachment? When I go to subscriptions the only option I have is to put it out on a share somewhere. I would like to be able to publish via e-mail smtp. Thanks, --GREG-- ...more >>

Hi, I have created a report that contains a table. The table returns data w/ multiple statuses. I have created a group based on the status and have a page break at the end of the group (so each page will display only one status type). I would like to dynamically show / hide columns based...more >>

I have been trying for quite awhile to get a web service to return data for a report and I just cannot get it to work. I have been able to get Microsoft's example (ListChildren) to work and I am able to access data in an XML file; but I cannot get a custom web service to work. In my data...more >>

Lately we started having problems with our reporting services hanging the first time a user tries to pull up a report after a report server shutdown. When report server is in a "hung" state I can see that there is a worker process in memory but the report server doesn't return a report. The ...more >>

Does anyone know where I can download this? I can only find the download for SQL 2000 RS SP2 Any help appreciated Thanks...more >>

Hi, I have the following result from a matrix: | Week 1 | Week 2 | Week 3 | DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 | |New cust | 3 | 2 | 5 | ...more >>

We had a person create over 200 report subscriptions and they are showing up as the report onwer. No that this person has left and their domain account has been deleted we have found that the SSRS 2005 report subscriptions are now failing. How do you change the report subscriptions owner to so...more >>

I have configured my report server. I can connect to it via Management Studio and via http://localhost/reports however when I try to connect via http://servername/reports I get a Windows style password box. What user is it expecting? Regards, Chris. ...more >>

I read I might be able to pass Parameters via the ReportPath property. <asp:Content ID="Content1" ContentPlaceHolderID="Content1" runat="Server"> <rsweb:ReportViewer BackColor="Transparent" ZoomMode="PageWidth" Width="100%" ProcessingMode="Remote" ID="ReportViewer1" runat="server"> ...more >>

I cannot get report manager to load in IE 7 after installing on SQL Express, advanced edition. The error message is "The ReportServerVirtualDirectory element is missing". When I check the reporting services configuration file, there is no XML tag for this (Should there be?). In the reportin...more >>

Hi! I have created a data-driven subscription and scheduled my report to run on the calendar days of 1 and 10 at 9:00 AM for the months of Feb, May, Aug and Nov. However, the report was kicked off unexpectedly on Sep 1st at 9:00 AM from the subscription with the schedule setting mentioned ...more >>

Hi, I realy don't know what happened. But from this morning I receive logon failures on my datasourse. I use NTLM security but receive following error when opening a report: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to d...more >>

Hi, when creating reports it seems to me that all report parameters are placed automatically. how can i control at which position the parameters are being placed in the 'value selector'? for example i want to have a value selector with each parameter in a seperate line. how can i achieve...more >>

Does anyone know what this error message means? I cannot manage my report server until I get this resolved. The reporting services configuration manager indicates everything was successfully installed and configures, and the reportserver does work. Please help!...more >>

I have a phone number as 0396526888. if I were to format this to say +61 3 9652 6888 how would I go about working on this. Any help would be helpful. thanks heaps Regards Ridhima...more >>