I think ypu should add ranges separately for each
datasorce table on the report according to the ranges
of the form.
Because what you tried to do
clsQueryRun = CustTable_ds.queryRun();
clsQuery = new Query(clsQueryRun.query());
clsRR.query(clsQuery);
was
assigning particular query of CustTable.
In case if there were no joined datasorces in Report
design node, no additional data would be selected.
--- "Neijs, Gideon" <[EMAIL PROTECTED]>
wrote:
> For instance:
>
> I have a form with 1 grid based on CustTable and
> SalesTable. A user adds
> filters on CustTable.CustGroup and
> SalesTable.DocumentStatus.
>
> The user clicks a button that calls a report based
> on them same 2
> datasources. Now I want to apply the same filters on
> the report.
>
>
>
> I tried this with the following code:
>
>
>
> QueryRun clsQueryRun;
>
> Query clsQuery;
>
>
>
> Report rptTest;
>
> ReportRun clsRR;
>
> ;
>
>
>
> rptTest = new Report('TestReportQuery');
>
> clsRR = new ReportRun(rptTest);
>
>
>
> clsQueryRun = CustTable_ds.queryRun();
>
> clsQuery = new Query(clsQueryRun.query());
>
>
>
> clsRR.query(clsQuery);
>
>
>
> clsRR.init();
>
> clsRR.run();
>
>
>
> This works fine for 1 datasource, but when the
> second datasource is
> added the report is empty.
>
> Does anyone know a solution for this?
>
>
>
> Regards,
>
>
>
> Gideon
>
>
>
> This e-mail and any attachment is for authorised use
> by the intended recipient(s) only. It may contain
> proprietary material, confidential information
> and/or be subject to legal privilege. It should not
> be copied, disclosed to, retained or used by, any
> other party. If you are not an intended recipient
> then please promptly delete this e-mail and any
> attachment and all copies and inform the sender.
> Thank you.
>
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
