mibuso.com

Microsoft Business Solutions online community
It is currently Sun Nov 23, 2014 4:24 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Wed Feb 24, 2010 11:46 am 
Offline

Joined: Sat Mar 29, 2008 6:29 am
Posts: 527
Location: chennai
Country: India (in)
Hi all,

when I try to run the codeunit from a form in Nav classic version of 2009,I can able to export to excel.But when i try to put this same coding in a page and try to run it in NAV 2009 RTC, i can able to find the option but cannot able to export to excel.if anybody knows the reason, Kindly suggest me a solution on how to rectify this error.

Thanks in advance.

Regards,
chandru.


Top
 Profile E-mail  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Wed Feb 24, 2010 2:00 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV/Navision' forum to 'NAV 2009' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Thu Feb 25, 2010 7:09 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 7:50 am
Posts: 12443
Location: Brno
Country: Czech Republic (cz)
Think about one thing - is the export running on machine, where the excel is installed? Do not forget that business logic is running on NST by default...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Thu Feb 25, 2010 8:45 am 
Offline

Joined: Sat Mar 29, 2008 6:29 am
Posts: 527
Location: chennai
Country: India (in)
Hi Kine,

When I run the export to excel from form in nav 2009 classic, the excel is opened but when i try to open fron the page, its not opening. This is the problem.

If you have any suggestion on how to rectify this, kindly suggest me.

Thanks in advance.

Regards,
chandru.


Top
 Profile E-mail  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Thu Feb 25, 2010 10:11 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 7:50 am
Posts: 12443
Location: Brno
Country: Czech Republic (cz)
And again, have you read my answer? Do you know how the classic client and RTC are different?

Classic will run the business logic on your PC, RTC will run it on NST (where the mid-tier is installed)...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Fri Feb 26, 2010 8:10 am 
Offline

Joined: Sat Mar 29, 2008 6:29 am
Posts: 527
Location: chennai
Country: India (in)
Hi Kine,

I have installed all the three tiers in single PC and it is standalone system. If this is the case, then it should work right.

Thanks in advance.

Regards,
chandru.


Top
 Profile E-mail  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Fri Feb 26, 2010 8:38 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 7:50 am
Posts: 12443
Location: Brno
Country: Czech Republic (cz)
And what error you will get when you try to use the export?

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Sat Feb 27, 2010 8:52 pm 
Offline

Joined: Tue Feb 16, 2010 7:19 pm
Posts: 41
Country: India (in)
can be the case that how you are exporting to excel ..using Excel Buffer or not ? as it handles some RTC file handling that might be missed if these table is not used and that code is not in the codeunit also ...


Top
 Profile E-mail  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Wed Mar 03, 2010 6:35 am 
Offline

Joined: Sat Mar 29, 2008 6:29 am
Posts: 527
Location: chennai
Country: India (in)
Hi Kine,

I have called a codeunit in the Page onpush trigger of the page actions.But when I click the menu in from the page nothing is happening.Actually when i click the menu i should get a bar chart in Excel.The same codeunit i have called in form and there it was working fine.But in RTC it is nor working.

If you know the solution for this, Kindly reply.

Thanks in advance.

Regards,
chandru.


Top
 Profile E-mail  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Thu Mar 04, 2010 6:41 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Oct 16, 2003 7:50 am
Posts: 12443
Location: Brno
Country: Czech Republic (cz)
Bat please, read all the questions and answer them. Navinb asked something and it is critical thing. How you are generating the excel. Do not forget that the code is on middle tier and thus it is not possible to show you something on the client. But all depends on how you are generating the excel...

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


Top
 Profile E-mail WWW  
 
 Post subject: Re: Export to Excel in NAV 2009 RTC - Not Working
PostPosted: Wed Mar 10, 2010 1:34 pm 
Offline

Joined: Mon Oct 06, 2008 1:05 pm
Posts: 269
Country: India (in)
Hi,
Prefer you look at page id. Migration Overview (8614)->Action ->Function->Export to Excel or Import to Excel.

But you need to look into the code for reference purpose.


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: