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 > july 2006 > threads for wednesday july 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 31

can we have SQL Server 2000 as a back end with RS2005? If yes, then there is no data migration work...
Posted by ajmera.puneet NO[at]SPAM gmail.com at 7/26/2006 11:48:59 PM
Any Answer would be appriciated.... TIA ...more >>


Column Chart Issue in MSRS 2005
Posted by Manoj at 7/26/2006 11:36:32 PM
Hi, I have report created with Reporting Service 2000 SP2 designer. This contains a Column Chart with Simple Column type. I had selected GraySacle Pallete for my report. I have max 4 columns in my report. When I deployed the report on MSRS 2000 SP2 Report Server it is showing correctly. The...more >>

Exporting to Excel Problems (URL Access)
Posted by steggun at 7/26/2006 2:21:01 PM
Hello, I'm using SQL Server 2005 Reporting Services. I'm having an issues when exporting to Excel. I'm using URL Access to generate the report and display it in a browser window. I then choose Excel and click the Export link. Doing this opens a temporary browser window and then a dialog that ...more >>

Configuration problem (WMIProviderException)
Posted by Homam at 7/26/2006 2:09:02 PM
I installed Reporting Services on stand-alone server from a SQL Server 2005 Standard CD. It supposed to connect to a remote SQL Server that would host the ReportServer database. I went through the steps of the Configure Report Server till I got to "Database Setups". I created a new ReportSe...more >>

How to resolve RS 2005 ReportExecutionService ToggleItem method problem
Posted by InvalidLastName at 7/26/2006 12:33:36 PM
Hi, This is a follow-up for my own post "RS 2005 ReportExecutionService = ToggleItem method problem" http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/b= rowse_frm/thread/2fcb4ec23fbedbe1/cf24c952c6f1bc20?lnk=3Dst&q=3D&rnum=3D1= #cf24c952c6f1bc20 Here is the fix. You ne...more >>

Allowing "empty" value in comboBox
Posted by VMI at 7/26/2006 11:41:01 AM
I'm writing a query (that will be used for a comboBox in sql reporting services) but the user should also be able to chosse an "empty" value in case he/she wants to leave it blank. I was thinking of using a "Union" and attach the empty value to my recordset, but there has to be a way in cli...more >>

Total Page Count
Posted by Tony at 7/26/2006 11:14:02 AM
How can I display, on a report with many sub reports, the total page count on a cover page that contains a field in the body section? Currently I have a custom assembly that will execute each subreport seperately and record the number of pages. I would like to just get the total page count f...more >>

Side by Side tables and or matrices: HOW
Posted by cr at 7/26/2006 10:15:02 AM
SQL Server 2005 and Reporting Services 2005! How do I create side by side tables and matrices that 1. do not overlap 2. have the same size rows to make the report of several tables and matrices appear to be one big table. I've spent almost two weeks doing this and nothing seems to wor...more >>



Globals!FileName.Value??
Posted by sullins602 at 7/26/2006 9:45:21 AM
Does anyone know if there is a Global that stores the file name? I am looking to put something in the footer that lists the path and filename of the report. =Globals!ReportFolder + Globals!ReportName Doesn't seem to work...any suggestions?? thnx -ben ...more >>

Reset page # after a "specific" group
Posted by googlerptgsvcs at 7/26/2006 9:40:45 AM
http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx the above custom code works when reset is needed on change of each group, How do I modify this code to reset pagenumber after a particular group say "group 3". ...more >>

Date stored as int
Posted by Clueless at 7/26/2006 8:32:35 AM
I get a conversion error when using the 'seconds since epoch' integer with CDate. So I found this routine in this news group that is supposed to fix it: =DateTime.FromOADate(CDbl( Fields!Arrival_Time.Value / 86400)).AddYears(70).AddDays(1).AddHours(-6) But "FromOADate" is an "unrecognized...more >>

Server Generated URLs Producing Errors - SSRS 2005
Posted by Dave Green at 7/26/2006 7:14:46 AM
After we upgraded to SSRS 2005, I started noticing that exterior application links stopped working. I then tested the problem be creating a new subscription that generated an email and was hoping I could compare the links to see what was wrong. Unfortunately, the links generated by the server ...more >>

Display or export empty report
Posted by Billy at 7/26/2006 5:53:02 AM
The report is running well. However, nothing will be displayed if there is no data return from database. I would like to display an emty report (the report frame) when there is no data. Could someone help? Thanks,...more >>

report print and display different page count
Posted by vojtech.vybiral NO[at]SPAM gmail.com at 7/26/2006 4:56:47 AM
We use reporting services in a asp.net application. When user preview a report in browser - it got for examle 230 pages but if we print it on printer it has got 470 pages. Any idea how to solve this? I've tried to play with page margins but i didn't helps. The reports are quite simple there is...more >>

Passing Parameters into SubReports and to parent report using Reporting services
Posted by SPK at 7/26/2006 12:45:44 AM
hi, here i am trying to display parent and his details in a single template using subreport. when i am doing this, an error is shown where i could't track it clearly.so can you kindly solve this issue. The error message i am getting : A Value expression used for the report parameter 'Head...more >>


DevelopmentNow Blog