I am creating a report i.e. group above
Table structure and data like
ID CATEGORY1 CATEGORY2 COST
1 LAND ABC LAND 10000
2 LAND XYZ LAND 20000
3 LAND CED LAD 30000
4 VEHICLE TOYATA 800000
5 VEHICLE MAZDA 10000000
I am using two parameter in where clause based on category1,category2
i.e. p_cat1,p_cat2
Report should be like
Category1 : LAND
ID CATEGORY2 COST
1 ABC LAND 10000
2 XYZ LAND 20000
3 CED LAD 30000
Category1 : VEHICLE
ID CATEGORY2 COST
4 TOYATA 800000
5 MAZDA 10000000
TASK: When I use value from cat1 there must be values of cat2 according to cat1 and ID of cat1
Problem : Table structure can not be changed
there is no foreign key relation b/w cat1 and cat2
thanks
Nigar
Dynamic values report
-
- Posts: 3
- Joined: Fri Apr 14, 2006 10:26 am
- Location: Pakistan
From your post what I am trying to understand is that you want to have a self join but still a confusion is that in one category you have LAND and in other VERHICLES but what would be the key to join them? So first need we need to identify the key to build relation. Secondly please check lexical references if of any help and sample is already available in the forum here. thanks
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
I am unable to understand yours requiremnt or problem.... please me in brief, according to me there is no problem in yours requiremnt because you need to run report which based on 2 parameter which are based on each other.....???
takre care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
takre care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Who is online
Users browsing this forum: No registered users and 8 guests