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...

If memory serves well : Tablix, create new group. Page break after the group. On export there should be a new tab for each group in excel.

From there...

I wish you better luck than I'll...

Where's the frighing unsubscribe button????