Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problem when exporting to excel spreadsheet

Posted on 2003-03-28
18
Medium Priority
?
691 Views
Last Modified: 2007-12-19
We're publishing Crystal Reports 8.0 via a .Net frontend (not CR.NET). The reports are developed in CR 8.5.   When a report is exported to Excel via the website, it seems that all the cells are merged into one. You can still edit each individual cell as if they were separate but if you try and sort them it throws the following message:

"Microsoft Excel found data next to your selection. Since you have not selected this data, it will not be sorted. What do you want to do?

[radio button] Expand Selection
[radio button] Continue with current selection

Sort [button] Cancel [button]"

Then regardless of which option is chosen, an excel notice pops up:
"The operation requires the merged cells to be identically sized."

Even if I change the format to number (it is set as General)and try and sort, i get the notice without the prior option.  

Is it something within the Crystal Report that needs to be change?

thanks for the help.
Matt

0
Comment
Question by:mnye
  • 8
  • 4
  • 2
  • +1
15 Comments
 
LVL 7

Author Comment

by:mnye
ID: 8226783
CORRECTION:

Developed in CR 8.5
Pushed by ASP.Net with CR.Net Engine
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8228934
Try changing the export type to Excel Extended rather than just Excel.

mlmcc
0
 
LVL 7

Author Comment

by:mnye
ID: 8239549
mlmcc,

i ssume you're refering to the OCX issue from CR 6 when exporting from a VB app which uses function PrintFileType ?

This is an ASP.Net app and Im exporting using function ExportFormatType.

Any other thoughts.  thanks for the responce.  Ill kick this question up to 50 points since it seems to be a bit harder than I had originally thought.

Late
Matt
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 8242061
Try using

ExportFormatType = Excel70Tabular

mlmcc
0
 
LVL 7

Author Comment

by:mnye
ID: 8257009
mlmcc

thanks, i havent gotten a chance to test it out yet but as soon as i do ill letcha know. i dont think Excel70Tabular is the right property but i do think that it has to do with the ExportFile Object.  thanks for the help.
0
 
LVL 7

Author Comment

by:mnye
ID: 8366756
mlmcc,
sorry i didnt relpy on this for a while. got side tracked on another project.  the ExportFile object doesnt seem to be working. i tried all the options i could find for it.  I think it may have to do with the development of hte report perhaps. im not sure. Unless you object, ill be requesting to have this question deleted.

Thanks for the help.
late
matt
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8370066
No problem.  I'll keep my eyes open for other answers.

mlmcc
0
 
LVL 7

Author Comment

by:mnye
ID: 8781237
btw, MLMCC, the only resolution I found was an upgrade to 9.0.  we are emplimenting Crystal Enterprise 9.0 currently and among the export options is "Excel (Data Only)" .  This works perfecting.  I still am suprised I was unable to find a resolution in 8.5.  Thanks for the help on this anyway.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8785535
The tabular was supposed to be essential data only.  Good luck with CR 9.

One word of warning, read the license agreement very carefully it has some huge snags in it.

mlmcc
0
 
LVL 7

Author Comment

by:mnye
ID: 8788918
Yeah the tabular didnt seem to work and i was confused by that as well.  Thats what made me think it wasnt a "data only" issue but I couldnt find any other reason. actually we're going to Crystal Enterprise 9.0 so that kinda resolves all sorts of problems.  We have 50 licenses and since Enterprise has about 10 of its own server components processing is lightening fast.  We're doing clustering and everything, im pretty excited, i think that classifies me as a dork but whatever.  Ill post some points for you on for the help on this question though. thanks again.

Late
Matt
0
 
LVL 7

Author Comment

by:mnye
ID: 8788989
please.

Thanks Pasha
0
 
LVL 7

Author Comment

by:mnye
ID: 8788990
please.

Thanks Pasha
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 8789004
PAQ'ed and points refunded
0
 
LVL 1

Expert Comment

by:SiddharthaCR
ID: 8982557
Mnye/Pasha,

A Question regarding the problem you faced for exporting.By using the data only option in CR 9.0 how are u able to sort the report in excel coz in my case the headers are also exported and those are repeated in the exported excel fille.Hence sorting makes the data go haywire.Please help.
0
 
LVL 1

Expert Comment

by:SiddharthaCR
ID: 8991448
PashaMod , Myne,Mlmcc

Very sorry for my intrusion. Actually I found out only recently ... how this forum works... earlier I wan't aware.
Regret the inconvinence.


0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline
Suggested Courses

572 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