Discussion:
getting filters settings out of a datasouce
(too old to reply)
David Hills
2010-10-04 15:51:03 UTC
Permalink
Good Afternoon

what the best way to extract the filter settings being used by a report and
display them in the report header?

are there some simple example some where?

thanks

David
Axel Kühn
2010-10-04 21:36:03 UTC
Permalink
Hi David,

you can take a look at the customer report as an example (AR->Reports->Base
Data->Customer).

Also have a look at this blog post describing the things you have to do to
display the ranges/selections of the user in the report header.
http://gurudynamicsax.spaces.live.com/blog/cns!F6C101CEB694FB4E!191.entry

Hope this helps you.
--
Sincerely yours
Axel Kühn (visit my Dynamics AX blog at: http://blog.ak-home.net)
Post by David Hills
Good Afternoon
what the best way to extract the filter settings being used by a report and
display them in the report header?
are there some simple example some where?
thanks
David
David Hills
2010-10-05 08:02:03 UTC
Permalink
Thanks thta was a great help

I just added a page header section and override the executesection with

SysReportRun locSysReportRun;
;

locSysReportRun = element;
locSysReportRun.printRanges(true);

SysReportRun::executePrintRangeSection(element);


and the filter settings appear in the header.


The only slight problem is that they appear twice ie

Table Field Range
Test1 ItemId !APPLE*
Test1 ItemId !APPLE*
Test1 Ship date
"06/10/2010".."06/10/2010"
Test1 Ship date
"06/10/2010".."06/10/2010"

any idea why?

Thanks

David
Post by Axel Kühn
Hi David,
you can take a look at the customer report as an example (AR->Reports->Base
Data->Customer).
Also have a look at this blog post describing the things you have to do to
display the ranges/selections of the user in the report header.
http://gurudynamicsax.spaces.live.com/blog/cns!F6C101CEB694FB4E!191.entry
Hope this helps you.
--
Sincerely yours
Axel Kühn (visit my Dynamics AX blog at: http://blog.ak-home.net)
Post by David Hills
Good Afternoon
what the best way to extract the filter settings being used by a report and
display them in the report header?
are there some simple example some where?
thanks
David
Loading...