Calling one report from other in Crystal reports

Posted on 2005-05-11
Last Modified: 2010-05-01

I have following requirement:
I have two reports A and B.
Report A has 4 columns example department name,Location, zip , country.
Report B is the detailed report about the performance of any single department.

Now what I want to do is when user is viewing the report A and then if he clicks on any value of department column say department 20, then I want to show the report B for department 20 instead of report A.

How can i achieve this using crystal reports version XI.

Thanks in advance,

Question by:subodh2005
    1 Comment
    LVL 100

    Accepted Solution

    Sounds like you want to use a DRILL DOWN report.  Haven't built one but there should be a wizard to help you.
    This may be useful

    Thios could also be done through ON DEMAND subreports though you would click the subreport object rather than the department.
    Create the main report and group on the department.
      Put the 4 columns in the GROUP HEADER
    Add you other report as a subreport iin the detail section.
      Link it to the main report on the department no.
      Right click the subreport object
       Select FORMAT
       Click the check box to make it an ON DEMAND subreport.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction This article makes the case for using two modules in your VBA/VB6 applications to provide both case-sensitive and case-insensitive text comparison operations.  Recently, I solved an EE question using the LIKE function.  In order for th…
    Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now