mau108
October 5th, 2005, 02:03 PM
Hi,
I'm new here, and found this forum to be awesome. I'm knowledgable in programming (C and C++ mostly), I did VB a long time ago but that has nothing to do with the situation im in. Crystal Reports is a new software for me, and I have done alot with it in the few weeks I've had it.
I've found certain formulas to work, but I cant get this filtering stuff to work. Basically I am getting information from 1 table. Comments is a memo field and comments_id is a field labelling what type of comment it is.
So basically I want to pull into Crystal Reports Comments field based on the comments_id field. So I only want to pull Comments that have the comments_id field as 2.
I did not design this database, it was built in Access 97 and I have no control over it.
Please tell me this is possible. And also how to not duplicate everything for every comments, like we can have 2 comments with comment_id 2 and Crystal Reports will duplicate everything which looks really ugly.
Thanks
I'm new here, and found this forum to be awesome. I'm knowledgable in programming (C and C++ mostly), I did VB a long time ago but that has nothing to do with the situation im in. Crystal Reports is a new software for me, and I have done alot with it in the few weeks I've had it.
I've found certain formulas to work, but I cant get this filtering stuff to work. Basically I am getting information from 1 table. Comments is a memo field and comments_id is a field labelling what type of comment it is.
So basically I want to pull into Crystal Reports Comments field based on the comments_id field. So I only want to pull Comments that have the comments_id field as 2.
I did not design this database, it was built in Access 97 and I have no control over it.
Please tell me this is possible. And also how to not duplicate everything for every comments, like we can have 2 comments with comment_id 2 and Crystal Reports will duplicate everything which looks really ugly.
Thanks