Hi,
I have an ID field wherein a user can enter only 1 value at a time from the html page and this ID field is being passed as an input to my next sql query.
This ID may be tied to a column named typeid and say if I enter the ID as 1, this ID named 1 can be tied to a typeid's of 3 different types having the values such as ABC,XYZ,PQR.Next if the ID 2 is entered,then it might be tied to a typeid's of 5 different types namely PQR,MNO,ZZZ,AAA,BBB.
In another column, I have mentioned the type id's along with their values namely :
ABC 1
AAA 2
BBB 3
MNO 4
PQR 5
XYZ 6
ZZZ 7

Say if I enter ID as 2,then as it is tied up to a type id's having the values such as PQR,MNO,ZZZ,AAA,BBB ,....I need the compound report for each typeid and to do this,I do not want to use the same query in my fex file 5 times for each type id's[Open,noclose and close]and also I want the report to get generated based on the order of their values i.e.,here AAA[having value as 1],BBB[value is 2],MNO,PQR,ZZZ .
Can anyone tell me how can we do this using looping technique.

Any sample example/hint is greatly appreciated!

Thanks!

This message has been edited. Last edited by: Tamra,

You can search this forum for compound coordinate keywords.

Thanks,
Ram

Hi,

Thank you Ram.I will do that.

Regards,
IP

Hi,

Ram - I searched for the same but couldn't find any examples on it.

Also can anyone please provide any sample looping technique using the CAR file as an example for the above asked technique.

Thanks a lot in advance!

Thanks!

Hi,

Any hints/thoughts on the same.

Thanks,
IP

Hi info4pal,

Check the below link. You will get the piece of code to solve your purpose:
http://pravinsinghwebfocus.blo...cus-code-in-our.html

Please let me know if it doesn't. I'll try to help you out.

Thanks,
Pravin Singh