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 > may 2007 > threads for thursday may 17

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 31

Report with Multiple Data sources: Can I do this?
Posted by fuzz_ball at 5/17/2007 4:47:05 PM
Okay, so I have this ADO.NET dataset defined in my project. I created an RDLC report and from the menu Report->Data Sources... I chose two different tables that exist in my ADO dataset. So far so good. At this point I can drag specific columns into various text boxes I have in my report (I'm not...more >>

How can I persist user credentials?
Posted by Jeff Stroope at 5/17/2007 4:07:01 PM
Hi, I'm using SSRS 2005 on SQL Server 2000. I have 8 reports for a particular user. Each report has its own data source. The way our security is set up, I have to use the following configuration in the data source property sheet for each report: Data Source=ServerName;Integrated Securit...more >>

Report Inside a SubReport
Posted by nkg at 5/17/2007 12:17:21 PM
I am running into a situation where i would like a report inside a subreport. Is it possible to accomplish this. ? thx ...more >>

Calculate HH:MM:SS between two times
Posted by John at 5/17/2007 11:05:00 AM
Hi, I'm trying to get a result of HH:MM:SS that occurs between two times. I'm not sure exactly how to do this, or if I should do this in SQL or as an expression in a table. As an example: 11:01:00 PM to 12:02:00 AM= 01:01:00 Thanks for an help -- John...more >>

SubReport inside a List
Posted by nkg at 5/17/2007 9:53:46 AM
I want a subreport to show inside list report item, repeatedly for each row. is this possible? TIA ...more >>

Why can't I connect to my data source?
Posted by Jeff Stroope at 5/17/2007 9:32:01 AM
Hi, We have SSRS 2005 running on SQL Server 2000 SP4 Standard Edition. I have SSRS 2005 running on SQL Server 2000 SP4 Personal Edition on my computer. I have a copy of the database that is the data source for my reports on my computer. I built a report and deployed it to the Report Mana...more >>

.NET Runtime 2.0 Error
Posted by Hugo Figueira at 5/17/2007 9:02:00 AM
Hi there. Recently event viewer started showing the .NET Runtime 2.0 error event. The body is: EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 system, P5 2.0.0.0, P6 45b04225, P7 3a3e, P8 7a, P9 system.unauthorizedaccess, P10 NIL. Have already reinstalled the 2.0 framew...more >>

configuration tool
Posted by farshad at 5/17/2007 6:00:01 AM
In SSRS 2005, where do I find Reporting Services Configuration tool ? Thanks...more >>



Blank IE screen
Posted by Antoon at 5/17/2007 5:35:01 AM
Hi everybody, I have a problem with our new setup of RS 2005. I can access de report manager an show reports fine. I have the Bruce-workaround t.i. a "dummy"-report that refreshes itself every few minutes to keep connections alive. Still somtimes when I open up a report I get a blank IE wi...more >>

email
Posted by farshad at 5/17/2007 2:26:04 AM
I would like to automate a report to be emailed to an email address. When viewing the report, clicked on new subscription. In the subscription window what options should there be for Delievered By: ? I currently have: Report Server File Share in the drop down. Should there be other entries in t...more >>

Page break occurence when exporting the report to PDF format
Posted by Sunny Taparia at 5/17/2007 12:20:25 AM
While exporting the report to TIFF and PDF if the breadth of the report is long (i.e. large number of columns), then page breaks occur in the pdf or tiff file and the remaining extra columns in the report will come in the next page making the report look weird. For all other formats such as Excel...more >>


DevelopmentNow Blog