SSRS Developing a Report

Question

Post reply

SSRS Developing a Report

rana_gman

SSC Enthusiast

Points: 190
More actions
April 1, 2010 at 2:09 pm

#386624

I have created 2 data sets. The first one executes a Stored Procedure. The second one retrieves data from the table that was populated by the Stored Procedure (called by the first dataset).
The issue that I'm having is that the data that's returned by the second data set is not always correct and only when u refresh your report a couple of times is when the data retrieved by the second dataset is correct.
Is there a way to tell the 2nd data set to execute only on execute of the 1st data set?
Thank you.
GSR

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ben Teraberry SSChampion Points: 11845 More actions · Answer 1

Have you tried doing both parts of the process in the same stored procedure?

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

rana_gman SSC Enthusiast Points: 190 More actions · Answer 2

No I have not. But here's the issue. The purpose of the stored procedure is create detail sets of data and output it to a flat file. All I want to show on the report is a count of records that was populated into the tables (3 of them).

I'm sorry if I didn't answer properly to your question as I'm a newbie to SSRS.

Ben Teraberry SSChampion Points: 11845 More actions · Answer 3

If I understand you correctly, this isn't really a SSRS specific issue. You're trying to do something and then get the results of that something before the something is done. If you need them logically tied together in order, you need to do them together.

How long does it take your process to write out the 3 text files?

└> bt

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

rana_gman SSC Enthusiast Points: 190 More actions · Answer 4

The process runs in less than a minute.

Also, how do I get the stored procedure in SSRS to recognize the return value as one would have done it in T-SQL (i.e. exec do_proc @a, @b-2, @C output, @d output).

thank you.