If you want to change the property dynamically with
user interaction, then need modification at the report
and also the parameter form (which is SysQueryForm
form).
This is the example code for change the property
programatically:
//init method of the report
public void init()
{
object obj;
;
super();
obj =
element.design().sectionName("SalesLine_1").controlName("SalesLine_LineAmount");
obj.SumAll(NoYes::Yes);
}
>From above method, you may add conditions which
controls will be summed or not summed.
I'm sorry I cannot provide more detailed solution, but
you can use above code as a good start.
Good luck.
--- Stefan Osterburg <[EMAIL PROTECTED]> wrote:
> Sonny,
>
> thanks for your answer - but I do not want to save
> the autoreport in AOT
> as I want the user to choose by what feidls he needs
> the report grouped
> and sub-totaled:
>
> The user clicks on the print icon, when he is in a
> form where in my case
> ProjJournalTrans is the datasource, Axapta opens the
> dialog for
> Auto-Reports, the user clicks "Select" and on the
> tab Sorting can choose
> the fields to sort the report by and decide to print
> subheadings and
> subtotatals, whenever the value in a certain sort
> field changes.
>
> Unfortenately, Axapta does not print subtotals for
> all number fields,
> but only certain fields. As I explained in my
> initial mail the following
> example shows what I mean: when I use auto-report on
> LedgerTrans table I
> get a sum on the AmountMST field but not on the
> AmountMSTSecond field.
> Likewise I cannot get Axapta to automatically print
> subtotals on
> ProjJournalTrans\Qty field.
>
> What I woulkd like to know is how I can tell Axapta
> to consider certain
> number fields for automatic subtotal-creation.
>
> Stefan
>
>
> Sonny Wibawa Adi schrieb:
> > Hi, Stefan,
> >
> > You have to change the report design through AOT.
> Set
> > the property "SumAll" or "SumNeg" or "SumPos" of
> > real-type controls to "Yes".
> >
> > Those controls will then be summed up by Axapta
> > automatically.
> >
> >
> > --- Stefan Osterburg <[EMAIL PROTECTED]> wrote:
> >
> >
> >>Hi,
> >>
> >>I am trying to use Axapta's auto report to print
> >>group total sums.
> >>However I do not get this to work for all fields I
> >>would like to
> >>sum up.
> >>
> >>For example when I use auto-report on LedgerTrans
> >>table I get a sum
> >>on the AmountMST field but not on the
> >>AmountMSTSecond field.
> >>
> >>However what I am actually trying is to get an
> >>auto-report on
> >>ProjJournalTrans print sub-totals for the Qty
> field.
> >>
> >>Any idea, how Axapta chooses the fields to print
> >>sums for and
> >>what I can do to change this?
> >>
> >>Stefan
> >>
> >>
> >>
> >>
> >>
> >>------------------------ Yahoo! Groups Sponsor
> >>--------------------~-->
> >>Get Bzzzy! (real tools to help you find a job).
> >>Welcome to the Sweet Life.
> >>
> >
> >
>
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM
> >
> >
>
--------------------------------------------------------------------~->
> >
> >>
> >>
> >>Yahoo! Groups Links
> >>
> >>http://groups.yahoo.com/group/development-axapta/
> >>
> >> [EMAIL PROTECTED]
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> > Best regards,
> >
> >
> > Sonny Wibawa Adi
> > MBS Certified Professional - Axapta 3.0 Technical
> > MCSD.NET
> > MCAD.NET
> >
> >
> >
> > __________________________________
> > Yahoo! Music Unlimited
> > Access over 1 million songs. Try it free.
> > http://music.yahoo.com/unlimited/
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
Best regards,
Sonny Wibawa Adi
MBS Certified Professional - Axapta 3.0 Technical
MCSD.NET
MCAD.NET
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
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.
