Dynamic report using two tables [message #149024] |
Tue, 29 November 2005 13:51 |
siddu_jms
Messages: 1 Registered: November 2005
|
Junior Member |
|
|
The situation is something like this. We have 100 forms. And two tables for these.
The first table has two columns and it consists of the form_id and the second column consists of the fields present for each form id. Typically each form will have around 20-30 fields.
The second table consists of all the fields in all the forms as columns and the form_id column as well. When data is entered into each form, it is populated in the second table at the particuar fields using the mapping from the first table.
Now I have to generate a report such that, it takes form id as the parameter and then show just the fields used in that form in the report. That is : it should dynamically change the number of rows visible for the report.
Can anyone give me some suggesstions or sample code if any for this.....
thanks
s
The example of two tables are shown in the excel sheet
-
Attachment: Book1.xls
(Size: 14.50KB, Downloaded 1283 times)
[Updated on: Tue, 29 November 2005 13:53] Report message to a moderator
|
|
|
Re: Dynamic report using two tables [message #149057 is a reply to message #149024] |
Tue, 29 November 2005 21:20 |
ashok_it
Messages: 40 Registered: November 2005 Location: Singapore
|
Member |
|
|
hi,
some tips for you.
report
1 . create the dummy report from second table.
2. layout , remove all fileds, create field name it t1,t2,t3....
forms.
-- below 4 steps write down report button trigger
1. create dynamic record group,
2. retrive filed names from first table. form the query, papulate to group.
eg ;
select name t1,address t2,....
3. add this record group as a parameter in report.
4. call the report.
hope this tips will take you right direction
tks
ashok
|
|
|