September 25, 2012 at 7:11 am
Hi,
If a report has one dataset DS that populates 2 data regions tablix and graph in same report but in a different manner. (tablix just the raw data and graph deviation/aggregations)
does it mean the sp that populates DS will run two times to fill the data in both data regions or only once?
thank you for the insight.
NOTE: when I insert the graph in tablix that means make them one data region instead of 2 . report runs faster, only the report has lots of empty space.
****details******
The report has 2 data regions tabllix (raw data) and a graph(aggregation /deviation of raw data).
the main SP query-Result-set has a column "data" that has yes/no as values
In the report
* if yes then show it in tablix
* if no then show it in graph
stored proc SP--> populates dataset DS --> populates tablix and graph respectively but in different manner depending on column "data" that has yes/no as values
September 25, 2012 at 7:26 am
I don't know, but it's easy enough for you to find out, if you can run a trace (Profiler or server-side) on the database where your query runs. That'll show whether it gets run twice or not.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 25, 2012 at 8:06 am
SQL_path (9/25/2012)
does it mean the sp that populates DS will run two times to fill the data in both data regions
I would hope not.
At the very least it would introduce the possibility that the data in the two regions could be different on the same report!
September 25, 2012 at 9:23 am
thanks both of you !!
I ran a trace and it ran once.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply