Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Parameter Passing Post Reply Post New Topic
Author Message
sani723
Newbie
Newbie
Avatar

Joined: 06 Apr 2007
Location: United Arab Emirates
Online Status: Offline
Posts: 3
Quote sani723 Replybullet Topic: Parameter Passing
    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
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
sani723
Newbie
Newbie
Avatar

Joined: 06 Apr 2007
Location: United Arab Emirates
Online Status: Offline
Posts: 3
Quote sani723 Replybullet 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
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.