Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error while previewing the report

Status
Not open for further replies.

swetham

Programmer
May 5, 2010
257
DE
I have been using crystal reports 2008. when i create parameter fields and write a selection formula and preview the report, "crw32.exe has encountered a problem and needs to close. we are sorry for the inconvenience" error is coming.
 
Try doing the process one stage at a time. Isolate the problem.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
sorry I didnt get u clearly. If you dont mind,Can you elaborate it?
 
One parameter at a time. Then, if no errors, the selection formula.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
If i create one parameter and mention the condition, then also same error is coming.
 
What conditions? Post the test and it might make sense

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
I have 2 parametere startdate and enddate, in selection record i wrote a formula

Record_date between startdate and enddate.


When i click on prievew it is showing the above error and getting closed
 
I don't have CR 2008, but in earlier versions you cannot use between-and in the record selection formula--but then you would get an error. Are you using a command?

Otherwise, you would use:

{table.date} >= {?StartDate} and
{table.date} <= {?EndDate}

-LB

 
I used that condition previously, then also same error. I am not using command. I uninstalled and again installed it then also same error
 
Does the report run without error without the parameters?

-LB
 
If parameters are not all declared in the report then everything is working perfect
 
Then you should re-check the set up of the parameters. Then add them into the selection formula one at a time to see if you get any errors.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top