?
Solved

Problem when exporting to excel spreadsheet

Posted on 2003-03-28
18
Medium Priority
?
687 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
[X]
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
  • 8
  • 4
  • 2
  • +1
18 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

801 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