Share
ReportNew (and amazingly inexperienced), PA Dev here ("Dev" also used very liberally).
I have a drop-down that I want to display choices based on a selection in a previous drop-down. There are a number of entries in the underlying table that are not presently appropriate, but I am not to delete those rows from the table as we may use them eventually (though this would immediately solve the issue). Not using Sharepoint lists in this case, but a DB connection.
I added a column to the table (is_active, type=bit), and would like to filter on that. I can always go into the table down the road and flip any is_active flags as needed. I am having issues trying to achieve this result.
Background:
columnvisuals - table that has the actual text (column_visual_name) I want to display
reports - table that has report ids & names, there is a drop-down (Dropdown1_2), that is the parent of the target drop-down
ReportColumnVisualAssociations - table that associates report_ids with the column_visual_ids (this has the "is_active" flag in it)
I currently have: Filter(columnvisuals, GUID(report_id) = GUID(Dropdown1_2.Selected.report_id))
This displays all of the column_visual_names associated with the report id chosen in the previous drop down, but I want to add the filtering a la "WHERE ReportColumnVisualAssociations.is_active=1". My inexperience is preventing me from writing this filter properly. Maybe I need to rewrite the whole filter instead of trying to tack an "AND" on the end?
Can anyone help?
All responses (
Answers (
397
