mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 10:21 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Excel Rtc Issue
PostPosted: Sat Mar 10, 2012 9:33 am 
Offline

Joined: Fri Jul 30, 2010 8:17 am
Posts: 227
Country: India (in)
I have a customized report, having code written on section for Excel, which is to be shifted on dataitem for Rtc.
The code written on Purchase header's Groupfooter is as:

CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = FIELDNO("No.");
IF "Purch. Rcpt. Line".Quantity = 0 THEN
CurrReport.SHOWOUTPUT(FALSE);

The data is not correct in the excel generating for Rtc.
It is picking the second value and the totals are wrong
My question is how this part of the code written below be implemented for Rtc:
CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = FIELDNO("No.");

PFA


Attachments:
5002_Code.jpg
5002_Code.jpg [ 156.38 KiB | Viewed 477 times ]
File comment: Sections
50022.jpg
50022.jpg [ 90.6 KiB | Viewed 477 times ]
Top
 Profile E-mail  
 
 Post subject: Re: Excel Rtc Issue
PostPosted: Sun Mar 11, 2012 8:08 am 
Offline

Joined: Thu Jan 14, 2010 5:36 am
Posts: 92
Location: Atlanta,GA
Country: United States (us)
GroupHeader,GroupFooter,TransHeader and Transfooter which you define in classic is not supported in RTC. You have to create groups in RTC and specify filters and visibile property to achieve your logic.

_________________
Suresh Kulla
ArcherPoint, LLC http://www.archerpoint.com


Top
 Profile E-mail  
 
 Post subject: Re: Excel Rtc Issue
PostPosted: Mon Mar 12, 2012 3:04 pm 
Offline

Joined: Thu Mar 10, 2011 3:03 pm
Posts: 68
Location: Kanpur
Country: India (in)
Hi,

Group Header , Group footer,Trans header & trans footer not supported in RDLC.
Check this link for more information:
http://msdn.microsoft.com/hi-in/library/ms251700.aspx
=D> :-k

_________________
Sharad Gupta
Navision Technical Consultant & .Net Developer


Top
 Profile E-mail  
 
 Post subject: How to pick mid value in Rtc
PostPosted: Tue Mar 13, 2012 8:51 am 
Offline

Joined: Fri Jul 30, 2010 8:17 am
Posts: 227
Country: India (in)
Hi Experts,

I have a customized report for which some Discount calculation is done in classic.
I have developed the Rtc report for the same, Discount calculation part was flowed from classic to Rtc via a
variable, to get the value of that variable last(Exp) is used in Expression, but in my case there is another fields which get calculated at the end and so the value of the variable at the last is Blank, so it pick the Blank value instead of the required value.So how could i pick the mid value in Rtc.
Screenshot attaced.(About this Report).


Attachments:
Abou this Report.png
Abou this Report.png [ 439.09 KiB | Viewed 375 times ]
Top
 Profile E-mail  
 
 Post subject: Re: Excel Rtc Issue
PostPosted: Tue Mar 13, 2012 9:25 pm 
Offline

Joined: Thu Jan 14, 2010 5:36 am
Posts: 92
Location: Atlanta,GA
Country: United States (us)
If last value is the highest of all and if you want to display that value then you can use Max() function. There is no function to get mid value you have to create another variable in classic and assign the desired value in it and use that field to display it in RTC.

_________________
Suresh Kulla
ArcherPoint, LLC http://www.archerpoint.com


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 8 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: