Forum Discussion

AkankshaGrover's avatar
AkankshaGrover
Qrew Member
6 years ago

Dynamically Display a report in parent table from child table

I have a parent table X and a child table Y. I am trying to fetch a report from child table Y when the user selects a particular value in parent table X. Based on the value selected in X by user I nee...
Forms
reports and charts
Quick_BaseJunki's avatar
Quick_BaseJunki
Qrew Captain
6 years ago
Hi Akanksha, you could set up different forms with each of the reports you want to be able to display, then put a Formula URL button on your main form that dynamically chooses which form to display based on the value selected in X. Your users would then just need to 'press the button to display the report'.


var number FORMID = Case([X Value],"AAA",6,"BBB",7,"CCC",8,"DDD",9,1);

URLEncode(URLRoot() & "db/" & Dbid() & 
"?a=er&dfid="& $FORMID &
"&rid="& [Record ID#])


You'll just need to update the Case formula with your field and values for both the value selected in X and the ID numbers from you different forms. Also, don't forget to select "Display as a button".