mibuso.com

Microsoft Business Solutions online community
It is currently Mon Sep 22, 2014 2:08 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 12:27 pm 
Offline

Joined: Sat Dec 19, 2009 1:41 pm
Posts: 390
Country: India (in)
hi experts

I am trying to add a column into the Sales order report's RTC Layou't page footer section .but it is giving an error message you can't add fields into the page header/ footer section.plz guide me how i will add customize column into the page footer section of the RTC view.


Top
 Profile E-mail  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 12:34 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
Did you add the field in classic section and able to see datasetname in rdlc dataset?

then add the field in body section with visible false and add it in Page Footer just like we do for Page Header..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 12:55 pm 
Offline

Joined: Sat Dec 19, 2009 1:41 pm
Posts: 390
Country: India (in)
I am able to see the data set in rdlc view. but it is giving an error message "error while validating rdl content.The value expression of the text box sokus refers to a field. Fields cannot be used page headers or footers". here sosku is the dataset name.


Top
 Profile E-mail  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 12:58 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
Did you add it in body section and showing in page footer using reportitems?

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:03 pm 
Offline

Joined: Sat Dec 19, 2009 1:41 pm
Posts: 390
Country: India (in)
i don't know how to add using report item's plz guide me.


Top
 Profile E-mail  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:07 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
Check Reports 1 and 2 hhow Page Headers are shown using ReportItems..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:29 pm 
Offline

Joined: Sat Dec 19, 2009 1:41 pm
Posts: 390
Country: India (in)
I have checked it. But here i want to display a summary column in rdlc layout footer of the report. Using report item is it possible.


Top
 Profile E-mail  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:32 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
yes..it is possible..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:41 pm 
Offline

Joined: Sat Dec 19, 2009 1:41 pm
Posts: 390
Country: India (in)
I have tried . but i can't . guide me how to do this.


Top
 Profile E-mail  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 1:44 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4594
Location: Hyderabad
Country: India (in)
You have example reports as I mentioned above and help guide here
http://msdn.microsoft.com/en-us/library/ms252093(v=vs.80).aspx

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Sales Order Report column adding
PostPosted: Fri Jun 08, 2012 4:00 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Sep 04, 2008 8:34 pm
Posts: 438
Location: Copenhagen
Country: Denmark (dk)
When NAV 2013 is released you can add columns directly into headers and footers. =D>

But for NAV 2009 you are requried to first add the column to the Body of the report and then reference these from the Header or Footer. :(
There are 2 ways to do this. Either use the Reportitems or Code.Set/Get method.

I have created a simple report where these 2 ways are ilustrated.
Attachment:
Code.get ReportItems example.JPG
Code.get ReportItems example.JPG [ 74.84 KiB | Viewed 1088 times ]

You can find a report with this example here:
in TXT, FOB and PDF

/Claus Lundstrøm

_________________
Claus Lundstrøm | MVP | Senior Product Manager | Abakion.com
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. 500+ NAV developers have now been at my training


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

All times are UTC + 1 hour [ DST ]


Who is online

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