vb 2005 reporting question...

[shanzek]

I'm sure this should be simple, but darned if I know how...
I'm doing a report in VB2005. I have a table linked to 3 columns of a view. Here's a sample of the data:
ColumnA ColumnB ColumnC
001 Physician $100.00
001 Nurse $ 50.00
001 Aide $ 25.00
002 Tractor $999.99
002 Jeep $500.00
002 Bicycle No Charge

What I want is 3 columns on the report, suppressing the duplicates in ColumnA, with a box around each major grouping.
So it would show: (excuse the half-a** boxes)
ColumnA ColumnB ColumnC
--------------------------------------|
|001 Physician $100.00 |
| Nurse $ 50.00 |
| Aide $ 25.00 |
--------------------------------------
|002 Tractor $999.99 |
| Jeep $500.00 |
| Bicycle No Charge|
---------------------------------------

I'm somewhat proficient using vb6, but am trying to move towards the .net version. Help!!!

Thanks
Steve

[shanzek]

Nobody has any thoughts on this?
Steve

[GaryMazzone]

Place column A as a group place Columns 2 and 3 as the detail for the group

[Hack]

Moved To Reporting

Are you using Crystal Reports for this?

[shanzek]

No, I am using vs 2005 and the SQL Server Reporting Services features...

Here's an extra credit question:
How can I call a stored procedure once the report has printed to create an audit record of the data printed?

The user will select several parameters, then the report will print.
The report will consist of two pages: a header page with between 2 and 10 data fields mixed in with text pulled from a template, and a second page that has a table of data (between 10 and 20 data elements).
Once the report has pulled the data to print, and the report is actually printed (to a pdf file), I want to write out the actual information used in the report to an audit record, showing who created it, when, the data used, and the name of the pdf file it created. So that 3 months down the road, when there is a question about the report, there is a concrete audit trail of when it was created...
Any clues - I'm just getting my feet wet (and I'm standing on my head...)???
Thanks
Steve

[shanzek]

If I create a stored procedure to select the data to print, I can then use the same stored procedure to select the data to save, as part of a second stored procedure?