Print Page | Close Window

Parameter Passing

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=478
Printed Date: 16 May 2024 at 8:36pm


Topic: Parameter Passing
Posted By: sani723
Subject: Parameter Passing
Date Posted: 06 Apr 2007 at 10:47pm
i  have problem regarding parameters. while i do like this crv.SelectionFormula = "{tbale1.name} = " + textbox1.text then it works fine but i need to grab more columns based on user selection from CheckBox list.
i used this. crv.SelectionFormula = "{tbale1.name,tbale1.class,tbale1.section,tbale1.roll,tbale1.marks}
 
then it gives error. This field name is not known.  how can i resolved this issue.


-------------
peace


Replies:
Posted By: BrianBischof
Date Posted: 06 Apr 2007 at 11:33pm
I would separate each table into its own condition and joing them with boolean ORs.
crv.SelectionFormula = "{tbale1.name} = " + textbox1.text + " OR {tbale2.name} = " + textbox2.text + " OR {tbale3.name} = " + textbox3.text


-------------
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: sani723
Date Posted: 07 Apr 2007 at 3:36am
thanks for the reply. but dear it did not work either, actually what i want to do basically dynamically create the columns. like i already told that my tbale has 30 columns and i want ot show only those that are selected by the user from the checkboxlist control. any help will be appreciated

-------------
peace


Print Page | Close Window