Hi All
i want to Print the report direct in Excel and As Well As Summery of
PivotTable Also Print in Report .
i have print my report direct in Excel .
but pivotTable is not working .
how are print the report in PivotTable?
have u any solution ..
plz advice me ...
thanks
Santosh
On 12/12/07, Ramanan Seshadri <[EMAIL PROTECTED]> wrote:
>
> Thank you very much. It works out. wonderful tips you shared to the
> group..
>
> S Ramanan
>
> ----- Original Message ----
> From: EPI-Supachai (IT) Jirapatcharasin <[EMAIL
> PROTECTED]<supachaij%40aeroflex.co.th>
> >
> To:
> Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>
> Sent: Tuesday, 11 December, 2007 12:49:48 PM
> Subject: RE: [Axapta-Knowledge-Village] Re: Print Reort in Exel
>
> Try this code..
>
> static void ExportExcel( Args _args)
>
> {
>
> SysExcelApplication ExcelApplication;
>
> SysExcelWorkBooks ExcelWorkBooks;
>
> SysExcelWorkBook ExcelWorkBook;
>
> SysExcelWorkSheets ExcelWorkSheets;
>
> SysExcelWorkSheet ExcelWorkSheet;
>
> SysExcelRange ExcelRange;
>
> CustTable custTable;
>
> int row=1;
>
> ExcelApplication = SysExcelApplication ::construct( );
>
> ExcelApplication. visible(true) ;
>
> ExcelWorkBooks = ExcelApplication. workbooks( );
>
> ExcelWorkBook = ExcelWorkBooks. add();
>
> ExcelWorkSheets = ExcelWorkBook. worksheets( );
>
> ExcelWorkSheet = ExcelWorkSheets. itemFromNum( 1);
>
> ExcelWorkSheet. cells().item( row,1).value( 'Account num');
>
> ExcelWorkSheet. cells().item( row,2).value( 'Name');
>
> row++;
>
> while select custTable where custtable.AccountNu m like '11-000*'
>
> {
>
> ExcelWorkSheet. cells().item( row,1).value( custTable. AccountNum) ;
>
> ExcelWorkSheet. cells().item( row,2).value( custTable. Name);
>
> row++;
>
> }
>
> ExcelApplication. finalize( );
>
> }
>
> ____________ _________ _________ __
>
> From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Ramanan
> Seshadri
> Sent: Tuesday, December 11, 2007 12:29 PM
> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> Subject: Re: [Axapta-Knowledge- Village] Re: Print Reort in Exel
>
> Dear bbarunava
>
> I am also waiting for your answer
>
> S Ramanan
>
> ----- Original Message ----
> From: Chirani <ras_here2002@ yahoo.com <mailto:ras_ here2002% 40yahoo.com>
> >
> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> <mailto:Axapta- Knowledge- Village%40yahoog roups.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]
> >
>
> Forgot the famous last words? Access your message archive online at
> http://in.messenger .yahoo.com/ webmessengerprom o.php
> <http://in.messenger .yahoo.com/ webmessengerprom o.php>
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> Save all your chat conversations. Find them online at
> http://in.messenger.yahoo.com/webmessengerpromo.php
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
