satyakumar
Programmer
Hi Folks,
I have a weired scenario and the data is coming like this in Crystal....
Did Group by --- code 1234
Service Name code amount
OUT PAUL 1234 -390
IN PAUL 1234 390
-------------------------------------
Group by code 1212
Service Name code amount
OUT RAM 1212 -290
IN RAM 1212 290
IN RAM 1212 290
---------------------------------------
Group by code 2346
Service Name code amount
IN KYLE 2346 500
Basically in Crystal the users are asking me to supress the rows, which a customer has the IN and OUT on the code.
the first code 1234 should not show because it has IN and OUT..
Coming to second code 1212 which has IN and OUT and again it has IN, So we should show the one with IN record.
Coming to the third code 2346 which has only one row with IN so we have to disply the IN
so the Data finally should look like this in Crystal...
Group by code 1212
Service Name code amount
IN RAM 1212 290
---------------------------------------
Group by code 2346
Service Name code amount
IN KYLE 2346 500
Please help me guys in solving this.
Note: For understanding purpose i added the column 1 which is Service(IN and OUT), But from the Data base side we are not getting in the report.
Thanks.....
I have a weired scenario and the data is coming like this in Crystal....
Did Group by --- code 1234
Service Name code amount
OUT PAUL 1234 -390
IN PAUL 1234 390
-------------------------------------
Group by code 1212
Service Name code amount
OUT RAM 1212 -290
IN RAM 1212 290
IN RAM 1212 290
---------------------------------------
Group by code 2346
Service Name code amount
IN KYLE 2346 500
Basically in Crystal the users are asking me to supress the rows, which a customer has the IN and OUT on the code.
the first code 1234 should not show because it has IN and OUT..
Coming to second code 1212 which has IN and OUT and again it has IN, So we should show the one with IN record.
Coming to the third code 2346 which has only one row with IN so we have to disply the IN
so the Data finally should look like this in Crystal...
Group by code 1212
Service Name code amount
IN RAM 1212 290
---------------------------------------
Group by code 2346
Service Name code amount
IN KYLE 2346 500
Please help me guys in solving this.
Note: For understanding purpose i added the column 1 which is Service(IN and OUT), But from the Data base side we are not getting in the report.
Thanks.....