BAQ Report and Report Style in Kinectic 2021

[ckrusen (Calvin Krusen)]

@mvmoo

I use Sync Dataset in Report Style for update BAQ Report, but Kinectic 2021 doesn’t exist this button.

Consider yourself lucky. Pressing that button can cause more harm than help (more so with RDD based Reports).

You will have to edit the Query Expression in the reports RDL file (using SRS Report Builder). Add the ne field in the SELECT clause, then Add a Query field to the dataset.

Edit

See: the following for more details:

Adding new table from RDD to report builder

To add a little bit to what Calvin already listed… After adding the table/fields to the RDD, I usually preview the report with an archive period of at least one day and copy the guid from the system monitor for use in report builder “preview”. Then if my fields are not listed in the report builder dataset, I’ll explore the query expression, manually adding references to the table(s) e.g. T5, T6… (which you might find “interesting” the first couple times) after that adding entries to the fi…