Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have monthly reports. To load the data in pivot table and graphs I have called stored procedure of sql server in the script file.
The stored procedure has the logic to process the data for last month which returns the result.
How can I refresh the data in .qvw file (after publishing) at the start of each month without any redeployment.
Schedule the reload on the server at the start of each month.