Help outputting a Break - Level Report

[splaisance]

Hello All!

I am looking for some advise or hints here. I have to create a break-level report in VB. There are 3 levels to check for - with the smallest level being detail lines. The problem is what is the best way to create the report so that I can format it how the company wants. My knowledge of the data environment/data reporter is limited but I don't think I can use it because the details need to gather different information based on what -type- of detail line it is.

Currently I am simply using the Printer.print property and adjusting it that way.

Any ideas or suggestions?

Thanks!!!

X-)

S-

 

[Phathi]

Not too sure that I understand you,

but if you're looking to group data from an SQL statement, then have a look at thread222-124796


Ciao

 

[splaisance]

No - I guess my point is the data can not be grouped with an SQL statement. So the question is - can you create a report in VB other than using Print statements if the data to be printed is too complex to group with an sql statement?

-S

 

[scorpio66]

You can use a DataReport and pass a Shaped query (use the MSDataShape provider) to achieve what you want. I've recently given some instructions to MichaelBronner about this.

see thread222-124796

Chaz

 

[splaisance]

Hmmmm - I read the thread on the shaped query and it was helpful in understanding how to use that function. However, In this report I don't see how I can use it. Here is the structure I am working with:

ReportDesignName (the user chooses one name or all names)
For each name
- Code Number (user chooses one code or all codes)

For each code
- Process lines
Each line has a type H for the main code line
S for a subtotal line (Here I must go and get monthly $ amounts for the date range entered)
G for grouping several acct #'s and showing $
GT a total of groupings
T total for previous lines

The $ fields are in different files depending on the year entered. If there is a way to use the shape to accomplish this.... well it's quite beyond my capabilities!!!

Can shape be used for the above structure? Or can you use the data report without giving it any type of record source?


-S

s-)

 

[scorpio66]

The data report can produce sub totals and group totals for you (as well as counts, etc) so you don't need to include those totals in the query itself.

I'm pretty certain that a combination of Shape and Data Report that you can achieve the results that you are looking for.

Chaz

 

[splaisance]

Well I'll play around with the shape and data report some more... but the only thing about the group totals is that they will ONLY want them if a type T line is there for the specific code..... So I would need to be able to 'turn off' the totaling in the data report.


Thanks for the help!

-S