Reports – Page 12 – Pardaan.com

Dynamics NAV & BC Functional Tips & tricks

Dynamics NAV 2009: Reports Q&A

With introduction of RDLC reports, we've seen number of questions being raised recurringly around specific reports' features, or lack of them. We've tried to collect the most recurring ones in one place and hope you might find this useful. if you have questions and/or answers you…

5 June 2011

Dynamics NAV & BC Tips & tricks

How to change thousands/decimals separators in RDL reports

In "old good classic" NAV we have feature (and property) named AutoFormatType. Together with property AutoFormatExpr we can set decimal to any format we need. This could be done in the way: we describe new AutoFormatType in the codeunit 1 in function "AutoFormatTranslate(AutoFormatType : Integer;AutoFormatExpr :…

4 June 2011

Dynamics NAV & BC Tips & tricks

RDL Report Design: ReportItems! and why are fields not shown in the header when printing (works OK in preview)?

In Headers and Footers in RDL Layout we cannot just add fields from the dataset. Instead, we must add the field to the Body of the report (but hide it), and then use the ReportItems! collection in the header to refer to the field in the…

4 June 2011

Dynamics NAV & BC Tips & tricks

Microsoft SQL Server Reporting Services

Ik zal het maar gelijk zeggen: ik ben geen fan van de Report Designer in Microsoft Dynamics NAV. In mijn ogen kun je er vooral veel dingen niet mee en is de rigide opzet niet meer van deze tijd. Het feit dat er code geprogrammeerd moet…

4 June 2011

Dynamics NAV & BC Tips & tricks

Charts in Classic Reports

I am back to add the charts in below Classic report (Monthly Purchase Invoices) This can be done using the excel automation as below.. Bron : Mohana Lees meer...

4 June 2011

Dynamics NAV & BC Tips & tricks

Monthly Purchase Invoices in Chart

One of the new features of RTC is Charts in reports . Today I would like to see the monthly total purchase invoices amount in charts. Bron : Mohana Lees meer...

4 June 2011

Dynamics NAV & BC Tips & tricks

Importeren CSV bestand, eerste regel (kolomtitels) overslaan

Bij het importeren van een .csv bestand wil je feitelijk nooit de eerste regel importeren (kolomtitels). Uiteraard kan je de eerste regel verwijderen in het .csv bestand, er is echter een hele eenvoudige oplossing: OnPreDataItem trigger: IF CurrDataport.IMPORT THEN BEGIN CurrFile.TEXTMODE(TRUE); CurrFile.READ(AbpTxtDummy); //AbpTxtDummy = BigText CurrFile.TEXTMODE(FALSE);…

16 January 2011