Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help with parameter field Post Reply Post New Topic
Author Message
ez.river
Newbie
Newbie


Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 2
Quote ez.river Replybullet Topic: Help with parameter field
    Posted: 26 Sep 2008 at 4:08pm
Hi there!
I've created a simple report that has 3 parameter fields:
 
1. Start Time
2. End Time
3. Login Name
 
The formula looks like this:
 
{User.Login Name} = {?username_prompt} and
{User.Last Login On} in {?Start Time} to {?End Time}
 
I am able to enter a single Login Name or multiple Login Names fine, but I need to be able to run the report to return ALL users. If I leave the Login Name field blank, nothing is returned. I've tried using % or *. Nothing seems to work. Does someone have a simple solution to my problem?
 
Thanks
e
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 29 Sep 2008 at 7:21am
Hi,
 
Check for the User Loign name condition using the Like operator as
{User.Login Name} Like {?username_prompt}
 
cheers
Rahul


Edited by rahulwalawalkar - 29 Sep 2008 at 7:21am
IP IP Logged
ez.river
Newbie
Newbie


Joined: 26 Sep 2008
Location: United States
Online Status: Offline
Posts: 2
Quote ez.river Replybullet Posted: 29 Sep 2008 at 12:59pm
rahulwalawalkar-

That did it! Thanks for the great solution!

e
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.031 seconds.