for doing it right now....
Thanks once again
James
-----Original Message-----
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet
Sent: 09 June 2005 11:01
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Print all Axapta companies data in a
report
There is actually a class + a form, both called SysQueryForm, that
control the queries for reports.
If you change the findFields() method on the class, you can enable the
Company (DataAreaId) field for selection, but there may be other things
needed to have it actually pull data.
I need to dig more into this later myself, but I don't have time right
now. Hopefully this will get you started.
________________________________
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
Sent: Monday, May 30, 2005 7:52 PM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Print all Axapta companies data in a
report
Hi
I am thinking of writing a report that prints information from several
Axapta companies but do not want to have to use the changeCompany
function
because I want a select (or query) to be able to run through all the
records
to consolidate records with same values and so I would like to use
groupby
rather than manually have to do this with change company and temp tables
etc.
Is this possible or will all Axapta select statements and queries always
be
defaulted to filter by the current company I am in? Is there anyway to
turn
this default behaviour off for a given select or query?
I guess I can write direct SQL in Axapta but I have never done this and
so
am not sure the syntax to handle the returned records/results so would
prefer to do it using std Axapta if possible. If it is only possible
with
direct SQL I would apprecaite some help as how to handle the results
coming
back.
Can I make use of views for this?
Thanks
James
[Non-text portions of this message have been removed]
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
