Running Report off Form Filter

[woodyinoz]

I have filtered information in a form and now want to preview a report showing only the filtered information.

Any ideas on this one?

I'd quickly like to thank everyone whose helped me so far,

Thanks,

Woody.

 

[Langley]

The best way to do this is by mirroring your filter criteria to the query that generates the result table for the report. Then open the report. If you've hidden the toolbar, you may want unhide it so the user can then print the report.

Mac

 

[ros]

Another simple way is to apply the exact same filter to the report. eg.

var
r report
endvar
;assuming you've already set up filter in criteria

; load report hidden in design mode
r.load(-reportname-, winstylehidden)
; note: report must be .rsl not delivered

r. -tableframename- .setgenfilter(criteria)
; apply the filter to tableframe object (or other object)

r.run()
r.bringtotop()

hth,
Richie

 

[ros]

I just noticed from an earlier post of yours that you probably don't have the filter variable. In this case use getgenfilter in the form.

var
r report
criteria dynarray[] anytype
endvar

; capture the filter criteria
-tableframeobject-.getgenfilter(criteria)
; the rest is the same
r.load(-reportname-, winstylehidden)
r. -tableframename- .setgenfilter(criteria)
r.run()
r.bringtotop()

hth,
Richie