New to Navision (and these forums!)

SteveB

Hi all,
I've just registered and wanted to say hello!

I've been dropped in a bit at the deep end, although what I've been asked to do sounds very simple. I am a complete Navision Novice, so excuse the simplicity of my request!

We have a report which lists items bought and sold, by item type (ie make and size) for a selectable period and selectable item. The output gives me the lines selected between the dates, and then a summary total. What I've been asked to do is producce a report of just the summary totals, no further information required.

I'm a total novice however, and don't really know where to start.

Any help would be greatly appreciated!

Thanks in advance.
Steve

/edit - should have said, the current report name is Inventory - Transaction Detail which may help!

DenSter

You don't have to create a new report, you can just modify the existing one. Include a global boolean variable called 'ShowDetail' (View/Globals and then add a variable). Open the request form (view/request form) and put a checkbox on it (click the little hammer button and select a checkbox with a label), and set the SourceExpr property of the checkbox to ShowDetail.

Open the sections (view, sections) and select the body section that displays the record information. Then open the C/AL editor (F9, or view, C/AL Code) and type in the following line of code:

CurrReport.SHOWOUTPUT(ShowDetail);

With this code, the user has the option to leave out the details. This is a common method in existing reports, just browse around and steal ideas.

Welcome to Mibuso Steve, hope you will find the help you need. As you get more proficient, I hope you will return the favor and contribute. By the way, when you have a question, please put something descriptive in the topic. The topic "New to Navision" doesn't say anything about your problem, better would be something like "Don't know how to hide report details".

Marije_Brummel

Welcome to Navision and MiBuso!

Savatage

We've all been in the NEW shoes at one time or another.

"All are welcome,Walk into the light, All are welcome"

Ask away..PS don't forget the search feature on this site. You will see that many of you're questions have probably been asked before.

Note: it's also helpful to be descriptive and don't forget to add your Navision version \:D/

SteveB

Thanks for the warm welcome folks! I'll look at this in more detail on Monday when I'm back in the office, although I have a feeling some of the menu options you are describing were not apparent. I'm guessing that perhaps there may be a security level that doesn't allow access to the report editor?

Re the question about the version, is 3.7 the full answer or is there more to it than that (ie I posted my question in the 3.7 forum, so I thought that was it?)

Thanks again folks, hopefully I'll be a regular visitor, and eventually able to answer other peoples questions, not just ask my own!

Regards,
Steve

Savatage

on top see tools->object designer->reports->"find your report"-view sections

also you probably need to get the application designers guide found on your product cd - or you can download it from

http://www.geocities.com/navision_attain/downloads.html

SteveB

DenSter wrote:

You don't have to create a new report, you can just modify the existing one. Include a global boolean variable called 'ShowDetail' (View/Globals and then add a variable). Open the request form (view/request form) and put a checkbox on it (click the little hammer button and select a checkbox with a label), and set the SourceExpr property of the checkbox to ShowDetail.

Open the sections (view, sections) and select the body section that displays the record information. Then open the C/AL editor (F9, or view, C/AL Code) and type in the following line of code:

CurrReport.SHOWOUTPUT(ShowDetail);

With this code, the user has the option to leave out the details. This is a common method in existing reports, just browse around and steal ideas.

Welcome to Mibuso Steve, hope you will find the help you need. As you get more proficient, I hope you will return the favor and contribute. By the way, when you have a question, please put something descriptive in the topic. The topic "New to Navision" doesn't say anything about your problem, better would be something like "Don't know how to hide report details".

Hi again,

What can I say! Thanks very much indeed...tried this out, and after a couple of missed attempts, got it working, hopefully answers my colleague's request perfectly.

What a fantastic forum.
Cheers
Steve

Savatage

SteveB wrote:

What a fantastic forum.
Cheers
Steve

Indeed \:D/

Kowa

SteveB wrote:

I posted my question in the 3.7 forum, so I thought that was it?

The "Navision" Forum is about Version 3.70 and newer , so there are lots of posts concerning Version 4.0. and 4.1. Sometimes even the applied hotfixes are necessary.

SteveB

Kowa wrote:

SteveB wrote:

I posted my question in the 3.7 forum, so I thought that was it?

The "Navision" Forum is about Version 3.70 and newer , so there are lots of posts concerning Version 4.0. and 4.1. Sometimes even the applied hotfixes are necessary.

Ah, ok, thanks for pointing that out, I'll bear it in mind next time I post.