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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|