Hi Pooja,Back in CR 8.5, it was the RDC COm SDK (CRAXDRT.dll) and with CR for VS 2010 it is .NET SDK which are two complete different SDKs and could not be compared.However, the .NET SDK should export the report same as it is exported through CR designer.Could you export the report in a newer designer possibly CR 2008 or CR 2011/2013 and compare the exported output with your .NET SDK export?You could get the trial free download for CR desiner here. -trials.html- BhushanSenior EngineerSAP Active Global SupportFollow us on TwitterGot Enhancement ideas? Try the SAP Idea Place Getting started and moving ahead with Crystal Reports .NET applications.\",\"author\":\"username\":\"bhushan.hyalij\",\"displayName\":\"Bhushan Hyalij\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":11179451,\"posted\":1409823043000,\"votes\":0,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]},\"body\":\"Hi Pooja,In CR 8.5 there were a lot of issues exporting to Excel so we re-wrote the export dll's. There was a Legacy Export Compatibility version of the Export dll but we stopped making it available because it is as is, no fixes can be done to it and it does not work in any of our SDK's. It was only available for use in CR Designer.If you search you will find a document on how to format reports for exporting to Excel.Only option now is to update your reports and use the available formats.Don\",\"author\":\"username\":\"don.williams\",\"displayName\":\"Don Williams\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":11180756,\"posted\":1409842929000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"The doc Don refers to:How to WYSIWYG SAP Crystal Reports Export to XLS- Ludek Senior Support Engineer AGS Product Support, Global Support Center Canada Follow us on Twitter \",\"author\":\"username\":\"ludek.uher\",\"displayName\":\"Ludek Uher\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":11181162,\"posted\":1409852247000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/11178774/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/11178774/answers.rss', answersAndComments: '/feed/11178774/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true }) })(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Former Member Sep 04, 2014 at 07:26 AM Crystal reports 13.5 : Export to excel formatting 379 Views Follow RSS Feed Hi. We are developing web application using VS 2010. We are using crystal reports 13. Initially we had VB6 application which used crystal reports 8.5. The format for excel report generated by crystal report 8.5 and crystal report 13.5 is different. We are using the export option in crystal report viewer for both reports. Is there any way in which we could make changes to crystal reports 13.5 to achieve similar excel formatting as crystal reports 8.5.
Crystal Report 8.5 For Visual Basic 6.0 Free Download
Download: https://cinurl.com/2vFkcv
Without "development capability", there is probably not much you can do. Even if we'd assume that the upgrade as described below goes without a problem. \\nSo. The easiest way to proceed:\\n\\n1) Obtain CR XI R2A (11.5) by contacting sales; 866-681-3435\\n2) Install CRXI R2A\\n3) Open your VB 6 project\\n4) Delete the CR viewer from the project\\n5) Remove references to craxdrt.dll and crviewer.dll of version 8.5 from your project\\n6) Add the references to craxdrt.dll and crviewer.dll version 11.5 to your project\\n7) Add the CR viewer to your project\\n8) Save\\n9) Compile\\n10) Deploy the project and the CR runtime using the CR runtime MSM for RDC (you will need to cerate a setup project using InstallShield or the like (The VB deployment and packaging wizard will not work for you with CR XI R2A).\\n\\nThe above is the simplest way to upgrade to CR XI R2A. I also realize that this is not trivial if you do not have programming experience. It is the my best recollection on how we used to do this (CR XI being out of support for over a year now, I have have not had VB 6 on any image for a long time now). And finally, all of the above may be for naught, if you run into any glitch as this will require even more expertise to solve. \\n\\nOh and you can not go to the currently supported CR 2008 or CR 2011 or Crystal Reports for Visual Studio 2010 as these do not have the RDC anymore.\\n\\nNot a shred of good news in this I know. But with CR 8.5 your organization essentially stayed in the stone ages of the computer industry ?.\\n\\n\\n- Ludek\",\"author\":\"username\":\"ludek.uher\",\"displayName\":\"Ludek Uher\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":9373583,\"creationDate\":1340375094000,\"activeRevisionId\":10190979,\"lastActivity\":1340375094000,\"parentId\":9373004,\"originalParentId\":9371562,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 9371562, plug: "migrating-crystal-85-reports-to-a-64-bit-environme", votes: 0, questionTitle: "Migrating Crystal 8.5 reports to a 64 bit environment", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: true , childToViewInfo: id: "" , comments: JSON.parse("\"9371571\":\"rootParentId\":9371571,\"commentsCount\":2,\"comments\":[\"body\":\"Without "development capability", there is probably not much you can do. Even if we'd assume that the upgrade as described below goes without a problem. \\nSo. The easiest way to proceed:\\n\\n1) Obtain CR XI R2A (11.5) by contacting sales; 866-681-3435\\n2) Install CRXI R2A\\n3) Open your VB 6 project\\n4) Delete the CR viewer from the project\\n5) Remove references to craxdrt.dll and crviewer.dll of version 8.5 from your project\\n6) Add the references to craxdrt.dll and crviewer.dll version 11.5 to your project\\n7) Add the CR viewer to your project\\n8) Save\\n9) Compile\\n10) Deploy the project and the CR runtime using the CR runtime MSM for RDC (you will need to cerate a setup project using InstallShield or the like (The VB deployment and packaging wizard will not work for you with CR XI R2A).\\n\\nThe above is the simplest way to upgrade to CR XI R2A. I also realize that this is not trivial if you do not have programming experience. It is the my best recollection on how we used to do this (CR XI being out of support for over a year now, I have have not had VB 6 on any image for a long time now). And finally, all of the above may be for naught, if you run into any glitch as this will require even more expertise to solve. \\n\\nOh and you can not go to the currently supported CR 2008 or CR 2011 or Crystal Reports for Visual Studio 2010 as these do not have the RDC anymore.\\n\\nNot a shred of good news in this I know. But with CR 8.5 your organization essentially stayed in the stone ages of the computer industry ?.\\n\\n\\n- Ludek\",\"author\":\"username\":\"ludek.uher\",\"displayName\":\"Ludek Uher\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false,\"id\":9373583,\"creationDate\":1340375094000,\"activeRevisionId\":10190979,\"lastActivity\":1340375094000,\"parentId\":9373004,\"originalParentId\":9371562,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"liked\":false,\"moderatorComment\":false]"), answerPager: answersCount: 1, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Hello KarenYou will not like the answer. Ready?You do not mention what OS you are using, but I assume WIN 2003 or WIn 2008(?). CR 8.5 came out, oh - 5 years before WIN 2003. E.g.; not supported. No way I can see this ever working. There is more bad news for you coming though.Say you decide to upgrade CR, the app, the whole thing. Since your app was built in VB 6, it is using either the Report Designer Component SDK, or the OCX SDK, or the Print Engine SDK. All of these have been retired. OCX in CR 9, Report Designer Component in CR 11.5 and Print Engine SDK in version 10. Of all of those, only CR 11.5 would work on a \\\"modern\\\" OS (e.g.; WIN 2003, Win 2008).Your options; Upgrade to CR 2008 and use VS .NET 2008. Port (e.g.; rewrite) the app to use the CR assemblies for .NET.Upgrade to CR 2011, download Crystal Reports for Visual Studio 2010 and use it with VS2010. Port (e.g.; rewrite) the app to use the CR assemblies for .NET.More info:Crystal Reports Legacy SDKs Upgrade OptionsReport Designer Component - Past, Present & FutureRDC statement of direction- LudekFollow us on TwitterGot Enhancement ideas? Try the SAP Idea Place Share Your Knowledge in SCN Topic Spaces\",\"author\":\"username\":\"ludek.uher\",\"displayName\":\"Ludek Uher\",\"groupIcons\":[\"name\":\"moderator\",\"title\":\"This user is an SAP Moderator\",\"priority\":20,\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":9371571,\"posted\":1340313569000,\"votes\":2,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/9371562/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/9371562/answers.rss', answersAndComments: '/feed/9371562/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up Search Questions and Answers 0 Former Member Jun 21, 2012 at 08:47 PM Migrating Crystal 8.5 reports to a 64 bit environment 676 Views Follow RSS Feed Hi, 2ff7e9595c
Comments