Print Page | Close Window

parameter change dynamically??

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3981
Printed Date: 29 Apr 2024 at 2:28am


Topic: parameter change dynamically??
Posted By: great_mamun
Subject: parameter change dynamically??
Date 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


Replies:
Posted By: BrianBischof
Date 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 http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Amazon.com or reading the http://members.crystalreportsbook.com - 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>

Posted By: great_mamun
Date Posted: 19 Aug 2008 at 4:32am
Dear member_profile.asp?PF=4&FID=10 - BrianBischof
Thank you very much for your help.
My problem was solved.

Best regards,
Abdullah Al Mamun


-------------
Best Regards,
Abdullah Al Mamun


Print Page | Close Window