Solved

Crystal Reports Sucks (can't navigate except for the VCR controls)

Posted on 2006-10-19
11
293 Views
Last Modified: 2012-08-13
Crystal reports is not working out.  I have been using Crystal Reports for Visual Studio.NET for the last year, and while it does make it easy to categorize, print and export to .pdf - it also seems to lack any innovation when it comes to navigation.  I know my users do not want to scroll through 100's of pages of reports using only the vcr controls.  The simplest built in kepboard shortcuts would make it so much easier to work with, but PAGE UP & PAGE DOWN does nothing, CTRL PAGE UP & CTRL PAGE DOWN does nothing and UP, DOWN, LEFT, RIGHT does nothing (even after I deliberately set the Focus to the Crystal Report Viewer (using C#))

Anyway, I suppose if anyone has any idea how to make Crystal Reports do some kind of keyboard navigation (using Crystal Report Viewer in C#) that would be the easiest solution.  But since all the forums i read on the subject have been bad news - I guess the real question is, where do I go from here?  There has to be a better report generation tool out there, since Crystal Reports for Visual Studio.NET does not seem to be all that great.
0
Comment
Question by:rcouret
  • 3
  • 2
  • 2
  • +3
11 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 17769742
Business Objects XI and Crystal Reports XI are the PREMIER business intelligence tools on the market today. Perhaps you may not have the experience or opportunity to delve deep into all of the data intelligence capabilities that this product offers.

What version of Crystal are you using and what are you wanting to do?

Navigating using a keyboard is not advanced and you could find a ad-hoc tool that may be able to help you out. MS EXCEL is one that comes to mind first.

But if you want to do some very advanced query and analysis (Business Intelligence) Nowhere else to go but Business Objects XI / Crystal Reports XI.

What say ye....?

MikeV
0
 
LVL 3

Expert Comment

by:ThomasBallardIT
ID: 17769840
If you do a good job with your drill down, then you should never have to leaf through hundreds of pages.  Also you can use ctrl+f (find) to look for what you need.
0
 

Author Comment

by:rcouret
ID: 17769905
I dont know what version it is, it came with Visual Studio.NET 2003, and in the Help About it says Crystal Reports for Visual Studio .NET

You say that navigating with a keyboard is not advanced, but there has not been one article with a solution on how to accomplish this that I have read.   I am not sure what you mean by using MS Excel - as I dont see a relation between crystal reports and Excel...  Unless you mean just make the report in excel - which is a good idea but it would not feel like it is part of the program I am developing.

I dont really need to do any more advanced query and analysis then I am already doing with Crystal Reports, and I am satisfied with how the report looks - I just cant stand that there is very little a programmer can do to modify its behavior especially when all I want to do is be able to use the keyboard to look at the report.

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 17

Expert Comment

by:MIKE
ID: 17769962


You are the one that controls HOW your final report looks. So if you want to have the ability to DRILL DOWN..or...display a PIE CHART whereby you CAN Click on the piece of pie and it drill down to another chart..or to detail..then you are in control of that as this is all based on how YOU create the report.

I'm not sure what you are asking, but if you have some specific report creation questions, I'm sure we could help out.

What kind of report do you have created and what are you wanting it to do.

I think your problem stems from the fact that you may be using a VIEWER and may be limited in what you can do once a report is created?

Need more info..

Thanks
MikeV
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 17770232
A high-level solution would be to generate the report in .pdf format...

~Kurt
0
 

Author Comment

by:rcouret
ID: 17770274
Yes, exactly...   I have a form in my program with a CRViewer control in it - and the report is created dynamically using a single dataset that queries the most recent data,    Is that the wrong way to go about it?
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 17770406
frodoman or mlmcc can probably give more information on generating the report in .pdf format.  I'm not a programmer, but that's what I recommend you do to alleviate your issue.

~Kurt
0
 
LVL 42

Accepted Solution

by:
frodoman earned 125 total points
ID: 17770769
Hi rcouret,

I won't disagree with you about the navigation within the Crystal Viewer - it *is* a PITA to page forward and back but this sounds like a case where you can design an alternative that will work better.

First, consider if you really need a 1000 page report.  I hate to generalize, but is any user really going to be able to make any effective use of a report this size?  As a general consideration, what I would probably do is to build some parameters into your report to filter the data down to specifically what each user wants to see.  You can then build a page in your .net application that will present the parameters to the user (this could be a series of dropdowns and textboxes or maybe just a few radio buttons for common options, etc.).  Your application can then pass the parameters to Crystal and return a subset of your data that better matches what the user really needs.

Second, consider the information presented in the report.  Are you showing a lot of information that isn't always needed but you have it there just in case?  This is a prime candidate for on-demand subreports which allow you to hide details behind links to subreports.  You can often show a much more concise report with high level details and have the more granular data hidden in a subreport that will only execute when (if) the user clicks the link to indicate they want to see it.

Finally, after implementing one or both of these suggestions if you still have too large a report then exporting to another format may be a viable option.  I prefer PDF myself because of the consistent presentation and the excellent search capabilities of the latest version of Acrobat Reader.  When I need to deliver a long report I always export it to PDF for exactly this reason.

This is general information - if you need more specific help with any/all of these suggestions just let me know.

frodoman
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 17771076
This problem (and I agree it's a glaring problem in prior versions) is fixed in Version XI.  Both Crystal XI as well as viewer applications built with Crystal XI runtime components respond to Page-Up & Page-Down as expected.

- Ido
0
 

Author Comment

by:rcouret
ID: 17773645
Awwww $315 upgrade to be able to use the keyboard - It will be difficult to convince my boss of that one.  

Is there a .pdf report generator that can integrate with .NET?  What is it called?  That sounds like a very viable option since we usually export the crystal reports to .pdf anyways for storing/printing purposes.
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 17773846
You can upgrade and even buy the full version for less than that.  See: http://kenhamady.com/cru/archives/37

I think there are a couple of other good reasons to stick to Crystal but it doesn't sound like you are in the mood.  

Best wishes.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

749 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