Newbie....stupid question

kmerigold
Member Posts: 28
Hi,
I am very familiar with Crystal Reports and Access reports, etc. But I am having a hard time with these navision reports......
I am simply trying to add a "grand" total field for a Calculated field in three group bodies (Group for total Invoices, total Orders, total Credit Memo's).
It comes up blank if i copy/paste the subtotal field into the report footer...
Where are the "created formulas stored?" or where can I create one? (if possible".
Thanks for any insight!
Kim
I am very familiar with Crystal Reports and Access reports, etc. But I am having a hard time with these navision reports......
I am simply trying to add a "grand" total field for a Calculated field in three group bodies (Group for total Invoices, total Orders, total Credit Memo's).
It comes up blank if i copy/paste the subtotal field into the report footer...
Where are the "created formulas stored?" or where can I create one? (if possible".
Thanks for any insight!
Kim
0
Comments
-
If it's a field in the database then you have to assign the field to the property "TotalFields" of the dataitem the field belongs to.
If it's a variable you defined yourself, you can activate the "TotalFields" functionality by using the CREATETOTALES function in the OnPreDataItem of the dataitem the fields belongs to.
Check the Navsion help for more info on that statement."Real programmers don't comment their code.
If it was hard to write, it should be hard to understand."0 -
Thanks..0
-
Are you Using Crystal Reports with Navision?
I find it a great tool to come up with reports quickly.
And as I find the time I try to re-create them in Navision.
& Yes it takes much more time in Navision.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions