[Axapta-Knowledge-Village] Re: Howto from a newbie to this group
--- In [EMAIL PROTECTED], Stephane Laulhere [EMAIL PROTECTED] wrote: Hi there, First, hello everybody. I've just found this group, I hope it will help me a little in this Axaptian deep ocean... 3 questions to start : 1- Is there anybody french (or french-speaking) in this group ? 2- I want to make a select count(*) from an overview (in any form, but let's take the custtable form). Just to get the number of records my request gave me. How can I code this ? 3- Furthermore, if I want to get back the parameters of a request (fields + criteria) from a search or a filter command, how can I do that ? (let's say I have to click on a home-made-report button, which list me the content of the overview list in a form. If I click on the autoreport button, it works, but it's ugly...) Many, many thanks in advance for your answers, SteF from Bordeaux,France. If custom office agrees, i send a bottle of wine to the first guy who respond to me ! :) Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Howto from a newbie to this group
--- In [EMAIL PROTECTED], Stephane Laulhere
[EMAIL PROTECTED] wrote:
Hi there,
First, hello everybody. I've just found this group, I hope it will
help me a little in this Axaptian deep ocean...
3 questions to start :
1- Is there anybody french (or french-speaking) in this group ?
2- I want to make a select count(*) from an overview (in any
form,
but let's take the custtable form). Just to get the number of
records
my request gave me. How can I code this ?
You can find the number of records selected in a datasource with
total = SysQuery::countTotal(CustTable_ds.queryRun());
Try putting a method on the data source like this
display int Records()
{
int total;
;
total = SysQuery::countTotal(this.queryRun());
return total;
}
Then add a button to the form with a clicked method that says
void clicked()
{
super();
Box::info('This selection contains '+int2str(CustTavle_ds.Records())
+' records');
}
3- Furthermore, if I want to get back the parameters of a request
(fields + criteria) from a search or a filter command, how can
I
do that ? (let's say I have to click on a home-made-report button,
which list me the content of the overview list in a form. If I
click
on the autoreport button, it works, but it's ugly...)
Try running the report from a class, that will give you a prettier
front-end
Have a look at the class CustReport_Auditor, it gives you a simple
example
LastValueElementName() must return the name of your report.
e.g.
public identifiername lastValueElementName()
{
return reportStr(YourReportName);
}
Hope this helps
Many, many thanks in advance for your answers,
SteF from Bordeaux,France. If custom office agrees, i send a
bottle
of wine to the first guy who respond to me ! :)
Yahoo! Groups Sponsor ~--
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Howto from a newbie to this group
Many thanks Allan !
You can find the number of records selected in a datasource with
total = SysQuery::countTotal(CustTable_ds.queryRun());
(this works fine. And I'm starting to understand many things with
datasources with this exemple...)
3- Furthermore, if I want to get back the parameters of a request
(fields + criteria) from a search or a filter command, how
can
I do that ?
Try running the report from a class, that will give you a prettier
front-end
Have a look at the class CustReport_Auditor, it gives you a simple
example
LastValueElementName() must return the name of your report.
e.g.
public identifiername lastValueElementName()
{
return reportStr(YourReportName);
}
For this part, I don't have access to classes development...
Hope this helps
(sure it helps ! many thanks again)
Yahoo! Groups Sponsor ~--
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Howto from a newbie to this group
I can only reply to question #1: - I speak french Fabrice Perez Microsoft Certified Trainer and Applications Professional - Axapta General Application, Finance, Trade Logistics, Production, Projects, Shop Floor Control Mobile: +65 9836 4065 Fax:+65 6234 1709 E-mail: [EMAIL PROTECTED] --- In [EMAIL PROTECTED], Stephane Laulhere [EMAIL PROTECTED] wrote: Hi there, First, hello everybody. I've just found this group, I hope it will help me a little in this Axaptian deep ocean... 3 questions to start : 1- Is there anybody french (or french-speaking) in this group ? 2- I want to make a select count(*) from an overview (in any form, but let's take the custtable form). Just to get the number of records my request gave me. How can I code this ? 3- Furthermore, if I want to get back the parameters of a request (fields + criteria) from a search or a filter command, how can I do that ? (let's say I have to click on a home-made-report button, which list me the content of the overview list in a form. If I click on the autoreport button, it works, but it's ugly...) Many, many thanks in advance for your answers, SteF from Bordeaux,France. If custom office agrees, i send a bottle of wine to the first guy who respond to me ! :) Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
