Lasernet FO Connector 6 - Only the Field RecId Is Added to Replacement Report/Query

Fields are automatically loaded from the SSRS report when creating a replacement report (Query), but, in some cases, only the field RecId was added to the replacement report/Query.

This would require the fields to be added manually, as only the RecId fields are added automatically. This would result in tables that are not created properly in the Query wizard.

Another issue is caused by and/or fields not being created properly in the Query wizard.

Solution

Follow these steps for the current workaround for loading the fields into the replacement report:

1. Locate the SSRS report and select the Structure.

2. Either mark the field Active or click Save in case a new report was entered in the Report name.

2. Click Reload report fields, close the Structure, and click F5 to refresh and reload the Form.

3. Repeat step 1 and reopen the Structure.

4. Repeat step 2, click Reload report fields, and then click Yes when the following dialog appears:

Note

Any manual settings in the elements are set to their default settings when answering Yes to all, but should not be an issue as this report will be used for a replacement report (Query).

5. Close the Structure.

Creation of the Replacement report will now add the tables and fields from the SSRS reports in the Query wizard.