mallow
asked on
Crystal Report
hi there,
i'm using crystal report 5.0
i hava a table ....
CUSTOMER DATE STATUS
AAA 9/12/97 ORDINARY
AAA 12/12/97 GOLD
XXX 8/8/97 RED
YYY 12/12/97 BLUE
BBB 5/12/97 ORDINARY
CCC 12/12/97 ORDINARY
BBB 6/12/97 GOLD
CCC 12/12/98 GOLD
I need to show on my report only records with gold and ordinary status,
and report on the customers, first column of my report lists all the
customers, no repeating values, second column list the date the customer turned ordinary, and third date the customer turned gold so for my report i should have something like this:
ORDINARY GOLD
CUSTOMER DATE DATE
__________________________
AAA 9/12/97 12/12/97
BBB 5/12/97 6/12/97
CCC 12/12/97 12/12/98
please help, any suggestions will be appreciated. thanks.
i'm using crystal report 5.0
i hava a table ....
CUSTOMER DATE STATUS
AAA 9/12/97 ORDINARY
AAA 12/12/97 GOLD
XXX 8/8/97 RED
YYY 12/12/97 BLUE
BBB 5/12/97 ORDINARY
CCC 12/12/97 ORDINARY
BBB 6/12/97 GOLD
CCC 12/12/98 GOLD
I need to show on my report only records with gold and ordinary status,
and report on the customers, first column of my report lists all the
customers, no repeating values, second column list the date the customer turned ordinary, and third date the customer turned gold so for my report i should have something like this:
ORDINARY GOLD
CUSTOMER DATE DATE
__________________________
AAA 9/12/97 12/12/97
BBB 5/12/97 6/12/97
CCC 12/12/97 12/12/98
please help, any suggestions will be appreciated. thanks.
ASKER
can you please send the codes for the stored procedure to carol@the.net.ph please? thanks :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You never said whether that worked for you, or not.
How'd it go?
How'd it go?
ASKER
hi there percosolator, i have to try the codes, and is this the correct syntax for stored procedure in informix because i'm getting a syntax error for my stored procedures, if you know that syntax, please tell me, i have to try these codes on monday, thanks :) i'll tell you.
ooh.
sorry. i thought that you were using Microsoft SQL Server.
hmmm.
the syntax is probably close. i don't know if Informix is ANSI-SQL compiant. i _think_ that SQL server is....
the syntax might be a little off for Informix, but the logic is sound.
Doug
sorry. i thought that you were using Microsoft SQL Server.
hmmm.
the syntax is probably close. i don't know if Informix is ANSI-SQL compiant. i _think_ that SQL server is....
the syntax might be a little off for Informix, but the logic is sound.
Doug
Mucked-about with a cross-tab report for a while... That's not your solution as to it deals with summary information.
What you need to do is transform your data from the one-dimensional view that it's currently in, to a 2d one. This can be done with a series of queries to which you link your report.
If you would like, I can send you SQL code for a SQL stored procedure, or the Access queries to do this transformation. Or Post it, if you'd prefer.