Is there any way to enter a key range in the report writer (other than generating the report from a query)?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages1
#2
Nomads / Re: Pass an argument to a grid cell query
December 16, 2022, 11:48:27 AM
I wanted to limit what shows up in the query based on the value of another column.
That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.
I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.
The Preset Value/Expression for the query cell is just equal to the string variable.
I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.
That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.
I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.
The Preset Value/Expression for the query cell is just equal to the string variable.
I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.
#3
Nomads / Pass an argument to a grid cell query
December 15, 2022, 03:47:11 PM
How do I pass an argument to a query which is attached to a grid cell?
Version 2020
Version 2020
#4
Registration and Setup / Configuring a Pro system to act like Base system
June 26, 2018, 05:20:44 PM
Is there some way to set up the Pro system so that it behaves as a Base system?
Sometimes I have used a Pro feature without realizing it and I only discover my mistake when the program doesn't work on the client's Base system.
Sometimes I have used a Pro feature without realizing it and I only discover my mistake when the program doesn't work on the client's Base system.
#5
Wish List / Re: Add ability to suppress locked background color of Locked grid cells
June 26, 2018, 04:40:57 PM
Isn't it already possible to set the color with 'BACKCOLOR$ ?
Pages1