Report Filter Validation

Pratap Singh shared this question 1 year ago
Answered

Hello,

Is there any way to apply validation to Report Filters?

Consider an example: I am using a single view to fetch Sales and Purchase Data based on the view cheated few reports and Applied filter to differentiate Sales and Purchase Data(based on a particular columns value). Now reports bring data based on that static filters data but filters have both Sales and Purchase data. Is there any way to apply validation to Filter so I can only see filter values for Sales if running sales report and Purchase if running Purchase reports. Or i need to create a separate view of Sales and Purchase?

Comments (3)

photo
1

Hi Pratap,

The only way I can think of to do this will be to use custom query filters. This way you can have a set query for all of your purchase reports and another for your sales reports.

Does this sound like it will work?

Regards,

Nathan

photo
1

Thanks for your response.

photo
1

No problem! I am going to close this for now, but let me know if you have any other questions.

Nathan

photo