Search results for query: *

I get an error saying a Boolean is required here.

I was able to put If {suffix} = '000' then {due date} in a sub report to pull the correct date, however it doesn't look like I can group off of that. Any ideas on how to do that / if possible?

lbass: unfortunately that only suppresses the group name (that's all that is in the group header), but still prints group 2 (job) and details (all jobs and all po's). I'm going to start from scratch on this one and see if I did something goofy.

Thanks for the replies. I tried using that formula and I get lots of blanks. I assume because the first record it comes across might not be the 000. If the top record is the 000 I get the due date, if its not I get a blank. Yes I want to show all jobs and all po's (order doesn't matter). Only...

Completely stumped on this one. Table 1 layout: PO Job Suffix 123 123456 001 456 123456 000 987 123456 010 Table 2 layout: Job Suffix Due Date 123456 001 12/12/2018 123456 000 12/10/2018 123456 010 11/11/2018 I need to group by job due date where the suffix...

Pervasive Version 11.31 Working on a crystal report and I need to link two tables, however the data types on one of the fields is different. I think the easiest way for me to deal with this is to create a new view and change the data type. For simplicity we'll say: Table A, field 1 is integer...

Pervasive. I believe the same commands/structure as MS SQL

hilfy - Thanks, but I didnt see any helpful information there. Kray - It made perfect sense in my head ;-) Yes you are correct, I was talking about the links tab, not manually creating the join in the command. I've tried in the command and had no luck at this point. Here is an example of what...

Ive got 3 tables I need in this report and one of the fields I need to link in 2 of the tables are different table1 = 001 table2 = 0010 I have tried creating a command that uses RIGHT('0000'+ISNULL(FIELDNAME,''),4) to add a leading 0 to table1. But when I try to link only inner and left...