Gridview Upgrade - Adagio Accounting | Technical Support Forums

You are not logged in. [Log In] Adagio Home Page » Forums » General Discussion » Technical Support » Gridview Upgrade

Page 2 of 2

Topic Options

#29144 - 09/30/11 09:08 AM

Re: Gridview Upgrade [Re: Softrak Support]

Retired_Guy Offline

Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada

Hello Susan,

This Filter might run a little faster:

Code:

AND (
{Date} >= QUERYDATE("Enter START Date:", TODAY()),
{Date} <= QUERYDATE("Enter END Date:", TODAY()),
Left({Salesperson},5) =Left(QueryString("Enter LINDSY, KINGSN, LONDON", ""),5),
{Qty} <> 0,
{Amt} <> 0,
{Category} <> " BE",
{Category} <> " MC ",
{Category} <> "RCO",
{Category} <> "RCA",
{Category} <> " SH",
{Category} <> " ZZ",
{Type} = "L"         // select item lines only, skipping taxes and Misc charges.
)

You could also make the data entry easier with a calculated column for the Salesperson (say "Region"), like this:

Code:

IF(UPPER(TRIM(QUERYSTRING("Enter D, K or L for LINDSY, KINGSN or LONDON","K")))="D","LINDSY ",
IF(UPPER(TRIM(QUERYSTRING("Enter D, K or L for LINDSY, KINGSN or LONDON","K")))="K","KINGSN ","LONDON "
))
// The default will be "LONDON"

also, if you want to make sure that you are only asked a specific QUERY() question once, include ",1" as the third parameter, like this:

Code:

IF(UPPER(TRIM(QUERYSTRING("Enter D, K or L for LINDSY, KINGSN or LONDON","K",1)))="D","LINDSY",
IF(UPPER(TRIM(QUERYSTRING("Enter D, K or L for LINDSY, KINGSN or LONDON","K",1)))="K","KINGSN","LONDON"
))
// The default will be "LONDON"

If you create the calculated column, then your Filter becomes:

Code:

AND (
{Date} >= QUERYDATE("Enter START Date:", TODAY()),
{Date} <= QUERYDATE("Enter END Date:", TODAY()),
{Salesperson}={Region},
{Qty} <> 0,
{Amt} <> 0,
{Category} <> " BE",
{Category} <> " MC ",
{Category} <> "RCO",
{Category} <> "RCA",
{Category} <> " SH",
{Category} <> " ZZ",
{Type} = "L"         // select item lines only, skipping taxes and Misc charges.
)

Finally, to remove all the category tests, you might consider using the Inventory report group or one of the option fields to contain something identifiable for this collection of items.

_________________________
Andrew Bates

Top

#29147 - 09/30/11 09:19 AM Re: Gridview Upgrade [Re: Retired_Guy]
SusanTennier Adagio Maestro Registered: 02/22/08 Posts: 1247 Loc: Ontario, Canada	Thanks! This is a great help. _________________________ Susan Tennier TDL Canada Trenton, Ontario
Top

#29168 - 09/30/11 06:11 PM Re: Gridview Upgrade [Re: SusanTennier]
SusanTennier Adagio Maestro Registered: 02/22/08 Posts: 1247 Loc: Ontario, Canada	Hi Softrak Support, I assume you are aware that the the repeating of query prompts also occurs when you try to print the view. The query prompts repeat but the view doesn't reload thankfully. _________________________ Susan Tennier TDL Canada Trenton, Ontario
Top

#29169 - 09/30/11 06:24 PM Re: Gridview Upgrade [Re: SusanTennier]
Retired_Guy Adagio Master Registered: 03/16/99 Posts: 10504 Loc: Canada	Hello Susan, You can control when a View is calculated by settings in the Definition (Edit \| Definition) and by setting the Recalc order of the Workspace (File \| Set Workspace recalc order). I'm surprised you're actually printing the View, rather than sending it to Excel. Is there a reason for this process? _________________________ Andrew Bates
Top

#29175 - 10/03/11 06:18 AM Re: Gridview Upgrade [Re: Retired_Guy]
SusanTennier Adagio Maestro Registered: 02/22/08 Posts: 1247 Loc: Ontario, Canada	Hi Andrew, We print it and send it to our reps along with their pay cheques. No need to use excel. "Set Workspace recalculator order" is greyed out. Anyway, no issues. It's just an annoyance, however, the report is working fine. _________________________ Susan Tennier TDL Canada Trenton, Ontario
Top

#29176 - 10/03/11 06:50 AM Re: Gridview Upgrade [Re: SusanTennier]
Retired_Guy Adagio Master Registered: 03/16/99 Posts: 10504 Loc: Canada	Hi Susan, There is only "an order" when there are multiple Views in a workspace. For a single View, you can control when it is refreshed under Edit \| Definition. Thanks for information. _________________________ Andrew Bates
Top

Page 2 of 2

Previous Topic

Index

Next Topic

Moderator: Christa_Meissner