Crystal Reports pass a value to a crytsal report

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: pass a value to a crytsal report

Author	Message
chris64 Newbie Joined: 19 Mar 2014 Online Status: Offline Posts: 13	Topic: pass a value to a crytsal report Posted: 13 Jun 2014 at 1:21am
	Hi, I have a data field in my report that is sometimes empty. I want to put a value in this field if it is empty. However I cannot hardcode it in as it will vary for each client therefore each time I run the report. How can I pass the value into the report at runtime. Thanks, Chris
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 24 Jun 2014 at 9:20am
	I would use a parameter. If you're running the report through an application you've created, you could set the value of the parameter are run time. In the report, you would create a formula that looks something like this: if IsNull({MyTable.MyField}) the {?MyParameter} else {MyTable.MyField} -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	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.016 seconds.