How to open Crystal report to Crystal Report

system · November 9, 2009, 11:41pm

Is there any way , I can call crystal report in to Crystal report? I meant I have created Report1, Report2, Report3, etc in Crystal report. Report1 is the main report. Based on Report1 parameter selection Report2 will be open, based on Report2 parameter selection Report3 open and so on…
I can not use Sub-report on this case, becasue I can not add sub-report in to another sub-report.
Any other alternative way to call these reports?

Philip (BOB member since 2006-03-02)

system · November 10, 2009, 5:13am

Using OpenDocument, you can link between Crystal Reports if reports are stored within BO Enterprise. Do a search on OpenDocument. There are lots of topics discussing this.

AnthonyJ (BOB member since 2006-06-30)

system · November 10, 2009, 11:13am

where to use OpenDocument syntex in crystal report? I meant in field or …hyperlink…
please advise.

Philip (BOB member since 2006-03-02)

system · November 10, 2009, 2:11pm

Right click on the field you want to link from and choose Format Field and go to the Hyperlink tab.
From the hyperlink tab, choose ‘A website on the internet’
If using CR2008, you can use the ‘Create enterprise hyperlink’ wizard to help you create the link, otherwise click on the X-2 icon. This will launch the formula workshop editor

Here’s an example


StringVar param :=
"&amp;lsMApplication=" + "["+{@Prompt List - Application}+ "]" + 
"&amp;lsMServer=" + "["+{@Prompt List - Server}+ "]" + 
"&amp;lsSPage=" + {Front_Page.Page Name} +
"&amp;lsSCountry=" + {?Country} +
"&amp;lsSState=" + {?State} +
"&amp;lsSCity=" + {?City} +
"&amp;lsSDate=" + "DateTime"+"("&amp;{@Date Year}&amp;","&amp;{@Date Month}&amp;","&amp;{@Date Day}&amp;",00,00,00"&amp;")"

"../OpenDocument/opendoc/openDocument.jsp?sType=rpt&amp;sWindow=New&amp;sPath=[Reports]&amp;sDocName=ReportName"+URLEncode(param);

AnthonyJ (BOB member since 2006-06-30)

system · November 10, 2009, 5:35pm

Hi Anthony,
Appreciate your help on this.
Could you please look on below URL, state revenue report is opening but with prompt. I do not want any prompt to display. It supposed be display data for those state which user has selected.

'http://server/InfoView/scripts/openDocument.aspx’+"?sType=rpt&sWindow=New&DocName=" + URLEncode(“state revenue.rpt”) + “&sDocName=” + URLEncode(“state revenue.rpt”)+"&lsS{State name}=?Enter State Name:"

?Enter State Name is a dynamic prompt defined in state revenue report.
I had defined State name={?Enter State Name:}

Philip (BOB member since 2006-03-02)

system · November 10, 2009, 8:00pm

Try this.


'http://server/InfoView/scripts/openDocument.aspx&amp;sType=rpt&amp;sWindow=New&amp;DocName=state+revenue&amp;lsSState+name=' + {?Enter State Name:}

AnthonyJ (BOB member since 2006-06-30)

system · November 10, 2009, 8:13pm

Hi Anthony,
I had modified the URL as below. Now no prompt is displaying but I am not geeting any data. Any idea what I am missing here?

'http://server/openDocument.aspx’+"?sType=rpt&sWindow=New&DocName=" + URLEncode(“state revenue.rpt”) + “&sDocName=” + URLEncode(“state revenue.rpt”)+"&lsSstate={?state}"

Philip (BOB member since 2006-03-02)

system · November 10, 2009, 8:58pm

It looks like you are including {?state} as part of the text. By doing “&lsSstate={?state}”, you are passing the word {?state} to the target report instead of the selected state.

Replace “&lsSstate={?state}” with this “&lsSstate=” + {?state}

A few things to note:-

a. The DocName need to be called only once.
b. You need not include the .rpt in the DocName as that is already being handled in the sType=rpt option.

AnthonyJ (BOB member since 2006-06-30)

system · November 11, 2009, 10:21am

Hi Anthony,
I replaced “&lsSstate={?state}” with this “&lsSstate=” + {?state} , but data is not displaying however report 2nd report is still opening.
Let me clear something here:
state={?state} is defined in 2nd report, state revenue report. Do I need to create same prompt state={?state} is in main report and add this in main report URL? If we do so then when main report is refreshed it will pop up promt box. I think I am missing something here…
I just want to pass state parameter in to 2nd report, state revenue report.

Philip (BOB member since 2006-03-02)

system · November 11, 2009, 1:44pm

Most of the time source and target reports have the same parameters.

You don’t have to create a parameter {?state} in your main report if you don’t need to filter out records. If you just want to simply pass the value of a column state in the main report to the 2nd report, you just put in “&lsSState=”+ {name of your state object}

AnthonyJ (BOB member since 2006-06-30)

system · November 12, 2009, 2:21am

Hi Anthony,
It is working now. You are great. I highly appreciate your help on it. I will let you know if I have any question. Once again thanks.

Philip (BOB member since 2006-03-02)

system · December 22, 2009, 7:05pm

Hi
I had created a sales summary report in Crystal Report. On this report one chart for Sales Revenue by Country. If you drill down on this chart another chart (report) will open which is Sales Revenue by State. This two charts are on same report (I had set up in Report Part Drilldown). Final detail report is Sales Revenue by City which is separate report and I had used below syntax for City detail report.
My questions is how to pass Country and State parameters (which is Report Part Drilldown) on below syntax?

'http://server/openDocument.aspx’+"?sType=rpt&sWindow=New&DocName=" + URLEncode(“state revenue.rpt”) + “&sDocName=” + URLEncode(“state revenue.rpt”)+"&lsSstate={City}

Philip (BOB member since 2006-03-02)