Database location share with parent and child

[JustinLeung]

I have created a report that with a subreport and those are share with same file(same location also), becos the report is using a dynamic generated data file, so ,how can i config the subreport using the same location as parent without coding in programming side ??

thx for all your valuable comments and suggestion !!
thx a lot!

 

[synapsevampire]

Not sure what this means:

"how can i config the subreport using the same location as parent without coding in programming side ??"

You can use the exact same data source in a subreport and main report, and even in the main report you can join a table to itself (self join) by placing the table in a second time and linking appropriately.

Hope this helped, if not, try supplying actual table structures and expected output rather than just a description.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[JustinLeung]

my english not good for descript, let me try to say in real situation. thx for your reply, synapsevampire

I wrote a program to build a DBF file dynamicly name abc.dbf
and the field contents are follow :

TxID Seq Amount Remarks
1 1 2,000 aaa
1 2 3,000 bbb
2 1 1,000 abc
2 2 4,000 ccc
3 1 1,000 eee
4 1 4,000 fff

and expected report will list as

TxID Amount Remaks
1 5,000 aaa
bbb
2 5,000 abc
ccc
3 1,000 eee
4 4,000 fff

The only and the main criteria is SUB REPORT MUST use the same data file as PARENT. and not involve progamming., So, how can i do this.

Thz for all reply again.