Hello,
My first post here with 2 questions.
Question 1
I am new to SSRS environment and have been looking to get architectural information to explain me how rdl is processed and rendered. For e.g. all datasets executed and resultsets cached, then all tables rendered... etc. So if someone has any link that would give me an overview, it would be helpful
Question 2
Okay, this may be a bad design here, but I am just playing around to know the basics of data rendering here. Considering this, I have one dataset(Dataset1) that retrives 6 fields from a table. Simple enough. Now here are the things I do: 1)I drag and drop three separate tablix (tablix1, tablix2, tablix3) in one report. 2)Configure each of these tablix(s) to show 2 different fields from Dataset1
So basically we can share "dataset" across tablix(s) within one report. But my confusion is if we can share "resultset" as well.
When i process my report, am I making three separate calls to the database? I thought I am making one call the the database using Dataset1 and then sharing the resultset across the tablix(s).
And this is the reason I wanted to see a document/diagram which shows how the sequence in which a rdl is processed and rendered. So this is scoping question (1)Dataset scope, (2)Resultset scope
Any help is highly appreciated.
Thanks Kala