all groups > sql server reporting services > october 2005 > threads for monday october 24
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
Optional page break
Posted by news.microsoft.com at 10/24/2005 6:32:47 PM
Is there a way to create an optional page break?
I tried using a rectangle and using the insert page break before or the
insert page break after properties in conjunction with an expression to
determine if the rectangle should be visible or not
the problem is that when i use the expression on ... more >>
Jump to URL - New Window - Ampersand
Posted by kaibh at 10/24/2005 3:31:10 PM
I have a Jump to URL hyperlink action using the "javascript:
void(window.open)" code. This works great, except when one of the parameters
contains an ampersand. I get an error saying that the "path of the item is
not valid. The full path must be less than 260 characters long, muster start
... more >>
expression based on multiple values in a dataset
Posted by l.holmes at 10/24/2005 2:34:07 PM
Hi
I am trying to seth the background colour of a textbox to either red or
green depending on the multiple values in my dataset.
Each row of my dataset has a boolean value for Pass. The background colour
of the text box needs to be green if all rows in my dataset have a Pass
value of Tru... more >>
Interactive Sort in a matrix
Posted by LaurieT at 10/24/2005 2:17:15 PM
I cannot get the interactive sort to work in a matrix (SQL Server 2005, Sept
CTP). Does anyone have examples on how to do this? Should interactive
sorting work in matricies -- or is it only set up to work with tables?
--
LaurieT... more >>
Fetch a certain row
Posted by Alek Lynge at 10/24/2005 1:08:22 PM
Hi.
I have a dataset with a two column table:
name | value
What I'm trying to do is to make a textbox in the report designer to fetch a
certain field (value) from the table based on the name field.
How to fetch that certain cell from the dataset.
Any help appreciated.
Alek
... more >>
Custom Assembly deserialization issue
Posted by Keenan Chadwick at 10/24/2005 12:27:06 PM
I see a lot of people are having the same issue when deploying to the report
server, even though things are running fine in design mode on their local
machines. I know that you need to copy all assemblies referenced to
/80/Tools/Report Designer/ and /MSSQL/Reporting Services/ReportServe/bin/ a... more >>
Dynamically Adding Columns
Posted by Terry at 10/24/2005 11:49:23 AM
Is there a way to dynamically add columns as a report parameter?
... more >>
Not allowed to install Reporting service
Posted by Isak Lyberth at 10/24/2005 11:46:18 AM
When i try to install Reporting Service 2000 on a windows2003 server with
SQL Server 2000 SP3a and Analysis Services 2000 with SP3a, I get a message
saying that Reporting Service requires SQL Server to have the hotfix 821334
installed.
This hotfix I cant find, only in SP4.
Installing SP4 is not... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Export feature - Show or Hide?
Posted by Immy at 10/24/2005 11:05:10 AM
Hi all,
Is or WILL it be possible to show or hide the Export feature either in
RS2000 SP2 or RS2005?
By this I mean when a user (forms auth.) logs on, dependant on his/her
permissions, they will have the ability to export reports or not by
disabling this feature.
Regards
Immy
... more >>
Can Users choose Rows & columns for a matrix??
Posted by pmud at 10/24/2005 10:26:07 AM
Hi,
Is it possible to create a report which allows users to select the fields
for the matrix in a report. To explain in detail, can we allow the users to
select the X and Y axis for a matrix in a report?
For ex., there is a report containing a matrix which shows the total sales(
data cel... more >>
Report Error when 2 pages for multiple records
Posted by bssolutions at 10/24/2005 9:46:21 AM
We have a web app, built in .Net, with reporting services as our reporting
tool. The problem we are having is when we have a report that goes to
numerous people and the report is 2 pages long. When we make it 1 page,
legal size, it works fine (avg records are 500-900). When this report is
... more >>
Stored Procedure Parameter Problem
Posted by Brennan at 10/24/2005 9:01:02 AM
Hi All:
I have created a stored procedure to act as the data source for a report.
Here is the code:
CREATE PROCEDURE dbo.tshspClosingScheduleRpt
@Community Int
AS
SELECT HomeTypes.HomeType, ClosingSchedule.Lot,
ClosingSchedule.Purchaser, Locations.LocationID, Locations.Locat... more >>
Report usage stats
Posted by DJTN at 10/24/2005 8:45:08 AM
Is there anyway I can see who has ran what reports and when? I have so many
reports that have been requested and I have a feeling they are not being
used. ... more >>
Vertical Text
Posted by David at 10/24/2005 8:09:02 AM
How do I change the text to be layout vertically in a column? So it will
show like this:
t
x
e
T... more >>
Page Header - Displaying Parameter with multiple values
Posted by Terry at 10/24/2005 7:46:05 AM
I am unable to display parameters with multiple values selected from the
report.
How do I resolve this issue?
Code user on page header:
Parameters!ExecContacts.Label... more >>
Dynmaic parameter on Subscription report
Posted by Voss at 10/24/2005 6:43:45 AM
Is it possible to have a dynamic parameter value such as current date
to a subscription base report?
Thanks,
Voss.
... more >>
Page Footer - No totals
Posted by Terry at 10/24/2005 6:29:15 AM
I am unable to total values on the Page Footer.
Thank you for your help!
... more >>
MS Reporting Service for Client Application
Posted by Mohan at 10/24/2005 4:50:03 AM
1. We have Thin Client which is connecting to the Sql Express database. Is it
possible to use MS Reporting Service in Sql Express database.
2. What are the pre requisites shoule be there in my thin client to see my
reports in the thin client.
... more >>
Changing layout for report
Posted by Hanne at 10/24/2005 4:04:02 AM
Hi all!
Does anyone know if it is possible to change the layout of reports? I'm
using reporting services for some new reports in our application, and I want
the new reports to look similiar to the existing reports. Some of the things
I would like to do is to move the parameters to the right... more >>
|