Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: parameter change dynamically?? Post Reply Post New Topic
Author Message
great_mamun
Newbie
Newbie
Avatar

Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
Quote great_mamun Replybullet Topic: parameter change dynamically??
    Posted: 14 Aug 2008 at 4:23am
Dear All,
I am using two parameter named s1 and s2  for selecting record.
using selection Expert I set id (filed name) is equal to {?s1}.
but second parameter usertype is equal to {?s2}
but the problem is there are 3 types of user such as admin, staff, user.

but from the .net User Interface, input is 2 type, either admin or user.
when admin then admin and staff will be selected, and if user then only user will be selected.

another is how do i use like operator in selection expert

I am using Visual Studio.net (C#) and Crystal Report.net 2005

Best Regards,
Abdullah Al Mamun
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 15 Aug 2008 at 12:06pm
A couple notes that should help you out re Crystal formulas:

You can select from a list of items using the IN operator:
{Customer.Country} IN ["England", "USA", "Canada"];

And if you want to use wildcards, you can use IS LIKE:
{Person.LastName} IS LIKE '*Jones*';

I have the full Crystal syntax documented with syntax examples in my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
great_mamun
Newbie
Newbie
Avatar

Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
Quote great_mamun Replybullet Posted: 19 Aug 2008 at 4:32am
Dear BrianBischof
Thank you very much for your help.
My problem was solved.

Best regards,
Abdullah Al Mamun
Best Regards,
Abdullah Al Mamun
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.020 seconds.