subreport not displayed

[jmerencilla]

hi. i am using VS .Net as development tool for my crystal reports. i created a simple report with a subreport. their respective data come from 2 simple stored proc on my Oracle DB. testing each report gives me the desired results but i have problem integrating them. i made the necessary connections that links them but only the main report is displayed. what am i missing here? would you guys know? thanks.

 

[Turkbear]

Hi,
It is an 'on-demand' sub-report and, if so, are you clicking on the correct field to get it to display?

Any errors?

 

[jmerencilla]

hi turkbear. i made my subreport on-demand but to no avail. when i viewed it, it simply displayed my subreport name underlined (similar to a hyperlink but not clickable). i'm totally lost. i followed all instruction from a resouce manual i downloaded from crystal decisions' website but still no output. here's my algorithm:

1. create the instances of main and subreport
2. call the stored proc for sub; for main.
3. set the parameters for the main report.
4. bind main report to the web form.

as you can see, my problem is i dont know how to bind my subreport to my main report programmatically. i simply assumed that this is done by crystal report automatically. but during runtime, only the main report is displayed. i suspect this is the reason why i dont see my subreport despite the fact that all necessary connections, etc were done at designtime. would you know how? thanks.

 

[Turkbear]

Hi,
did you do the following?
On the main report page that contains your subreport, right-click on the subreport and choose 'change sub-report links' - this is how you tie the 2 together..

 

[jmerencilla]

thanks turkbear. yup. i joined them using the 'change subreport link'. but still no output. i think i have to code something but i dont know what. would you know? thanks again.

 

[Turkbear]

Hi, One more test..Create a new report and just Join the SP's output( treat them like 2 tables) on the same field you use to link the subreport...see if you get data ( perhaps the 'linked' fields do not actually match ( char v Varchar2 for instance))



ps ( Both SPs return a Ref Cursor, right?)

 

[jmerencilla]

thanks again. what i did was when i called my sp (with the parameters), i return a data reader. then i converted this into a data table. afterwards, i set the report parameters, and finally, set the crystal report viewer control's datasource to the report object. doing this same process for both the main and subreport individually, yeilds the desired output. my problem is i know not how to join the two dataset. would you show me (codes pls.) how to join the main and subreport data from my stored proc? thanks.