oralinque (3/29/2010)

---

I've come to the realization that I won't be able to rely on the sum of the duration column for reporting the accumulated time it takes SQL Server to...

min(starttime), max(endtime))...

I don't have a copy of the trace but if you have open connections for a few minutes before starting the "real" work or a few minutes after the...

You can always e-mail me the rough versions of the incomplete articles... might be enough to qench my thirst for now :-P.

I know I'm about 6 years behind on this article... but when's the next one comming out? You promess more info but apparently you got sucked into work and...

Look up coalesce and isnull in the books online (bol for short or sql server's help documentation).

Just throwing ideas in there...

are you using multiple threads in the application?

are you using parralelism?

Your query seems to basically use this equation... endtime from las query - start time from...

ya but from 18 days ago... so maybe not a bad idea to answer it now :-D.

I want my points back.

Oh nevermind, I don't care!!!

P.S. Steve told us earlier that he does review the questions but only to correct obviously wrong, wrong (or good?) answer or...

GSquared (3/18/2010)

---

When I open the plan, I get 11%, 39%, 25%, 1%, and 0%, for each sub-query, which adds up to 76%, which is obviously just as wrong, but in...

Ok I just hit google and I found those 3 usefull links :

Subreports with reportviewer control :

http://support.microsoft.com/kb/919157/en-us

The gist of the solution which I've just skimmed through seems that...

GSquared (3/17/2010)

---

You're on the right track.

You'll need a dataset for the header (and any footer you have planned).

You'll need a dataset for the body of the report. Most likely,...

Luke L (3/17/2010)

---

I'm with Gus and Vishal on this one. Do one dataset to take care of header/footer info and then create subreports based on that. You can...

Vishal Mehta (3/17/2010)

---

when I did a simmillar thing I encased all these datasets that build the "body" of the bill into a List Tool and this allowed repeating fields based...

Hey guys, can you throw me a bone here for SSRS how-to-make-a-simple-billing-report?

I can't find anything usefull on google which means I don't know what to search for!

http://www.sqlservercentral.com/Forums/Topic884086-150-1.aspx

TIA.

Seriously, anyone has any remotly usefull guideline???

I don't want you to do it for me, I just want someone to guide me like :

make dataset for header.

make second ds...