Dear Pankaj Yes, Now we are taking this way, but my question is some of the data could not match with original Axapta figures. So I required the sample queries from internet. Where I can get? Regards P Saravanakumar Co-Its 09894999281 -----Original Message----- From: Pankaj Kant [mailto:[EMAIL PROTECTED] Sent: Monday, May 21, 2007 5:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Dear Sarvana
U need to connect to Axapta Database using SQL-Net Connect Client and run your query for generating the report Best regards Pankaj ________________________________ From: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] [mailto:Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] On Behalf Of p.saravanakumar Sent: Monday, May 21, 2007 4:26 PM To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Dear Srinivas We are using Oracle Database Regards P Saravanakumar 09894999281 -----Original Message----- From: Ajit Srivastava [mailto:contact2ajit2006@ <mailto:contact2ajit2006%40yahoo.co.in> yahoo.co.in <mailto:contact2ajit2006%40yahoo.co.in> ] Sent: Friday, May 18, 2007 4:55 PM To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] <mailto:Axapta-Knowledge-Village%40yahoogroups.com> Subject: Re: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hello srinivas, U hav to do by Sql Server 2005 reporting services.. Regards Ajit Srivastava @ +919999441034Technical Consultant NSL - A Tata Group Company New Delhi -110 058 Tel. +91(11) 25544 703 / 4704 Telefax +91(11) 25544705 Websites: www.tata.com/nelito/index.htm www.nelito.com ----- Original Message ---- From: p.saravanakumar <p.saravanakumar@ <mailto:p.saravanakumar%40tvssons.com> tvssons.com> To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] <mailto:Village%40yahoogroups.com> .com <mailto:Village%40yahoogroups.com> Sent: Friday, 18 May, 2007 1:06:36 PM Subject: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE Hi Friends Does anybody having a SQL Query for taking reports directly from Backend Database in Axapta? Or where I get it from? Regards P Saravanakumar Co-Its 09894999281 [Non-text portions of this message have been removed] __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers. <http://in.answers. <http://in.answers.yahoo.com/> yahoo.com/ <http://in.answers. <http://in.answers.yahoo.com/> yahoo.com/> > yahoo.com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system This email may have been intercepted, partially destroyed, arrive late, incomplete or contain viruses and no liability is accepted by LG Life Sciences India Pvt. Ltd. (LGLSI) as a result. Opinions, conclusions and other information in this message represent the opinion of the sender and do not necessarily represent or reflect the views and opinions of LGLSI. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]