Crystal Reports with 35 columns and 1000 rows (Need to Export to Excel and if need to be viewable and readable in infoview)

Posted on 2010-11-21
Last Modified: 2012-05-10
Hello Gurus,

Environment: Crystal Reports XIR2 / Oracle 10g / Business View Manager /Business objects XIR2/ Front End: .NET/ Visual studio 2005

I am using Business Views/Elements as source for my report.
Its a team member roster report, which contains 35 columns (out of this 20 are of string data type with textual information, rest of them are numeric fields)
Its a simple report to show list of team members information for the manager (without any grouping or formulas involved in the report)
The user needs a Excel down loadable format(since the reports contains 1000+ rows and 35 columns)

In Crystal Full Client, I changed the page setup to 11x17 by changing default printer which handles that size.(As I was not able to place all fields in A4 or Legal page)
I placed all the fields (set them to same height) in detail section with no spacing between the columns and able to build the report,
but in preview mode the report is not good for display. And most of the textual data fields are truncated as I am not enabling Can grow.
Currently I m using font size of '7'.

When I opened the report in Info view, I m able to see the report till A4 size and  rest of the columns are not displayed.

Needed Suggestions:
1. How to create report with 35 columns, need to be readable and viewable in Info view
2. Need to export to Excel
3. Is it possible to provide a link in the .NET portal (front end) to directly pop-up a message to OPEN or SAVE the report in Excel format, instead of displaying the report in the info view.
(In regular scenario, when they click the report link, it points to enterprise and opens the report in Info view)
4. Do we need to customize Info view page size to make it scrollable and view 11x17 page size report.

Thanks In Advance !!
Question by:RaoVP
  • 3
  • 2
  • 2
  • +2

Expert Comment

ID: 34184850
Hi, a report with 35 columns at 7' is just unreadable! :-)  

Are you are doing this to export the data to Excel?

If not, I recommend you analyze the data and create a more useful report.

Regarding the size custom page setup in infoview while scheduling.
LVL 100

Expert Comment

ID: 34185563
You might read through this document on how to create a report for export to excel

If you don't need to print the report, you could install a printer that has a large page size available


Author Comment

ID: 34191030
@mlmcc: thanks for the response, I already went through the document and came up with the approach.

Actual the problem is the user don't want to see the report in the portal, instead they need the link to directly to open or save in excel.

======== Please see the details explanation below ===================
Instead of opening a report in Infoview window is there a way to give directly to export to xls

I have .NET portal with list of report links, when the user clicks on any of the report, it then points to enterprise and passes (Manager_No) parameter to the .RPT file and then displays the report information in the Infoview window. This is regular functionality and its working fine.

For my new report which client needs direct link to open or save the report in Excel.

1. New link is created in .NET portal.
2. When user clicks the link instead of opening the report in Infoview window, I need to display link directly OPEN or SAVE the report in EXCEL.

Note: Since my report has 35 columns and 1000+ rows the users dont want to see in the portal window, and they need direct link to download to EXcel.

Please let me know its kind a urgent requirement, I came up with report but in Infoview I am able to show only columns till A4 size that to the truncated data since most of them are textual information and I used small column width with no can grow.
LVL 100

Expert Comment

ID: 34194074
I don't use Infoview so I don't know for sure.  I believe it is possible to have it export directly.  I know it would be from an application.

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 34194180
What's the URL structure to call the reports from within your portal?  There are generally two methods to doing so: 1)  Legacy URL reporting and 2)  opendocument.  Which method are you using?  


Author Comment

ID: 34194465
For sure we are using opendocument
 (because earlier we modified the opendocument jsp code to customize the hyperlink reports to open in new page)

Its  general question, because I came across in SAP forums, one way to change the default printer settings on BOE server, if so whether it will effect the existing view features of other A4 and Landscape reports?

Please let me know, because the now the user want to see the report in portal and also needs to download to Excel format for further analysis as its contains 1000+ rows and 35 columns

Thanks Again!!
LVL 34

Accepted Solution

James0628 earned 500 total points
ID: 34194573
If you need a really wide page, one option would be to use a printer driver that allows you to create a custom page size.  I've done this using a "virtual printer" that actually saves the output in a PDF file.  The one I'm currently using is "CutePDF Writer", but there are others.  I've used a couple of them and they work by emulating a PostScript printer, and then converting the PostScript output to a PDF file.  The PostScript printer driver that's used with CutePDF includes the option to create a custom page size (I would imagine that the other "virtual PDF printers" do too).

 If the custom page size is a more or less standard feature of PostScript printers, then you may also be able to use any PostScript printer driver to create a custom page size.  But assuming that you don't actually have a PostScript printer, using a "virtual PDF printer" seems like a better solution.


Author Closing Comment

ID: 34294385
As its not compatible to show full report in Infoview, the requirement as been shifted to NET side.
LVL 34

Expert Comment

ID: 34299062
It sounds like my suggestion didn't help, in which case you shouldn't have accepted it as the solution.  If none of the suggestions helped, you can ask to have the question deleted, or accept your own post as the solution.  Keep in mind that if you accept a solution, the question will remain here on EE and someone may come along some day with a similar problem and read this question and think that my suggestion was the solution to your problem.

 If you'd like to delete the question or change how you closed it, you can use the "Request Attention" link and ask to have it re-opened.


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

939 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

3 Experts available now in Live!

Get 1:1 Help Now