dBASE Reports - multiple streamsources ?

Author

multiple streamsources ?

Robin Read

2005-10-27, 8:02 am

Hi all !

Anybody got good references/examples/methodologies
on using multiple streamsources...
....effectively?

Links to other news threads are good!
....haven't been able to find any.

Thanks-in-advance!

--

Robin Read
Nova Scotia, Canada

Ken Mayer [dBVIPS]

2005-10-27, 8:02 am

Robin Read wrote:
> Hi all !
>
> Anybody got good references/examples/methodologies
> on using multiple streamsources...
> ...effectively?
>
> Links to other news threads are good!
> ...haven't been able to find any.
>
> Thanks-in-advance!

Not recommended -- it confuses the report engine.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Robin Read

2005-10-27, 8:02 am

Thanks for your post Ken.

Let me elaborate on what I need in hopes of you guys finding a
solution for me :-))

Essentially, I have a bunch of queries (with MANY fields) in
a datamodule. Many of the queries are NOT connected to each other.
Neverthless, the rowset(s) they return need to be reported in specific
"spots/locations" on a report.
I was thinking that there might be a way to do this with the
report writer. For example, in the dreaded M$ Access reporting
module, you can make specific "locations" on the report run their own
query. Also, to complicate things, if the "grouping" changes each
page
then the queries would change dependant on those groups/pages.

Got any ideas?

Thanks!
Robin Read
Nova Scotia, Canada

Ken Mayer [dBVIPS]

2005-10-27, 8:02 am

Robin Read wrote:
> Thanks for your post Ken.
>
> Let me elaborate on what I need in hopes of you guys finding a
> solution for me :-))
>
> Essentially, I have a bunch of queries (with MANY fields) in
> a datamodule. Many of the queries are NOT connected to each other.
> Neverthless, the rowset(s) they return need to be reported in specific
> "spots/locations" on a report.
> I was thinking that there might be a way to do this with the
> report writer. For example, in the dreaded M$ Access reporting
> module, you can make specific "locations" on the report run their own
> query. Also, to complicate things, if the "grouping" changes each
> page
> then the queries would change dependant on those groups/pages.
>
> Got any ideas?

If you know that you will only need, say, five rows from one of your
tables, what I have done is in the canRender event for one of the text
controls for that part of a report -- fill in the text .. design the
report so it has the five text controls needed (or however-many), and
then in the canrender event, open the table needed, pull the data, and
set the text properties of the appropriate controls.

You can do a lot, but sometimes you have to get *really* creative. <g>

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Robin Read

2005-10-27, 8:02 am

Thanks Ken.

I'm actually trying to find solution(s) for Igor.
I hope he has listened to your reply and
that from you and Ronnie MacGregor from
thre thread
producing/writing report during the run time".

Thanks muchly,
Robin Read
Nova Scotia, Canada

Sponsored Links