Formating Issues in Crystal

Hi All,

We have developed a crystal report with 4 sub-reports in it. The sub reports are conditionally suppresed based on the selection of parameters.

User requires the ouput to be perfect in excel( One cell for one column irrespective of characters in it) and also in perfect table look in infoview.

The formating I have made is working if there are no supress conditions, otherwise, the data is occupying 2 rows at a time or move out of the table limit. for any of the sub report.

any solutions for this????

Thanks

sirisha

SAP Managed Tags:
SAP Crystal Reports

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Has this been addressed in CR 2008? Track ID ADAPT00607513.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks to Ludek Uher for the reply!

My subreport has data so I don't want to suppress it. What I would like to do is get rid of the first row which is blank. Any ideas on how I can achieve this?

not quite sure how you do your sub report however for your requirement I would recommend

each sub report is in it's own section and you supress the section and not the sub report

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

The subreports are simpe, having just 10 to 15 fields placed and nothing else.

Also, the supress condition is mentioned in section expert----> supressed conditionally by a formula.

not able to understand why the suppress condition is influencing the export option.

Is there any why the output exports perfectl;y to excel in Crystal?

thanks

Sirisha

Crystal does not always export nicely to Excel. Having subreports is probably not helping.

I use export(data only), maintain column alighment, export page header and page footer and simplify page headers, but all my excel exports are usually simple data dumps so folks can play with sorting the data. I have found that all the columns must line up and all the fields/rows must be the same height with no extra space in the row or between columns (line your fields up border to border with no space between). If you export each report seperately, do they export cleanly?

Lines cause trouble. Fields set to grow to multiple lines leave space in the row under other fields in the row and cause trouble.

Maintain relative object position may help you. You will need to play with the different options til you find the combinations that works for you.

Hi Sirisha,

You have not mentioned what version of Crystal reports you are using at your end. When you use sub report in crystal and export to excel, it will export with a blank line. This is a known issue. Find below is a knowledge base article :

Symptom

When exporting a Crystal report that contains a subreport to Excel (Data Only) format, a blank line is inserted before and after the subreport.

Resolution

This is a known issue with Crystal Reports XI Release 2. This issue has been assigned Track ID ADAPT00607513.

====================

DISCLAIMER:

When a Track ID has been assigned to an issue, this indicates it has been reported to Business Objects for possible inclusion in future hot fixes or file updates. Refer to the list of Track IDs that accompanies a hot fix or file update to verify that a particular issue has been corrected.

====================

Thanks,

Sastry

Hi,

Yes, the export is perfectly fine when i remove the supress conditions. otherwise either in anyone of the reports(of 4) moves or distracts from the table to the right hand side or any records occupy more than 2 rows in excel.

Also as i have applied cell level formating to fit the borders and colors to get the table look in excel , because of this the output is not a perfect table in infoview.

Is there a way where the export is perfect in excel as well look good in infoview.

Thanks

Siri

I am using crystal 2008.

the problem is not with the blank rows , but the records are occupuing more than 2 rows in excel output or getting distrated from the table to the lefthand side when exported.

all the error are causing only when the supress conditions are on otherwise they are very well perfectly exporting to excel.

Also as the formating is done to make the export looks good, the output in infoview is not looking like a perfect table, it looks like a border for each cell instaed table.

Thanks

Siri

There is no easy way to do what you want to do. You may find that 2 reports, one for a report view and one for an export to excel works best for you.

Or you could try this:

I give my report two formats with a parameter to select either report or spreadsheet (my viewer will allow the user to change this value after running the report). I then set up two sets of output, one in report format and one in a spreadsheet format. For example two different detail lines, one formated the way I want to see it in the report and one formated the way I want to see it in an excel export. Ditto for headers/footers. I then set the different sections to print or hide according to the parameter value.

With regards to lines ending up 2 lines tall and fields moving, you must make sure each field is exactly the same height and the row is lined up perfectly with no extra space above or below the fields.The same is true for columns. The fields must be lined up with no extra space between the fields to avoid extra cells.

Turn off Can Grow on fields to be exported. All the data will export with out it, but Can Grow will mess with the line spacing.

I use export to excel (data only) with Column width based on objects in the detail line, Simplify page headers, and sometimes Maintain column alighment helps. Also Maintain relative object position.

Hi Debi,

Thanks for your response,

I followed exactly what you have mentioned and the export looks exactly as per client requirement one cell-one coloum/row data but with out supress conditions.

I have 4 subreports in my main report and the complete data is inside the 4 subreports. These subreports are being suppressed conditionally at run time by using parameters. when ever I use this runtime conditions(supress conditions) the export is getting distorted and table records are moving out of the table limit( toward the left hand side).

So the export is getting distoted at runtime(by placing the supress conditions) otherwise everything look good.

Not able to understand why the exporing is getting lost in run time.

Any way to resolve this.

Thanks and Regards

Sirisha

I am guessing then it is the fact the the subreports do not line up all the data the exactly the same. If you have checked maintain relative object position and it still moves data left, then I do not know what to suggest.

Sometimes I will put in empty text fields to fill columns and keep my data in the proper columns.

 col   col   col   col
field field field field
blank blank field field

Maybe this would help

Hi Debi,

Thanks for your reply,

I tried as you mentioned. But no use.

. Still the same when exported to excel.

Thanks and Regards

Sirisha

Then it has to be because it is subreports, and I do not know how to fix that short of exporting each one individually.

This ADAPT was rejected by R&D. The following note was added as an explanation:

we have a limitation in Excel Data Only exporter that it would introduce a blank row before and after a subreport object. Since the object isn't suppressed, it creates two blank lines. If you suppress the subreport object itself, you won't see the blank rows.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

Ask a Question

Top Q&A Solution Author

User

Count