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
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
  • 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.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.

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 35

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 35

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

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