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 > august 2006 > threads for monday august 14

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

Sales Totals for all months
Posted by blabore at 8/14/2006 9:09:01 PM
I have a report that shows a graph of sales counts for each month. My problem is, occasionally there are months with no sales for some products, so my SQL query doesn't return a record for that month, and the graph skips a month. Since my users are confused by this, I'd like to at least show t...more >>

using repeatwith in a list
Posted by Arlyn at 8/14/2006 4:53:47 PM
Hi, I have 3 layers off lists. The details list with two outer groupings. I want the texboxes in the two outer lists to repeat on each page. The repeat with doesnt seem to work. Does anyone have experience with this? Thanks, ...more >>

How to set connection at runtime
Posted by Richard at 8/14/2006 1:11:02 PM
Hi, Our application connects to one database in the testing environment and to a different database in the production environment. Currently, with Crystal Reports, we maintain a single set of reports, and at runtime, when the reports are loaded, the application sets the report's connection ...more >>

Foxpro date syntax problem from SSRS 2005 using VFP ODBC driver.
Posted by bmchan at 8/14/2006 11:15:02 AM
Looking for a way to return records within a date range. Having problems with parameter as a date syntax. I usually just SSIS batch my FoxPro stuff into a SQL enviroment so I can take full advantage of SQL Server 2005's familiar, fast and not too fusy T-SQL syntax. However I have a requ...more >>

Installing Reporting Services (not DB) on 2003 Web Edition
Posted by AlexD at 8/14/2006 9:18:02 AM
We have a Windows 2003 Web Edition server that I would like to install SQL 2005 Reporting Services (not the Database) on to. This is the report manager, report builder etc. so that users do not have to connect to the database server. However the option to install the services is not availabl...more >>

Hidden Property - "Deserialization failed: is not a Valid Value" E
Posted by bsod55 at 8/14/2006 9:13:01 AM
If I add an expression to the visibility property on a text box, table row, etc.. and then remove that same expression, I get the following error message in preview: "deserialization failed: is not a valid value..." I get an option to edit the XML code. When I look at the code, I find t...more >>

OK button doesn't Work In Report Manager RS2000
Posted by Rgranada at 8/14/2006 8:13:52 AM
Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2. My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action. Can't figu...more >>

How Do I Manage a Report Header
Posted by msflinx at 8/14/2006 7:41:01 AM
In a post titled "Report Header Only on First Page", Charles Kangai replied that: "It sounds like you have used a page header rather than a report header in your report. A report header automatically does what you are wanting to do. To create a report header, just place a textbox above your...more >>



background color and background image after SP1
Posted by Benno at 8/14/2006 7:06:14 AM
Hi, after installing sp1 for sql server 2005 the properties "background color" and "background image" do not show in HTML. They do show in TIF or PDF export. Also the header and footer are rendered correctly in HTML. Only the body of the report is always white! Any suggestions? Thank you...more >>

Parameter Information cannot be derived from SQL Statements with sub-select queries
Posted by Timothy.Rybak NO[at]SPAM gmail.com at 8/14/2006 7:03:32 AM
I have the following query that finds the most Serial number of the most current part manufactured at point 105 (near the end of the process), then uses that serial number to find out when it started production at point 39 (the front of the process). Then, it gives a listing, summarized by part...more >>

Opening Reports in continuation in pdf fomat
Posted by Rohit J at 8/14/2006 4:38:01 AM
Hi Just wanna know how to open two reports in continuation in pdf fomat I am using Sql server 2000 Reporting Service . The scenario is that I have two reportsA.rdl and B.rdl . The first report A.rdl is to opened in Acrobet foramt with dyamic header/footer. Once the report is completely ...more >>

Dynamically create a snapshot
Posted by Mike Stephen at 8/14/2006 1:28:01 AM
We would like to dynamically create a snapshot, based on other events. We have snapshots based on tables which are created from overnight processes, but which can sometimes overrun. Snapshots scheduled to run at fixed times can then fail because the tables don't yet exist. Any thoughts on ...more >>


DevelopmentNow Blog