Interesting custom functionality in Reports ... highlighting?

Hello,

I have a report of processes which either go into a Log table or an Error log table. They also have start / finish datetimes and a timespan value. So I want to report the process elapsed time or the error condition, depending on which table the process finished up in.

I then compare the elapsed time to the timespan and then show either a red flag (errored) green flag(worked within timespan) or yellow flag(worked but ran over allotted time) depending on what happened.

Is this possible?

I think it would be easy for me to get the info I want into a dataset using .net code but how do you link that in with SSRS?

Any help appreciated,

Thanks.

Try putting something like this into the background color property of the textbox you want to highlight:

=Switch(Fields!Error.Value = 1, "Red", Fields!timespan.Value > [AllottedTimeValue] , "Yellow", Fields!timespan.Value <= [AllottedTimeValue], "Green")

Hope this helps.

Jarret

sql

Interactively showing reports detailing results/stats of executing a package?

Hi,

I'm just starting out with SSIS and I'm currently looking to migrate some non-SSIS ETL processes to SSIS. Some of these processes are run manually depending on the results from a previous step. In these processes a user remotely executes an individual ETL program and is shown reports detailing the result of the program and various statistics about the data involved.

Is it possible to replicate this behaviour with SSIS / SSRS, or would the user have to execute a package and then manually find and bring up each of the relevant reports?

I'm new to SSIS and I'm still struggling to find out SSIS's capabilities, so I'd be really grateful if anyone could shed some light on this...

Thanks in advance,
Lawrie.
If you have one report, it is possible to stream data directly into SSRS from SSIS. In this case SSRS report uses SSIS as data source. See Books Online for detailed instructions.

Or (this works for multiple reports as well) you can simply start several IExplore.exe using Execute Process tasks and point them to URLs of appropriate SSRS reports - they are usually published to a web server, so you can view them in IE.