DataSet Variable
Hi,
I currently have two ADO queries on a data module in RAD studio. I have connected them to fast reports through TfrxDBDataset. The one is usernames and their ID's, the other is an audit trail table that links to the user table through the ID field.
Is it possible to create a dialogue in fast reports with the username dropdown, then change the query in the audit dataset to filter only to the selected user.
I have seen an example by doing it with the ADO components inside fast reports, however I would like to do it with the ones on my data module in rad studio since I don't have to use ODBC then for the database connection.
Any help would be appreciated or a link to another post if there's one already.
Thanks
I currently have two ADO queries on a data module in RAD studio. I have connected them to fast reports through TfrxDBDataset. The one is usernames and their ID's, the other is an audit trail table that links to the user table through the ID field.
Is it possible to create a dialogue in fast reports with the username dropdown, then change the query in the audit dataset to filter only to the selected user.
I have seen an example by doing it with the ADO components inside fast reports, however I would like to do it with the ones on my data module in rad studio since I don't have to use ODBC then for the database connection.
Any help would be appreciated or a link to another post if there's one already.
Thanks