Sales Order Report column adding

mkpjsr

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.

mohana_cse06

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..

mkpjsr

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.

mohana_cse06

Did you add it in body section and showing in page footer using reportitems?

mkpjsr

i don't know how to add using report item's plz guide me.

mohana_cse06

Check Reports 1 and 2 hhow Page Headers are shown using ReportItems..

mkpjsr

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.

mohana_cse06

yes..it is possible..

mkpjsr

I have tried . but i can't . guide me how to do this.

mohana_cse06

You have example reports as I mentioned above and help guide here
http://msdn.microsoft.com/en-us/library/ms252093(v=vs.80).aspx

clausl

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.

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

/Claus Lundstrøm