Related To Reports
Hi, I have 3 questions related to Reports 1. When you create a report and if the report filter field is set to Ask the user while firing the report, then is it possible to set any one ...
Forum Discussion
The answer to #1 and #2 is no.
I don't understand the question in #3 so I can't answer that.
An alternative to #1 & #2 is to create helper table with just 1 record in it. Say the table is called Report runner. When you create a single record it will be [Record ID#] of 1.
Then make a relationships to your data table based on a formula reference field called [Link to Report Runner (=1)] with a formula of 1.
Then using relationships get your <ask the user> fields organized along with any Conditional drop downs, and then look up those down to the data table. Make a report that filters on those looked up selections.
Put a report link on the Report Runner record.
So the user will edit the Record ID#] = 1 and on save display the embedded report in view mode.
'
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I don't understand the question in #3 so I can't answer that.
An alternative to #1 & #2 is to create helper table with just 1 record in it. Say the table is called Report runner. When you create a single record it will be [Record ID#] of 1.
Then make a relationships to your data table based on a formula reference field called [Link to Report Runner (=1)] with a formula of 1.
Then using relationships get your <ask the user> fields organized along with any Conditional drop downs, and then look up those down to the data table. Make a report that filters on those looked up selections.
Put a report link on the Report Runner record.
So the user will edit the Record ID#] = 1 and on save display the embedded report in view mode.
'
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
Point No 1
I don't need one single record, what i am trying to say here is that I would like to have one option to be set as default out of the multiple options available in the ask the user and if i need to change i should be able to select the desired one.
Point No 2-Example
a. I have a field called Type as Multichoice which has 2 options A and B
b. I have another field called Name.
I create one record with Type as A and Name as ABC
I created second record with Type as B and Name as XYZ
Now when i create a report with Type and Name both as Ask the user. So when i select Type as A the Name should get filtered on the basis of Type A which is not happening as it shows ABC and XYZ both in the drop down where as it should show ABC only which is of Type A
I hope with the above example you will have more clarity as to what i am looking for.
Regards
Gunsham
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------
Point No 1
I don't need one single record, what i am trying to say here is that I would like to have one option to be set as default out of the multiple options available in the ask the user and if i need to change i should be able to select the desired one.
Point No 2-Example
a. I have a field called Type as Multichoice which has 2 options A and B
b. I have another field called Name.
I create one record with Type as A and Name as ABC
I created second record with Type as B and Name as XYZ
Now when i create a report with Type and Name both as Ask the user. So when i select Type as A the Name should get filtered on the basis of Type A which is not happening as it shows ABC and XYZ both in the drop down where as it should show ABC only which is of Type A
I hope with the above example you will have more clarity as to what i am looking for.
Regards
Gunsham
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------
- I understand what you are wanting. Quick Base will not do that. So rather than just say "no way", I offered a suggestion above how to get similar behaviour you are looking for with a different approach.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
