Using DataReports without DataEnvironments...

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

Quote:

---

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

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

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?

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

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

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.

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

[email protected]

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

Quote:

---

Originally posted by StarE

Quote:

---

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

---

Hey

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

-William

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

I would appreciate that code also.

Thanks a lot in advance.

Eric

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

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

hello......