Joined: 23 Nov 2007
Online Status: Offline
Posts: 10
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
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
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
IP Logged
