New Sheet per Salesperson

Jet Reports Historic Posts

November 23, 2009 14:20

None

Hello,

I have created an Open Orders report that is grouped by salesperson. When it is printed, I want each salesperson's info on their own page/sheet. Any advice on how to accomplish this?

Thanks.

I am using Jet Reports 2009 with Microsoft Dynamics NAV 5.0 (SP1) and Excel 2003

Date Votes

2 comments

Jet Reports Historic Posts November 30, 2009 02:48 Official comment

It would be easier if there was an attached report…but try

=nl("Sheets","Salesperson/Purchaser","Code")
then have all your report lines filter on the Salesperson Code to that Cell.

Each sheet will be named according to the Salesperson Code

Comment actions Permalink
0

Jet Reports Historic Posts December 02, 2009 13:26

Thanks! It worked great!

Comment actions Permalink

Please sign in to leave a comment.