?
Solved

Programatically Export Crystal Report Drilldown or Subreport

Posted on 2011-03-01
7
Medium Priority
?
1,029 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 35014156
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
ID: 35032790
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 101

Expert Comment

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

mlmcc
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 
LVL 6

Author Comment

by:judgeking
ID: 35042017
Is it possible to catch the event when the export or print button is clicked on the report viewer?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35042136
I don't think so.

mlmcc
0
 
LVL 6

Accepted Solution

by:
judgeking earned 0 total points
ID: 35072206
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
ID: 35120664
(no other experts provided any solutions, as usual)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

752 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