all groups > sql server reporting services > november 2006 > threads for friday november 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
general Reporting Services question
Posted by Vadim at 11/10/2006 4:08:43 PM
Hi,
Is it possible to run Reporing Services reports from a client Server app
without installing anything to the IIS?
Kind of Like Crystal does where you can distribute report viewer and install
on a client's machine.
Thank you,
Vadim
... more >>
"Next Page" is extremely slow - like it's requerying
Posted by Jordan at 11/10/2006 1:41:55 PM
I have a report with a single dataset, 3-levels of table grouping, and
returns 5 pages. When I preview the report in VStudio, it returns the 5
pages and I can navigate the pages real quickly. The problem is, when I run
it online via the RS front-end and click "Next Page," it takes a good 30
... more >>
Detecting the Render Setting at Runtime to Affect Report Formatting
Posted by mmurphy1005 at 11/10/2006 1:14:51 PM
Is it posisble to detect at runtime the render type that was selected?
And if so, can the rendering of the report objects be controlled based
on the render type that was selected.
For example, if I render a report to PDF, I want to display a nice
title header at the top of the page. But if I ... more >>
RS formatting ?
Posted by aggiechick717 at 11/10/2006 12:11:34 PM
Hi all,
I have a report that allows users to choose one or more parameter
values and then a report is rendered based off of that input. I have a
table that I want to always have 8 rows, but if the report returns only
2 rows I need to add 6 blank rows to the end of the table. If the
report r... more >>
Firefox(2?) report rendering problems
Posted by Brian Orrell at 11/10/2006 11:55:01 AM
Hi, recently added a reportviewer control to a page and it rendered
incorrectly in Firefox 2. So we made a custom report control that calls the
reporting services and renders in HTML 4.0 and the formatting is still messed
up. Basically everything is crammed into the left 5% or so of the page... more >>
conditional subscriptions / business day logic
Posted by Lynn at 11/10/2006 11:42:01 AM
I need to know if there's any way to refrain from sending an email if the
tSQL behind the rdl is empty? it's a trading report, clearing-type
information is sent out in a report via reporting services. i do not want to
send a blank email if no trades exist. but i must have it in
place/enab... more >>
parameter question
Posted by Brian L at 11/10/2006 10:38:02 AM
I'm passing a parameter to a SP in SSRS '05. The parameter values are derived
from a query that selects values based upon a group membership. What I need
to be able to do is add a value to the list so that a NULL is passed back so
that those values not belonging to the group are selected (thi... more >>
Custom Report Item: Textbox
Posted by gbouzebra at 11/10/2006 10:06:01 AM
Hi all,
If it is possible, how I can extend the Textbox item with a DataSet
property. In order to display a field from multiple rows, with a separator ?
Example:
a dataset with 10 rows (and 1 field "Name")
and I want to display in the Textbox
"Name1, Name2, Name3, Name4, Name5, Name6,... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Report Builder
Posted by Steve at 11/10/2006 10:02:45 AM
I'm very experienced with SQL Server, but new to reporting services. I'm
currently working with the Report builder, and I'm having a hard time trying
to get it to work as I need.
From my web app, I'm able to put a link on there for ad-hoc reports.
Clicking it opens the report builder. The... more >>
multi value parm derived from other multi value parm problem
Posted by OyVey at 11/10/2006 8:42:01 AM
Hey all,
I have a sql query dataset that uses parameters derived from 2 previous sql
query datasets:
SELECT MachineID,
ModelNumber,
ProductName
FROM Admin.dbo.PricingMachine
WHERE MachineType IN (@GroupType) ... more >>
Multi Value Parameter and Filtering
Posted by Are friends electric? at 11/10/2006 8:34:02 AM
Hi All
I am trying to filter a table on my report based on a multi-value parameter,
I have tried several methods to no avail. When I use the following I do not
get an error but I do not get data showing on the report.
Expression is set to =Fields!Account.Value
Operator is set to In
Valu... more >>
Matrix Report Background Color
Posted by duhaas NO[at]SPAM gmail.com at 11/10/2006 8:21:41 AM
I have the following applied as an expression to the background color
on a cell
=IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") >= 10, "Yellow",
"White")
I only want the ones above 10% to be yellow, otherwise white.
Any ideas anyone on why the entire range of cells are yellow and not... more >>
Unable to add New Role Assignment
Posted by Brian Ackermann at 11/10/2006 6:44:16 AM
Hello all!
I've researched this problem and was not able to find anything like
what I'm experiencing in the archives.
Basically, my Reporting Services is running on SQL Server 2000, and has
been working flawlessly for more than a year. I am unaware of any
changes having been made to it at ... more >>
Reporting services offline
Posted by aka at 11/10/2006 4:47:01 AM
Hi all,
Can any one help me how reporting services work offline .I heard in
Sqlserver2005 reporting services ,there is a component which ables to run
reporting services on client system also.
Please kindly help me.
I am very much in need of it.
thanks in advance to all
miiku... more >>
How can I Associate DataSource with Report using Code
Posted by Krishna kumar.M at 11/10/2006 4:42:01 AM
hi,
Thx. in advance.
How can I Associate DataSource with Report using Code.I'm using Reporting
Service Web Serivice
I tried this below code but it is giving error
like
"The data source 'DS_Code_002' cannot be found in this report. --> The data
source 'DS_Code_002' cannot be found... more >>
|