×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creative ways to get a 2nd subreport capability from a subreport.

thread149-1801418

Creative ways to get a 2nd subreport capability from a subreport.

Creative ways to get a 2nd subreport capability from a subreport.

(OP)
Any creative ideas or ways to accomplish something similar to a subreport calling a subreport? I know drilling down to a lower group level works well but my client wants to:
#1. start with a consolidated financial income statement
#2. drill down an income or expense line to the divisional level (used drilldown)
#3. drill down the divisional level line (a single GL account) to the multiple detail lines from multiple GL journal entry batches (used subreport)
#4. open the full GL journal entry batch (all GL accounts) for a selected GL batch journal detail line (call another subreport would be great)

I'm sure something like this has been tackled before and hope someone has ideas how to get around the subreport limitation not being able to call a subreport. I'm starting to think #3 will have to include the data for #4 and drilldown to #4 from #3

Appreciate all feedback & comments.

LME

RE: Creative ways to get a 2nd subreport capability from a subreport.

I definitely think you would have to do a group drill down. I know that Microsoft Report Builder allows sub-reports in sub-reports (never tried it myself) with drill down capabilities.

RE: Creative ways to get a 2nd subreport capability from a subreport.

The difficulty I’m having is in envisioning examples of what constitutes a “single GL account” vs. “full journal entry batches”, etc. Could you give a concrete example that clarifies what you mean by each? I think there is a way to do what you want by using two separate subreports maybe in the same section or possibly in different ones, e.g., #2 vs #3. Not sure.

Also think about what you might accomplish by adjusting the subreport links—to get broader data, remove one or more link(s) that is/are limiting the data at that particular level.

-LB

RE: Creative ways to get a 2nd subreport capability from a subreport.

One way of solving this is to use 3rd-party Crystal Reports tools.

See list of 3rd-party Crystal Reports Viewers here.
My DataLink viewer allows a double-click on a Crystal report formula (specifying the report to launch, parameter values...) to launch another report.
This would be one way to address your use case.

Another option is to deliver the multi-level drill-downs as pdf exports from several Crystal reports that get embedded within each other in a single encapsulated file.
This can be achieved by at least one 3rd-party Crystal automation tool (see list of such tools here).
Here is a video demo of how this is done using my Visual CUT software.

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

RE: Creative ways to get a 2nd subreport capability from a subreport.

You are describing a classic dashboard. Crystal report is designed to be a static report. It is useful if you need to print an invoice, form or save a data snapshot in a form of document. Generally speaking it is designed for the paper world. There are some basic interactive options like sorting or drill-down, but even the simplest dashboard will allow you more flexibility and slicing options.

www.R-Tag.com Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close