Forum Discussion

GunshamLakhiani's avatar
GunshamLakhiani
Qrew Cadet
5 years ago

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 default value which is present in the list.
2. Before firing the report If there are multiple fields which are set as Ask the user then is it possible to filter a field lookup
    on the basis of the previously selected field.
3. After a report is displayed if you want to filter data on the basis of any of the filters, is it possible to keep those filters
    intact so that we can fire the report thru the URL or display the report on the App Page instead of firing the same again
    and again and then applying the filter.


Regards
Gunsham

------------------------------
Gunsham Lakhiani
------------------------------
reports and charts

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      5 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        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
        ------------------------------
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    For number 3 if I am understanding you correctly, filter the report as you want with Dynamic Filters and then copy the URL and when you visit that URL it should land you on the report with the same filters applied. The URL changes constantly based on what you have selected. I am not 100% sure that will work for displaying a report on a home page unless you embedded the entire site with an iframe. But you could test it. Making it a button would for sure take them to the report with filters applied.
    • GunshamLakhiani's avatar
      GunshamLakhiani
      Qrew Cadet
      5 years ago
      Hi Austin,

      Yes, your understanding is correct but i do not know how to embed the site and how to create a button. For the button will it work with the Widgets Button on the Customise Page?


      Regards
      Gunsham

      ------------------------------
      Gunsham Lakhiani
      ------------------------------