Solved

Programatically Export Crystal Report Drilldown or Subreport

Posted on 2011-03-01
7
989 Views
Last Modified: 2012-05-11
I'm using CRXI in ASP.NET to display reports, and also programatically generating PDF and XLS files in the background in case the user wants to save or print a copy.  The problem is, when the user is currently in a drill-down view and 'prints', he only wants to print his current view on his page.

How can I tell what he's currently viewing and export only that?  Can I 'read' the drop-down in the viewer, can I catch the data on the DrillDown event, something?  I can't use the CR built-in export button, it has to be my own code.
0
Comment
Question by:judgeking
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I don't know of a way to capture what is being drilled into or the subreport that is open.

mlmcc
0
 
LVL 6

Author Comment

by:judgeking
Comment Utility
The generated report with data is saved on the webserver already.  I can get the drill-down level from the CR event on the page.  So what I'd like to do is open that saved report, drill down into the same details and export that drill down.  Does that sound any more plausible?
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
As far as I know there is no way to just export the drilldown unless you know the page numbers to export.

mlmcc
0
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!

 
LVL 6

Author Comment

by:judgeking
Comment Utility
Is it possible to catch the event when the export or print button is clicked on the report viewer?
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
I don't think so.

mlmcc
0
 
LVL 6

Accepted Solution

by:
judgeking earned 0 total points
Comment Utility
I found my own solution to this by creating a second report showing all details and subreports, then programmatically directing the user from the main report.
0
 
LVL 6

Author Closing Comment

by:judgeking
Comment Utility
(no other experts provided any solutions, as usual)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

728 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

13 Experts available now in Live!

Get 1:1 Help Now