Creating reports and dashboards | Stimulsoft community forum

Hello to you,

I'm using stimulsoft report 2013

I want to create master detail report
Database is in MS-Access

tbl 1
invoiceno id_no seq_no description
001 1 1 a
001 1 2 b
001 2 1 c
001 2 2 d
001 3 1 e

tbl 2
invoiceno id_no seq_no description amount
001 1 1 Alice 100
001 1 2 Mike 150
001 2 1 Jack 200
001 2 2 Brown 500
001 2 3 Margareth 100
001 2 4 Bobby 150
001 3 1 Shaun 400
001 3 2 Lewis 200

How to figure out master detail report becomes :
invoiceno id_no seq_no description amount
001 1 1 a
001 1 2 b
001 1 1 Alice 100
001 1 2 Mike 150
001 2 1 c
001 2 2 d
001 2 1 Jack 200
001 2 2 Brown 500
001 2 3 Margareth 100
001 2 4 Bobby 150
001 3 1 e
001 3 1 Shaun 400
001 3 2 Lewis 200
Total 1800

I attached the database file (dbinvoice.zip), please show in .mrt file

Please just rename the dbinvoice.zip becomes dbinvoice.mdb (because due to cannot uploaded in any other extension, so i just simply renamed its extension)

Thanks & Regards,
Steven

Hello.

It seems that you should create master with 2 detailes report.
Sorry, but we need some time to prepare sample for you.

Thank you.

Hi Aleksey

Thanks for yr reply.

I'm waiting for your solutions

Thanks & Regards,
Steven

Hello,

The sent archive is corrupted. Please send it again.

Thank you.

Hello.

Here is a sample report template where we use DataSource from other DataSource to create master-detail report. But you could use one more SQL query to your Access database.

Thank you.

Hi Aleksey,

That's what i want, you're great

Thanks very much (two thumbs up)

Regards,

Steven

Hello.

Thank you for using our product.
Let us know if you need any help in future.

Thank you.

Hi Aleksey,

Based on above case, creating master-detail report. I can successfully create report using designer.exe (stored into WindowsApplication6\WindowsApplication6\bin\Debug\report1.mrt) and the result is as I want.

Now I coded from VB.NET using VS 2010
But I hv problem to produce its report (stored into WindowsApplication6\WindowsApplication6\bin\Debug\invoice.mrt)

Please help and thanks in advance

Regards,
Steven

Hello.

What type of problem do you have?
Could you describe your issue more detailed?

Thank you.

Hi Aleksey,

The report1.mrt (stored in WindowsApplication6\WindowsApplication6\bin\Debug) is the report what i want
This report included connection, etc

The invoice.mrt (stored in WindowsApplication6\WindowsApplication6\bin\Debug) is report i created to produce same as report1.mrt but the connection is from VB.NET 2010 and the datasource is prepared from VB then push to report.

Because in my mind, to produce a report from VB 'must not' have connection? (please correct if I'm wrong)
or Is there any simple way to produce the report1 from VB?

Please help me to produce it and thanks in advance

Regards,
Steven