485
I have Dynamics GP 2010 with SQL Server 2008 R2. Both are on same machine.
I have created 2 companies (PAK1 and PAK2)on the same machine, and entering data.
Web Reports have been created for PAK1 but there are no web reports for PAK2.
Now I need to create few web reports for PAK2 (2nd company).
As I need to give Data Source in Report Properties? and also Reporting Services is only configured with PAK1 (company1).
How I'll do that, any hint please?
*This post is locked for comments
you are welcome Adeel :)
Thank you Nataraj, you were right. The issue was resolved by using the Setup CD of GP Server.
I got the Sql Server reporting Services wizard there, after installing that it ask me for the company and finally I got my issue resolved. Thank you so much :)
Hi Adeel,
Since your are using GP2010, i guess this can be done in GP.
1) Open GP Test server.
2) Go to GP installation setup and click install Sql Server reporting services wizard.
3) there must be an option of configure. please do the reconfiguration
4) please choose PAK2 company and check select all option to deploy the reports.
5) once it is successful, you can proceed the same steps to Live.
Hello Nataraj,
Yes, SSRS reports.
I have checked the Reporting Tools Setup
But seems like you are talking about GP 2010 R2 and unfortunately I am using simple GP 2010 :)
so Didn't find options as you said.
In Reporting Tool Setup there is tab DATA CONNECTIONS
but under this tab DATA CONNECTION DEPLOYMENT is fully greyed out / disabled.
Cannot CHECK any option.
Available options are:
Enable data connection deployment
Deploy data connections for all existing companies
but both options are disabled/greyed
and RUN DEPLOYMENT button is also disabled / greyed.
One company is still running SSRS reports.
Please guide me if possible.
Warm Regards,
Adeel Ahmad
Hi Adeel,
Web Reports as SSRS Reports?
if it is SSRS reports, then go to Tools-->setup-->System-->Reporting Tools Setup to open the setup screen.
expand the deployment options node and check the PAK2 company and click deploy.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (