Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: pass a value to a crytsal report Post Reply Post New Topic
Author Message
chris64
Newbie
Newbie


Joined: 19 Mar 2014
Online Status: Offline
Posts: 13
Quote chris64 Replybullet 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 IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP 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.030 seconds.