more than 2 tables-report in one page

[oVercrasH]

i want have 4 table in one crystalreport
like as image attached

please help me
how can i have more than 1 table in one crystal report page

[sweet_babylhyn]

I think you may use the SUBREPORT.
Find the "insert subreport" in tool bar then click.
-click the option botton report wizard.
-type the name of the second report
-make a connection with the second table you want to view
-after you put the subreport in the main report, right click the subreport
then change subreport link.
click the field that will link the main report to the subreport(primary key)


Note: there must be a link in every table. example: record_id field is present in all table.

OK!

[oVercrasH]

thank you, how can i set subreport like as main report?
i dont want have clickable report to my pgae
subreport have clickable by default, how disable it?

[sweet_babylhyn]

What do you mean "clickable". And where do you want to place the report, in web page or not?

[oVercrasH]

in win application, and in reportviewer when mouse rollover on subreport it icon change to hand (like as button) and user can click on it and change view to it.
i dont need it.

thanks

[sweet_babylhyn]

Do you try inserting subreport in previous report you made?

What did you used, using report wizard or browse the report in your file.
Because when i view my report in web, its a showed like a main report and no buttons to click.

[sweet_babylhyn]

http://intra.vitalink.com.ph/REPORTS/rptspooler_html.asp?mod=PO_Report&sql=select%20*%20from%20q_view_sales_per_principal


copy the URL above and paste in internet explorer to view the report i made. The data below is a subreport(pie chart)

[oVercrasH]

no. this is my first crystal report
i use report wizard and show crystalreport file in crystalreport viewer

[sweet_babylhyn]

Maybe there's a problem your reportviewer. Im sorry i did not encounter the problem you are facing right now.


But i will try to search.

[oVercrasH]

thax anyway