SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Tutorial: Adding Conditional Formatting into Reporting Services


Tutorial: Adding Conditional Formatting into Reporting Services

Author
Message
Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: Moderators
Points: 5103 Visits: 235
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colu

Brian Knight
Free SQL Server Training Webinars
Prasanna-158323
Prasanna-158323
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 1

Hi Brain Knight,

I am working in SQL reporting services for the past few months to implement reports module in my project. I have few doubts in that. I have gone thru few sites but no one cleared my doubt. My doubts are

1. Can we have multiple queries for a dataset.

2. Can we have multiple dataset for a dataregion.

The thing is i have to fetch data from various tables to generate the report. (populate in a single table/chart)

Please help me to proceed.

Thanks in advance

Prasanna


mwayshner
mwayshner
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 42

Prasanna,

I am also new to Reporting Services, but have had a similar issue in populating a chart and table - which only allow a single dataset to be tied to it. If you cannot build a query using joins to return a single resultset containing all the fields needed for your chart/table, then, you may have to write a stored procedure which returns the data you need from a temp table. The stored procedure can contain your various queries which populate a temp table - and then have the stored proc return or select those fields needed by your Reporting Services object.





David-171335
David-171335
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 17

I can't use this background color methodogy in a matrix.

When I use the expression:

=iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")

I receive the error:

The background color expression for the textbox ‘textboxname’ has a scope parameter that is not valid for RunningValue, RowNumber or Previous. The scope parameter must be set to a string constant that is equal to the name of a containing group within the matrix ‘matrix1’

How can I modify the expression to resolve this?

thanks for any help.


Evester Robison
Evester Robison
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 1
I am trying to get an answer to this question as well, any help would be greatly appreciated!
philip shackleton
philip shackleton
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 1

Did you get a solution to the "The scope parameter must be set to a string constant that is equal to the name of a containing group within the matrix" issue ?#

Any help appreciated.

Regards,

Phil.


jwainz
jwainz
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 40
Thanks Brian, one more step into the world of Reporting Services.



jlwilliams1
jlwilliams1
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 1

Thanks for the articles, Brian. This is the first time I've used the Reporting Services and I'm anxious to try more.

One question though. The reports generated are static, right? I mean, they don't update or refresh as data changes? If so, do you plan to write an article on how to create a dynamic report page? I'd like to create a series of job report pages that would automatically generate reports each morning on the previous night's jobs for each of our servers.

Also, I'd like to find out how to deploy the report to a different server. Right now, it deploys by default to your own computer (localhost) which is fine for testing but suppose I want to deploy it to our web server which sits outside our network in a "DMZ"? Do I need to install anything on the web server to run these reports? How can I share out the reports I have on my computer with others?

And how and where do I delete reports?





MatthewPhillips
MatthewPhillips
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 1
Yea, that RowNumber(Nothing) is really bothering me. Doesn't work for a matrix report, only table. Any ideas?
Ron Buchanan
Ron Buchanan
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 9
I have been using SSRS since it came out for SQL 2000.

1. One of the questions asked for multiple queries per DataSet. In this, one query IS a DataSet, so the answer is no. Do not think of the DataSet as the same one in .NET.

2. If you want a report to automatically refresh, this is not possible without a call to the server. So, to simulate this, under the "Report Properties" dialog, check the "Auto Refresh" box and set your interval.

3. As for the RowNumber problem, I am not sure. Have you tried putting it at the row level and just changing what you need there? I have never had a need to do a matrix yet, so I am not sure. It would make sense why it wouldn't work since a matrix is not a listing of data rows.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search