Hi Samson,
Thanks for the update,
Yes,
we will be forced to change the data source connection string, which is in the
API controller in the OnInitReportOptions method. The report viewer will
preview without a prompt only if you use the data source connection string
programmatically.
Otherwise, you have to give the username and password
credentials in the connection string in advanced options and set the Authentication
Type to None. Please have a look at the below snap for your
reference.
SNAP:
Regards,
Arumugasami M.