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 > october 2006 > threads for tuesday october 10

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

Database Synchronization IN Analysis Services 2005
Posted by somuthomas NO[at]SPAM gmail.com at 10/10/2006 10:32:49 PM
Hi, I am getting errors while synchronizing databases between two machines in my LAN using the SQL server 2005 Management Studio - analysis services' synchronize option. After the XMLA script generated by deployment wizard from my cube was executed successfully. I kept my system as the Develo...more >>


How to show table header in each page
Posted by Jason Chan at 10/10/2006 8:12:02 PM
I want the table header appears in each page, how can i do this? Thanks. Jason...more >>

Advice on Data Warehouse & Web Reporting
Posted by C4rtm4N at 10/10/2006 4:13:26 PM
I'm about to embark on re-writing a database & bespoke web reporting application for our call centre & would like a little advice please. Currently the database has 10 tables containing summaried (<=1 record per staff member per day) data from different legacy systems, populated by DTS. There ...more >>

Reserved Error importing Access 2003 Report into VS2005 Report Module, How do I troubleshoot
Posted by Rob Dob at 10/10/2006 2:50:27 PM
Hi, I'm trying to Import an existing Access 2003 report into into an existing VS2005 Report Project, I am getting the following error. Is there a way to troubleshoot what is causing this error? Importing reports from 'C:\db2.mdb'... Error : An error occurred while the report Test Report ...more >>

Export Formulas w/ Excel
Posted by Greg Rowland at 10/10/2006 2:39:29 PM
Is there a way to export report formulas, when exporting a report to Excel? Thanx in advance, Greg Rowland ...more >>

Matrix Rows
Posted by Brian Shannon at 10/10/2006 2:34:11 PM
Is it possible to move rows in a matrix up and down from its original position? Preferably in a drag n drop structure. Everytime I add a new field to a matrix I need to do manually change the field names in the text box in the position I need the new field name. Thanks. ...more >>

Open report in a new window
Posted by AB at 10/10/2006 2:10:56 PM
Hi, Does any one know how to open a report that is a link or " jump to report" in a new window and not instead of the previous report? Thank you Avi. ...more >>

Query Problem
Posted by Wayne Wengert at 10/10/2006 1:47:50 PM
I am using the query shown below but I am not getting the result I expect. I want to get "Elected" only when the count of LastName field is 75% or more of the count of when the "CG" field is equal to "Y". What did I mess up here? ============================ =iif(Count(Fields!LastName.Valu...more >>



Totals and groups - how to calculate grand totals inside groupings
Posted by DragonVic at 10/10/2006 1:43:02 PM
have a report that has groupings that need to figure out the percentage of the grand total. Example: Group1 Count Total Count% Total% 100 1000 33.33% 25.00% <--detail 200 3000 66.67% 75.00% <--detail Group 1 Totals ----- ------ ---...more >>

How to tie ? to parameter name?
Posted by dgk at 10/10/2006 12:40:45 PM
In the Visual Studio (2005) designer, I created a report, data source, and dataset. The query is essentially Select * from Table1 where ClientID = ? Under Report Parameters I changed the name Parameter1 to CIDParam, so that it is somewhat meaningful when I call it from code. But when I try to...more >>

Multi-Value parameter syntax error
Posted by StMaas at 10/10/2006 11:12:02 AM
I am new to reporting services... I've created a report that uses a multi-value parameter based ona dataset usign a simple select statement. It works fine when a single value is selected, but when multiple values are selected returns the error Incorrect Syntax near ','. How can the report ...more >>

Multi-value parameter returns syntax error
Posted by StMaas at 10/10/2006 11:03:01 AM
I've created a report that includes a multi-value parameter, however when more than one value is seelcted from the list the report produces an error that references "Incorrect Syntax near ",". How do I correct this? ...more >>

PDF Report not reflecting changes after update
Posted by John Swaringen at 10/10/2006 8:35:28 AM
I've working on a report at a client and I'm having an issue with a report not reflecting multiple updated. The basic procedure that is followed is: 1. The client adds an event to the timeline. 2. The client runs the timeline report and the new event shows up. 3. The client adds a new event ...more >>

Need a book for reporting services.
Posted by matt cupryk at 10/10/2006 7:40:27 AM
http://www.amazon.ca/s/ref=nb_ss_gw/701-8175374-6201155?url=search-alias%3Daps&field-keywords=reporting+services I need a book to do the following: Create a format of a report. Define parameters of a format of a report, name, description. Choose options of period of report Modify the ...more >>

SRS2000, VS2005 and CRM3.0
Posted by CrystalJim at 10/10/2006 7:39:02 AM
System = W2003, SQL server 2000 sp4 (SRS 2000 SP2), Dev workstation XP Pro We are in the process of migrating from CRM 1.2 to 3.0 and we cannot find the answer to this question: Can we use Visual Studio 2005 and SRS2000 to create reports for CRM? Our partner does not know the answer an...more >>

custom style sheet
Posted by Jayachandran at 10/10/2006 2:13:40 AM
Is it possible to have a common styles like css in reporting service.If it is possible please let me know how to call a specific css class name in reporting service. Regards, Jayachandran EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

show details horizontally
Posted by Erik Thijs at 10/10/2006 12:00:00 AM
Hi, I'm using reporting services on a SQL server 2000 platform. I now wat to create a report that shows a student list, grouped by class, and listed horizontally. Dataset output: Name class ---- ----- anny 1ba1 betty 1ba1 cindy 1ba1 danny 1ba1 evy 1ba1 franky 1ba1 ginny 1ba1 Th...more >>


DevelopmentNow Blog