ActiveReports 6 is built into a software package that my client has adopted. The software does not allow me to add parameters via the element tree. I can add parameters in the ReportStart event and the user will be prompted for a value when running the report. I need to use this parameter value to “filter” the recordset before the report’s group headers are formatted. I would append the parameters to the data control, but I don’t believe I can edit the data control via the software package I am stuck with. If I filter the records in the DetailFormat event, the group headers are already printed and the cross section boxes are sized according to the unfiltered report. The FetchData event is automatically formatted as follows:
Function ActiveReport_FetchData(ByVal EOF as Boolean) as Boolean ActiveReport_FetchData = EOF End Function
Will the FetchData event fire for every record of a bound report? If it does, I could write a conditional statement that would toss out the values that I don’t want based on the parameter I declare in the ReportStart event. How would I tell ActiveReports 6 to toss out a record in the FetchData event? I can’t rightly set it equal to null, as this would still cause the record to print.
More than anything, I would love to be able to query the data myself without the sub-par GUI that this particular software has wrapped ActiveReport6 in. I have full access to the server that the data is stored on, but I cannot find any mention of ActiveReports6 or an SQL server with the data I want on it. I don’t know where it is running or from what location it gets its data. What is the traditional implementation of ActiveReports 6? What sort of structure does it rely on?