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] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [development-axapta] Print all Axapta companies data in a report
Thanks a lot I will look into that but liek yourself I dont have much time 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.
RE: [development-axapta] Print all Axapta companies data in a report
I just found out that doing this alone won't do it. What needs to be done is to change the findFields() method on the SysQueryForm class. You will find a line in there that reads like this that you must comment out (line 28 in 3.0): (field.name() != fieldStr(Common, dataAreaId)) Next step is to, in the fetch method on your reports, read the DataAreaId fields, should they exist, and if they do, loop a changecompany() -- sorry, but that's unavoidable, but this is definitely one of the easier ways to do it anyway rather than to do a dialog that prompts for company/companies etc... :-)) Hope this helps, if you need more info, let me know. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Thursday, June 09, 2005 5:54 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Print all Axapta companies data in a report Thanks a lot I will look into that but liek yourself I dont have much time 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] 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] 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] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [development-axapta] Print all Axapta companies data in a report
If you have to go the Direct SQL route then look for odbcconnection in help and you'll get an example on how to handle the result of the raw sql command. Steeve... -Message d'origine- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de James Flavell Envoyé : 30 mai 2005 20:52 À : development-axapta@yahoogroups.com Objet : [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 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.