Adding filters to System reports

[Samcox]

i know how to do this for a BAQ report but im not sure if you can do for system reports?

i have duplicated the report, im looking to add a new filter to the report but unsure how to do this

[itsme (Rhythem Prajapati)]

What sort of filter you want to pass?

[Samcox]

To be able to filter by territory

[aarong (Aaron Gulley)]

Use callContext

Do a left outer join on the end of your report to the callContext table and add these fields to your report screen.

@ckrusen has a guide around here somewhere…

[ckrusen (Calvin Krusen)]

This one?

Report Parameters Help

You don’t need to add anything to the RDD, because the CallContextBPMData table is inherent to all RDD’s. We don’t use CC’s so I did a test with another form - the Material Transaction Detail. While this has a start and End date, I can add a date field and limit the report to only show records between the native Start date and My date. [image] Then in the Report’s RDL I changed the query for the main table (PartTran in my case) [image] And added the Query field to the dataset’s properties…