How to dispaly a report in two different ways depending on t

anton1987

Hi everyone.

Hope you are all well

How to dispaly a report in two different ways depending on the filter selected.

I have created a report in NAV and want it to filter in two different ways.

First if I select a boolean called "SortByVendor" then I would like it to sort by vendor and place the data in vendor groups.

Secondly If I select a boolean called "SortByProdOrderNo" then it needs to sort by product order no and it must not group by vendor..

I have no idea how to do this.

Snoopy

I know, that's not of great help, but why not use two reports?

anton1987

Hi Snoopy

Unfortunately the compnay I work for has a certain standard.

And because of this I have been sort of forced to create one report with two different sorting methods

Snoopy

If this is a practical solution:

use Setcurrentkey(

---

), depending, what the user has chosen
define a global variable (your record) as temporary
transfer the data into the temporary record
define the sections as integer

......

But now I have another idea, look at report 111 or another Top 10 report.

anton1987

Hi Snoopy.

Thanks so much. SetCurrentKey seems to work perfectly.

You're a legend. Thanks Man

anton1987

Hi Again

Is there a way to create group totals in c/al.

Snoopy

Look at CREATETOTALS and TOTALSCAUSEDBY

anton1987

Thanks Man.

suppose you can see that I am new at NAV.

Thanks so much for all the advice

DenSter

If I were you I would ask for three things:

• the training material for the two development classes
• a copy of the product disk, so that I can get to all the documentation in the Doc folder
• permission to order David Studebaker's book