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 > january 2006 > threads for thursday january 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

Export to PDF issue
Posted by Sean at 1/26/2006 7:16:01 PM
Hi, I have a strange problem with a report when it is exported. My report has a textbox on it which dispays the value of one of the parameters selected by the user. When the report is displayed in the browser everything is positioned correctly on the screen. However, when I export the repor...more >>


Infinity
Posted by William Stacey [MVP] at 1/26/2006 6:08:02 PM
First row show "Infinity" with this calc. =((Fields!Total_Rooms.Value - Previous(Fields!Total_Rooms.Value))) / Previous(Fields!Total_Rooms.Value) How to not show "Infinity" on first row? TIA -- William Stacey [MVP] ...more >>

Can I Deploy a report to a client who doesn't have SQL server license.
Posted by Roberto Hernández at 1/26/2006 4:44:25 PM
How can I Deploy a report with my visual Studio.Net application to a company who doesn't have SQL server license? I plan to use SQL Server 2005 Express. ...more >>

How do I use a calendar control in SQL Reporting Parameter
Posted by SDRoy at 1/26/2006 2:30:03 PM
Could someone help me to understand on how to use a use a calendar control in SQL Reporting Parameter ? Thanks in advance. -- Thanks, SDRoy...more >>

c# code
Posted by William Stacey [MVP] at 1/26/2006 2:04:38 PM
Any change Reports will have option for c# code in addition to just VB? -- William Stacey [MVP] ...more >>

Question on subreports
Posted by jhcorey NO[at]SPAM yahoo.com at 1/26/2006 12:37:51 PM
Right now we have one report with two tables in it. The tables are populated from two different stored procedures. The two tables contain detail and summary information respectively. We call the report from a web app, and users can elect to see detail, summary, or both. We pass a parameter...more >>

Displaying duplicate row in red color
Posted by pmud at 1/26/2006 11:21:01 AM
Hi, In my report, I have used a table. In the table, I want to display all the duplicate rows in red color, i.e if Field1 is listed twice in the table details, then I want to display the duplicate row in red color. ANy ideas on how to achieve this? Thanks -- pmud...more >>

Data-Driven Subscription - Empty Field List on Step 4
Posted by Steve Muise at 1/26/2006 10:43:02 AM
I am attempting to create a data-driven subscription. I step through the wizard, paste in the query, validate and click next. When I get to the screen to map the fields from the database table to the fields in the subscription (to, cc, reply-to, etc). There are no fields in the drop-down. I h...more >>



Cached Datasets
Posted by isicoder at 1/26/2006 10:27:48 AM
Doing a profiler on our sql box during the generation of a SQL reporting service report, I noticed that three queries were taking place. We have three datasets in our report. One is to get information for paramater A, another for Parameter B and yet the final dataset which returns the info...more >>

Datasets
Posted by isicoder at 1/26/2006 10:19:44 AM
When using datasets in reports, is it possible to reuse them in other reports? For example a generic dataset that returns all employee names to use in parameters. Another report needs the same parameter and we need to create another dataset. Is there some mechanism to share the datasets a...more >>

Custom Authentication in RS 2005
Posted by TechnoSpyke at 1/26/2006 10:00:56 AM
We are currently using RS Standard Edition (SE). With the first version of RS, Custom Authentication was only available for the Enterprise Edition (EE). I was reading the new features of RS 2005, and I noticed that Custom Authentication is now available for both SE and EE licenses. Is thi...more >>

a slight improvement to a great solution...
Posted by thejez at 1/26/2006 9:22:06 AM
This is a great solution! I've modified it a bit to make it a little more manageable though for my own use. I decided to make a version where the row colors could be centrally managed since you have to copy the expression to every cell in the row... and in some reports that can be a lot of c...more >>

Use SQL 2000 Reporting Services with VS Express products??
Posted by tlyczko at 1/26/2006 8:16:27 AM
If I install SQL Server 2000 Reporting Services on our SQL 2000 box (SP 3a), can I use it with the Visual Studio Express products, particularly the Web Developer product?? If so, how?? We are licensed for the SQL server, but we don't have VS 2003. I suppose I could learn the VB.Express 2005...more >>

Uninstalling Reporting Services
Posted by Tom at 1/26/2006 7:12:02 AM
I have installed SQL Server 2005 and SQL Server 2005 Reporting Services. I would like to uninstall Reporting Services only. Under Add/Remove Programs I only see a choice for SQL Server 2005. How can I accomplish this?...more >>

Problem when installing MS SQL Reporting Service
Posted by chriswsk NO[at]SPAM gmail.com at 1/26/2006 1:14:30 AM
Hi, I need help. I am trying to install the Reporting Service. When the screen was in "System Prerequisites Check", it tell me that visual Studio.NET 2003 is not installed. After clicking next in "System Prerequisites Check" It jump to a page called "Welcome to ...SQL Reporting Service S...more >>

SQL code to calculate from 25th of last month to 26 of this month
Posted by Marcel at 1/26/2006 12:31:33 AM
Hello, I have this report that runs automaticaly on the 26th of every month. I have SQL code that uses @start and @end as parameters, but I can't seem to find out how to make a dynamical SQL string to get the 25th of last month and the 26th of this month. Does anyone know if this is possible in...more >>

RS 2005: Use a Custom Class as DataSource?
Posted by Pieter at 1/26/2006 12:00:00 AM
Hi, Is it possible to use a Custom Class/Object as a DataSource/DataSet for a report? I have now for instance my object MyCompany, and it woudl be nice to just use a MyCompany-instance as the DataSource... Any hints/help woudl be really appreciated, Thanks a lot in advance, Pieter...more >>

RS 2005 + SQL2K
Posted by Paul Paintin at 1/26/2006 12:00:00 AM
Does anyone know if it would be possible to put an instance of reporting services 2005 with a SQL 2000 database at the back end? Haven't played around with an instance yet, just gathering intelligence, and I'm not optimistic, just curious. Cheers, Paul. ...more >>


DevelopmentNow Blog