Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > september 2005 > threads for monday september 26

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Group Header Question
Posted by OriginalStealth at 9/26/2005 5:40:02 PM
I have a report that list information for each city by state as shown below. GA xxxxx xxxxx xxxxx xxxx xxxxx xxxxx xxxxx xxxx When the page breaks and it is still on the same group, is there away to make the group head look like this: GA (cont'd) xxxxx xxxxx xxxxx xxxx xxxxx ...more >>


Report Manager: SHow only reports, not the stuff above?
Posted by Kaisa M. Lindahl at 9/26/2005 3:57:12 PM
Is it possible to add parameters to the URL for the Report Manager, to get rid of the stuff over the available reports? Like what shows up in the RS Web Part "Report Explorer". We're trying to view RS reports through a HummingBird portal, and are trying out different ways of viewing RS reports...more >>

E-mail failure in data driven subscriptions
Posted by bwray at 9/26/2005 2:23:01 PM
When using a data driven subscription to generate and send a number or reports to different addresses I have only been able to find a number that were successful or failed. Is there any way to tell specifically which e-mails from the group failed? ...more >>

Matrix Expression Problem
Posted by Nat Johnson at 9/26/2005 1:56:05 PM
Have a matrix with three columns depicting the following table: # of Results # of Results % of Results within 5 working days > 5 working days >5 working days January 33 ...more >>

Pass user credentials RS web service?
Posted by Burt at 9/26/2005 1:23:04 PM
I'm using the RS web service to pull back customized reports via a C# app, which is running under a service account. I need to pass in the user's credentials to the Render method to make sure the user has been given access to the report on the Security tab of the front end. If I pass the de...more >>

compare row with previous row value in RDL
Posted by BALAJI K via SQLMonster.com at 9/26/2005 12:40:40 PM
Hi All, I have a table, which displays the rows binded, now I need to compare a textbox value in the table with the previous value and if matches then I need to display the text box values with paranthesis [value]. How do I compare values in the RDL Thanks in advance Balaji -- Mes...more >>

Active Directory Conversion
Posted by Dennis Redfield at 9/26/2005 12:25:52 PM
We are updating an NT domain to Active Directory. All of our security group within RS are based on local (machine groups) which contain domain groups as members. So we are pretty comfortable with the conversion path required there. We understand how we can change the Data Base Agent and Remote ...more >>

Report looks bad on screen but prints OK
Posted by jmann at 9/26/2005 12:23:04 PM
I have a report where I'm using text boxes in a grid format. When I preview the Report the grid looks fine, but when viewed in the Report Manager, the boxes don't line up. When I print the report or export to PDF, however, it is OK. Has this happened to anyone else or does anyone know of an...more >>



predecessor logic
Posted by Kurt at 9/26/2005 12:13:02 PM
Is there an easy way to do the following? I have a data load running on a DB/2 mainframe database. When the job finishes, a message is sent to a Reporting Services system via a text file that the data load is complete. I’m using SQL Agent to watch for the creation of the text file and up...more >>

Disable and/or Hide Parameters
Posted by isaak at 9/26/2005 12:00:17 PM
Is it possible to conditionally disable or hide parameter prompts, depending on other already selected parameter values? For example, if I have two parameters p1 and p2, is it possible to somehow disable or hide p2 if P1="Yes"? Also, is it possible to conditinally set the default value of a ...more >>

RS E-Mails Not Sending
Posted by Andy Jones at 9/26/2005 10:17:33 AM
I have some subscriptions setup that automatically e-mail reports to the end-user. However, the reports only work maybe 3 days out of the week the other times the e-mails to not get sent. Has anyone ran into this problem before? I am using SMTP. Thank You. ...more >>

Excel Render Problem : Width of excel cell in the excel sheet exce
Posted by Ben Sullins at 9/26/2005 9:36:02 AM
After Adding a couple columns to my report I attempted to export to excel and recieved the following error: Excel Rendering Extension: Width of excel cell in teh excel sheet exceeded the maximum limit of 1726.5 Points. I had header cell that was merged across the entire report that I split...more >>

Error Msg
Posted by Terry at 9/26/2005 9:07:02 AM
How do I resolve the following error message and what does this mean? c:\srsconv\visual studio projects\china\china_reports\All_Official_Representatives_China.rdl The value expression for the textbox ‘ADDR_Org_Name_2’ contains an error: [BC30311] Value of type 'Microsoft.ReportingServ...more >>

EMAIL Sent nobody Get?!
Posted by שובל at 9/26/2005 8:23:05 AM
Well i cofigured one of my reports to be sent as email to user in the domain. In the Report manager appeared that the mail was sent successfully but the user didn't get it. When I sent it to a outdoor email it didn't send it at all,why??? Where i can check the smtp setup 4 reporting services???...more >>

Login Prompt after ~3min timeout
Posted by Nicola Jones at 9/26/2005 8:04:08 AM
I have a report which I am running from a web front end, which, when exported to excel with certain parameters, takes several minutes to run. After something between 2.5mins and 3mins this will prompt for a username and password. Providing a valid username and passoword gives you another 3m...more >>

Automate deployment of reporting project
Posted by JohnHennesey at 9/26/2005 6:46:10 AM
I have to deploy reports several times a day [to our teesting environment] due to contstant changes by devlopers. Does anyone know of a way to automate the deployment process? Even doing something with VBA will work. I don't see any possible references listed in the VBA references section -...more >>

RS 2005 with SQL Server 2000?
Posted by David at 9/26/2005 4:37:01 AM
Has anybody tried and does anybody know if Reporting Services 2005 works with SQL Server 2000 database?...more >>

One failed subscription prevents running all others
Posted by Ard Goossens at 9/26/2005 1:13:02 AM
Hello, I was trying to invertigate why a certain report does not run properly in some cases. I scheduled it to run daily. So far so good, i got logfiles to study. However, since this try RS no longer executes ANY scheduled subscription. i made no changes to the system, just scheduled a defec...more >>

Question regarding "New Role Assignment"
Posted by Kunjal at 9/26/2005 12:39:02 AM
Hi All, I have share point server and report server on two different machines but in the same domain. Our application categorizes users ,from Active Directory, in Sharepoint sitegroups. For eg Marketing , Finance , Manager are sitegroups in our application. Is it possible to add these site...more >>


DevelopmentNow Blog