Recent content by oh704

Hi All, I've set up a crystal report template (version 12) to create custom letter for each record in an access table. in the pass there werent that many records to handle so i just manually select the record in crystal report's report filter and print to pdf. But now there's a big batch of...

btw working with vs2008 thanks -HK

Hi, I have a program that have several crystal reports as templates for incoming data. These reports are all stored in the "Reports" sub-folder in the application folder. Before, I created a deployment project that will install the app files, all necessary dependency files, including...

Hi All, I'm sorta newbie on SQL, and i'm trying to write a sql that will pull all records where it's total amount if greater than an amount. ie. Name $ John 2 John 3 John 4 John 5 Mike 1 Mike 2 Mike 3 Kate 9 i want to pull all the records for each person with an aggregate amount of greater...

Hi All, I've a datagridview that's populated by a datatable from a SQL. there's a column named "VOTE" in which there can only be 2 string values: "ACCEPT", "REJECT". How do I set up a combobox on this "Vote" column and only have these two values as choose? and have a warning for any other...

Hi All, I have a similar problem to GreenLil with my data. GreenLil, please excuse me for copying your sample data :). Label ID First Name Last Name 10C000136 Bob Smith 10C000136 Jane Smith 10C000136 John Smith 10C000136 Bob...

thanks for the information lbass. i am indeed using a command as a datasource for the report. i did not know that it will lead to disabling SQL expressions fields. the syntax from your suggestions also works wonderfully as a formula field.

HI All, for some odd reason that i cannot figure out, my sql expression field options are disabled on my crystal report 12 application. Does anyone know the cause of this? i can create new fields fine with all the other categories. and just so happens, creating a sql expression field is the...