Using DataReports without DataEnvironments...

[phatguy]

I am trying to create customized reports using the MS DataReports, but I do not wish to have the overhead of the DataEnvironment. Is there anyway I can get information into the DataReport without using the DataEnvironment? I have separated my program into three teirs, and would like to keep any database access out of the user-interface teir.

I can access the data through classes and collections. Any help would be greatly appreciated. Please e-mail me at: [email protected] if you have any suggestions.

Daryl

[StarE]

Originally posted by phatguy

I am trying to create customized reports using the MS DataReports, but I do not wish to have the overhead of the DataEnvironment. Is there anyway I can get information into the DataReport without using the DataEnvironment?
Daryl

sample code in your mailbox

[Edneeis]

can you kick me down that sample code as well. Thanks.

[phatguy]

That solved part of my problem. Now, the other annoying part. I only have _one_ details section, but there are three different headers. It goes something like this:

First Item
- First Option
- First Configuration
- First Result
- Second Result
- Second Configuration
- First Result
- Second Option
- Frist Configuration.

Your solution took care of my original problem with the details (ie. the "Result section"), but I am still stuck with the Item, Option, and COnfiguration sections. Any suggestions?

[a2427]

I am doing the same type of thing, could you pass the code along to me as well?

[Rev. Michael L. Burns]

StarE,

I am interested in how this can be done as well. Any chance that you could email me a copy of the code sample you sent phatguy? It would be much appreciated.

Thanks,
Rev. Michael L. Burns

[phatguy]

Alrighty! Thanks to the intial information from StarE, and the wonders of books, I believe I have figured this out! <insert back-flip here!>

It would seem that you can use StarE's idea of putting the database call in the DataReport_Initialize routine, but use a shaped recordset instead of a normal one. This is the way that the DataEnvironment does its job. I have yet to test this, and I will post my results when I have them. If anyone is interested, the book that I am refering to is as follows:

Mastering Database Programming with Visual Basic 6
by: Evangelos Petroutsos
ISBN: 0-7821-2598-0

Definately worth the read.

[Thom]

Hey StarE! Can you send me the code as well?? Thanks much!!

[email protected]

[Tony]

Hi StarE,

Can you send me a copy of the sample also? I am
very interested to learn how to make the datareports
work with a active data connection.

Thanks a lot,

Tony

Originally posted by StarE

Originally posted by phatguy

I am trying to create customized reports using the MS DataReports, but I do not wish to have the overhead of the DataEnvironment. Is there anyway I can get information into the DataReport without using the DataEnvironment?
Daryl

sample code in your mailbox

[William]

Hey

Sorry to be a pain, but I would to see that code as well.

-William

[alwsid]

Don't forget me too. I'm also need to know.. how to code that

[airbaal]

I would appreciate that code also.

Thanks a lot in advance.

Eric

[phinegeek]

how bout just posting the code here... ;]

[wilsonchng]

Can you give me a sample of the code plus the solution to my email?
My email is [email protected]
Thank you.

[wilsonchng]

hello......