Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: Select Expert help Post Reply Post New Topic
Author Message
itochu27
Newbie
Newbie


Joined: 22 May 2007
Location: Puerto Rico
Online Status: Offline
Posts: 1
Quote itochu27 Replybullet Topic: Select Expert help
    Posted: 22 May 2007 at 4:06am
Hi, Im totally new to crystal reports and I wanna know if ts possible to use visual basic variables in the select expert of CR.

I have a public variable .Public globalSocialSec As String. in a Module of my visual b project.

As my formula i have this: {Students.SegSoc} = "globalSocSec.text"

But this obviously is not comparing the globalSocSec variable contents with the data in students table. How can I solve this? is there an expression to pick up the contents of my VBasic project variable?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 22 May 2007 at 10:34am
No, you can't pick up variables in a VB project. You can insert the value of a variable into a formula/parameter prior to the report running. For example, to update a formula you would use the following code:
myReport.DataDefinition.FormulaFields("formulaname")="'" & globalSocSec.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
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.