Adding the SQL View in SSRS Report Designer

Dhanalakshmi · June 21, 2019, 6:52am

Can anyone help on adding the SQL View in Epicor base SSRS Report from Report Builder.

If anyone has done this please share the information…

Regards,
Dhanalakshmi…

Vishal.Sharma185 · June 21, 2019, 7:28am

Hi, Let me know the issue or you can skype me at vishal.sharma185

Dhanalakshmi · June 21, 2019, 8:55am

When we are adding the SQL View in the report builder getting an error object not found…

Jason_Woods · June 22, 2019, 2:05pm

Are you connecting directly to the Epicor Database or are you using the report dataset as intended?
If you aren’t using the report dataset, you are not following Epicor Best Practice (FYI). If you are, you only have to modify the SQL statement to add fields or tables.