Solved

Crystal Report Export Problem

Posted on 2006-11-15
9
948 Views
Last Modified: 2012-05-05
Dear Sir,
    I am using .net crystal reports on my machine.  i developed two reports.  the two reports are displaying correctly.  But in one report i am able to export the report correctly to the desired format.  but in the second report i am getting the error "input string not in correct format".  but the same code i used for the both reports.i.e., i copied the first reports code to the second reports code.

    The first report is in one page and the second report is in the dialog window.  and i passed all the parameter values and connection string values to the report along with the selection formula.

How can i over come this problem.
0
Comment
Question by:seshu123
[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
  • 4
  • 2
9 Comments
 
LVL 4

Author Comment

by:seshu123
ID: 17946027
Actually the Error is Like this

Server Error in '/HATWebSite' Application.
--------------------------------------------------------------------------------

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2753507
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +102
   System.Int32.Parse(String s) +20
   CrystalDecisions.Web.CrystalReportViewer.OnExport() +404
   CrystalDecisions.Web.CrystalReportViewer.RaisePostBackEvent(String eventArgument) +99
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +242
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3834

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
0
 
LVL 1

Expert Comment

by:Shay79
ID: 17947500
Hi

Have you tried verifying the database on the report thats not exporting?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 17949358
What code are you using to export the reports?

If you are passing date parameters they need to be DATE type or DATETIME type.  Crystal will not convert them for you.

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 4

Author Comment

by:seshu123
ID: 17962692
Thanks Sir,
        i found the solution and i corrected my reports coding.


Thanks Once again for your valuable time
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 17965889
What was the error?

mlmcc
0
 
LVL 4

Accepted Solution

by:
seshu123 earned 0 total points
ID: 17977165
actually,
   I am calling the report in one window. But in asp.net i made a trick so that the window was a modal window.  for this i am calling the report window in another window.  so that  the database and the server information are missing.  after that i put some buttons on the top and i removed the crystal reports export and print dialog buttons.  


Then it was worked.


Thanks you sirs,
  thanks for your valuable time.
0
 
LVL 4

Author Comment

by:seshu123
ID: 17985173
ok Pls. Close the question.


Thanks & regards,
Seshu123
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

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. …
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 …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
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…

691 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