Customizing reports, it would be great if I could get the Preview (“Run”) button to work in MS Report Builder.
I’m assuming if it’s possible I first need to get a connect to the SQL Server Report Service.
We are hosted on Azure cloud with Epicor
You will not be able to get access. But Epicor did provide the Generate for Design feature to do similar to what you are asking. Look up the generate for Design in help, follow the steps, and you will be good.
1 Like
That looks a lot more complicated than my current approach:
-
Download files to local hard drive using Report Style Maintenance
-
Open in MS Report Designer
-
Make a change in MS Report Designer and save
-
Use Report Style Maintenance to Upload the files (time passes…)
-
Test using print button on a form, print for PDF preview (time passes…)
<< repeat steps 3-5 until satisfied >>
It’s just kind of a bummer that the intention with the SSRS report building system is to be able to toggle between design and runtime views of the report…that’s what the button is for in MS Report Builder…but you need to have a connection from the report builder to the report server…which for some reason is not allowed for the Epicor hosted environment.
Just try it. Once you do it a few times you will find its not that bad. And its a million times better than not being able to preview without publishing which is the way it used to be.
1 Like