Wanted to Map to whole record of an entry in report, when clicked on it

[bharatmvs]

Hi,



I don't know if this question is weird, but some way to get this solved, would save a lot of my time.
I generate a report based on a query. it gives me results in report form. Since my table is really big, i dont want to view all the fields in the report. Hence i restrict it to certain important fields in the report.
However, when I wanted to provide an option, if a value is clicked in the report, it must give a either a popout with all the fields in the main table or generate another report with only details of that particular data.

for eg.

Full Table:
S.No Field 1 Field 2 Field 3 Field 4 Field 5
1 A1 A2 A3 A4 A5
2 B1 B2 B3 B4 B5


Report 1in Short)
S.NO Field 1 Field 2
1 A1 A2
2 B1 B2
Now when i click on A1, or A2, I must get pop out or a new report like

Report Popup:

S.No Field 1 Field 2 Field 3 Field 4 Field 5
1 A1 A2 A3 A4 A5


THank you,
Bharat

[NTC]

yes this sort of drill down is possible....the field control of the Short Report (not sure if this is actually a form object or report object) but you can have an OnClick event - and in that event open another report that has the full set of fields.... one must of course dynamically apply the unique key of the row that you are in so the new report has the correct data..... I would not attempt to dynamically modify 1 report; instead have 2 objects.