Crystal Reports Fatal error

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Fatal error

Author	Message
adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Topic: Fatal error Posted: 22 Aug 2010 at 11:24pm
	When trying to run my report, the following error appears: 'REF' report prompt not found. How can i fix this? when running the preview in crystal reports, the report runs as expected!
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 23 Aug 2010 at 3:40am
	if you have a prompt called REF try renaming it. This will either solve the problem, or perhaps lead to another issue, which may be the real issue. HTH
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 23 Aug 2010 at 6:18am
	Thanks for your response, But no joy!! tried changing it to NUM but same error displays!
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 23 Aug 2010 at 8:06am
	I doubt that it would matter, but I would try something silly like 'abc' as ref or num may be used internally in the report.
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 23 Aug 2010 at 10:18pm
	Unfortunatley no matter what i name it! the same error appears.
	IP Logged

Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 23 Aug 2010 at 11:29pm
	did you use Stored Procedure for your report? if "yes" it might be from the SP and need to pass to CR as well. just in-case.
	Emir W
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 24 Aug 2010 at 3:48am
	I've created it from scratch, how do i see or how do i pass it to CR
	IP Logged

Emir_W Senior Member Joined: 25 Apr 2010 Online Status: Offline Posts: 228	Posted: 24 Aug 2010 at 11:11am
	if your report using Stored Procedure (SP) where there are some parameters (or only one param) in the SP then it will prompt you whenever you run the report even you didn't put any param inside CR. other word: param(s) from SP will automatically included in CR. but if there is no param(s) in your SP then you can consider what lockwelle suggest. in this case, please check any variables that using a 'reserve words'. hope it help.
	Emir W
	IP Logged

adders Groupie Joined: 09 Aug 2010 Online Status: Offline Posts: 53	Posted: 24 Aug 2010 at 10:13pm
	Everything looks as it should, I've tried abcd and ref1 but no luck what so ever!
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.