mibuso.com

Microsoft Business Solutions online community
It is currently Mon Sep 01, 2014 8:36 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 9 posts ] 
Author Message
 Post subject: Problem with Export to Excel
PostPosted: Wed Jul 11, 2012 1:43 pm 
Offline

Joined: Sun Feb 13, 2011 7:58 am
Posts: 62
Country: Nepal (np)
hello Experts,

I was tryig to export inventory items via Export to Excel functionality. There is a field Picture. I coded it like

CALCFIELDS(Picture);
TempExcelBuffer.INIT;
TempExcelBuffer.VALIDATE("Row No.",RowNo);
TempExcelBuffer.VALIDATE("Column No.",7);
TempExcelBuffer."Cell Value as Text" := '';
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := FALSE;
TempExcelBuffer.Italic := FALSE;
TempExcelBuffer.Underline := FALSE;
TempExcelBuffer.Picture := Picture ;
TempExcelBuffer.INSERT;
(There i added picture field on excel buffer)

This works fine in Classic but While printing on RTC i can not get the picture exported

Please Help me>.>>>>>>


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Wed Jul 11, 2012 2:13 pm 
Offline

Joined: Sat Aug 08, 2009 6:28 am
Posts: 162
Location: gujarat
Country: India (in)
Try by setting Property EnableExternalImages yes in report

_________________
Uday Mer | MS Dynamics NAV Techno-Functional Consultant


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Thu Jul 12, 2012 6:39 pm 
Offline

Joined: Sun Feb 13, 2011 7:58 am
Posts: 62
Country: Nepal (np)
I am using the database not the external image


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Mon Jul 16, 2012 12:01 pm 
Offline

Joined: Thu Jan 29, 2009 5:06 pm
Posts: 365
Location: Sofia
Country: Bulgaria (bg)
edit

_________________
-Mihail- [MCTS]


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Fri Jul 20, 2012 12:45 pm 
Offline

Joined: Sun Feb 13, 2011 7:58 am
Posts: 62
Country: Nepal (np)
mihail_kolev wrote:
edit


What to edit???


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Fri Jul 20, 2012 1:29 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4179
Location: Olst
Country: Netherlands (nl)
What are you trying to achieve? Should the pictrure showup in Excel?

Does that really work in the Classic Client? I'd expect that you have done more customisation to the excel buffer table than what shows in your post.

If this works, I assume you export the picture to a folder before you pick it up in excel. Maybe the picture now sits on the service tier when run in the RTC?

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Sat Jul 21, 2012 9:01 am 
Offline
Microsoft employee

Joined: Mon Feb 27, 2012 10:18 am
Posts: 19
Country: Denmark (dk)
As already mentioned we need a little more details on the user scenario.

Do you want the data incl. the picture to show up in Excel? Are you printing from Excel or do you expect it to print directly without showing up in Excel?

When you say that classic client works, how does it actually looks there, showing in report, excel or table?

_________________
“This posting is provided "AS IS" with no warranties, and confers no rights.”

Lars-Bo Christensen
Software Developer @ Microsoft


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Mon Jul 23, 2012 7:33 pm 
Offline

Joined: Sun Feb 13, 2011 7:58 am
Posts: 62
Country: Nepal (np)
My user wants all the inventory items (For example) in excel file with picture within one of the cell after item description.
like::
Item description Picture Quantity on Hand
..........................................................................................
B1 Bicycle :D 234

Exactly like this in first sheet of excel file.


Top
 Profile E-mail  
 
 Post subject: Re: Problem with Export to Excel
PostPosted: Tue Jun 03, 2014 9:53 am 
Offline

Joined: Sun May 30, 2010 3:55 pm
Posts: 39
Country: Ukraine (ua)
Quote:
B1 Bicycle :D 234

Exactly like this in first sheet of excel file.


In such case you can just create a report with printed layout and select Print > Excel on request form. System will generate excel file for you.


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Exabot [Bot] and 6 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: