Topic Options
#5034 - 06/10/05 07:39 PM Adagio Invoices - pass date to linked report
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
I have a Workspace with two Views. The primary one lists a summary of transactions from Adagio invoices history and is filtered by date (using Andrew's suggestion of using hidden columns for the starting and ending dates).

A link opens a second View that lists details on those invoices that meet the link criterion (one of the optional fields). However, this View is not filtered by date unless I put the same date columns and filter in it. This means that every time I double-click on a link, I have to re-enter the dates.

Is there any way to make the subsidiary View inherit the same filter criteria as the primary one?


Top
#5035 - 06/11/05 11:20 AM Re: Adagio Invoices - pass date to linked report
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Ralph Allan,

No, but that's a good suggestion.

Why aren't you linking on the document number though to display the details?


Top
#5036 - 06/12/05 12:37 AM Re: Adagio Invoices - pass date to linked report
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
In this case, the client is a regional delivery/hauling compnay. The optional field contains the driver ID. Since several "drivers" may be involved in one waybill, that is stored with the detail lines to allow distributing the amounts among the drivers.

The report takes the various revenues by driver with a detail report for each driver and a summary to enter into payroll. So I have to select on the optional field.

It looks like a job for Crystal Reports.


Top
#5037 - 06/12/05 10:33 AM Re: Adagio Invoices - pass date to linked report
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Ralph Allan,

Thinking about this, there is no date to "filter on" in the line details, so that wouldn't work. However, there's a feature in the next release of GridView that may help out here.

Expect to see a new release "shortly".


Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Hugh), 205 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14492 Topics
70766 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31