Hi,
Sorry for the delay, I havn't checked the mails in this grp for quite a long
time. Though it seems you have got a solution and it is working also, you can
try this simpler one to print your report directly to excel.
this.printJobSettings().setTarget(PrintMedium::File);
this.printJobSettings().format(PrintFormat::ASCII);
this.printJobSettings().fileName(fileName);
Put this in the init method of your report. Put a proper file name (e.g.
C:\1.xls).
Barunava
----- Original Message ----
From: Chirani <[EMAIL PROTECTED]>
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Monday, 10 December, 2007 8:09:11 AM
Subject: [Axapta-Knowledge-Village] Re: Print Reort in Exel
Barunava,
Can you explain how to do this by code.
Many Thanks,
Chirani.
--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Barunava Pal
<[EMAIL PROTECTED] .> wrote:
>
> Hi Febin,
> Do you want to print the report in excel instead of viewing it in
screen or print it in some printer? You can do that through code but
in that case every time that report will be printed in excel you can
not view it in screen or printer. Tell specifically about the
requirement.
>
> Barunava
>
> ----- Original Message ----
> From: febinpc <[EMAIL PROTECTED] >
> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> Sent: Monday, 3 December, 2007 12:54:19 PM
> Subject: [Axapta-Knowledge- Village] Print Reort in Exel
>
>
>
>
>
>
>
>
>
>
>
>
>
> hi friends
>
> i want to print one report daily basis. and i want that data in
excel.
>
> not all columns but some specified columns.for calculation purpose.
>
> how can i make it in Axapta.when i run report this excel sheet also
>
> should come up directly just like wxcel export.
>
>
>
> Thanks and Regards
>
>
>
> Febin Chiramel
>
> Mumbai
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <!--
>
> #ygrp-mkp{
> border:1px solid #d8d8d8;font- family:Arial; margin:14px
0px;padding: 0px 14px;}
> #ygrp-mkp hr{
> border:1px solid #d8d8d8;}
> #ygrp-mkp #hd{
> color:#628c2a; font-size: 85%;font- weight:bold; line-
height:122%; margin:10px 0px;}
> #ygrp-mkp #ads{
> margin-bottom: 10px;}
> #ygrp-mkp .ad{
> padding:0 0;}
> #ygrp-mkp .ad a{
> color:#0000ff; text-decoration: none;}
> -->
>
>
>
> <!--
>
> #ygrp-sponsor #ygrp-lc{
> font-family: Arial;}
> #ygrp-sponsor #ygrp-lc #hd{
> margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;}
> #ygrp-sponsor #ygrp-lc .ad{
> margin-bottom: 10px;padding: 0 0;}
> -->
>
>
>
> <!--
>
> #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean,
sans-serif;}
> #ygrp-mlmsg table {font-size:inherit; font:100% ;}
> #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica,
clean, sans-serif;}
> #ygrp-mlmsg pre, code {font:115% monospace;}
> #ygrp-mlmsg * {line-height: 1.22em;}
> #ygrp-text{
> font-family: Georgia;
> }
> #ygrp-text p{
> margin:0 0 1em 0;}
> #ygrp-tpmsgs{
> font-family: Arial;
> clear:both;}
> #ygrp-vitnav{
> padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;}
> #ygrp-vitnav a{
> padding:0 1px;}
> #ygrp-actbar{
> clear:both;margin: 25px 0;white-space: nowrap;color: #666;text-
align:right; }
> #ygrp-actbar .left{
> float:left;white- space:nowrap; }
> .bld{font-weight: bold;}
> #ygrp-grft{
> font-family: Verdana;font- size:77%; padding:15px 0;}
> #ygrp-ft{
> font-family: verdana;font- size:77%; border-top: 1px solid #666;
> padding:5px 0;
> }
> #ygrp-mlmsg #logo{
> padding-bottom: 10px;}
>
> #ygrp-vital{
> background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;}
> #ygrp-vital #vithd{
> font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text-
transform:uppercase ;}
> #ygrp-vital ul{
> padding:0;margin: 2px 0;}
> #ygrp-vital ul li{
> list-style-type: none;clear: both;border: 1px solid #e0ecee;
> }
> #ygrp-vital ul li .ct{
> font-weight: bold;color: #ff7900;float: right;width: 2em;text-
align:right; padding-right: .5em;}
> #ygrp-vital ul li .cat{
> font-weight: bold;}
> #ygrp-vital a{
> text-decoration: none;}
>
> #ygrp-vital a:hover{
> text-decoration: underline; }
>
> #ygrp-sponsor #hd{
> color:#999;font- size:77%; }
> #ygrp-sponsor #ov{
> padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;}
> #ygrp-sponsor #ov ul{
> padding:0 0 0 8px;margin:0; }
> #ygrp-sponsor #ov li{
> list-style-type: square;padding: 6px 0;font-size: 77%;}
> #ygrp-sponsor #ov li a{
> text-decoration: none;font- size:130% ;}
> #ygrp-sponsor #nc{
> background-color: #eee;margin- bottom:20px; padding:0 8px;}
> #ygrp-sponsor .ad{
> padding:8px 0;}
> #ygrp-sponsor .ad #hd1{
> font-family: Arial;font- weight:bold; color:#628c2a; font-
size:100%;line- height:122% ;}
> #ygrp-sponsor .ad a{
> text-decoration: none;}
> #ygrp-sponsor .ad a:hover{
> text-decoration: underline; }
> #ygrp-sponsor .ad p{
> margin:0;}
> o{font-size: 0;}
> .MsoNormal{
> margin:0 0 0 0;}
> #ygrp-text tt{
> font-size:120% ;}
> blockquote{margin: 0 0 0 4px;}
> .replbq{margin: 4;}
> -->
>
>
>
>
>
>
>
>
> Share files, take polls, and discuss your passions - all
under one roof. Go to http://in.promos. yahoo.com/ groups
>
> [Non-text portions of this message have been removed]
>
5, 50, 500, 5000 - Store N number of mails in your inbox. Go to
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
[Non-text portions of this message have been removed]
