Mr. Jim: Thanks for the Embedded Education suggestion.
I don't believe we have that license - but I'll bet I could sign up for the classes on that.
Do you think they have V10?
I already have the V9 SSRS and have done a number of reports in 9.xx.
V10 appears to be a new animal - new rules.
Thanks for the suggestion,
DaveO
I would like to modify an existing V10 SSRS report (SalesOrderAcknowledgement). I installed the 2012 "Data Tools" and I open the SOForm - however when I try to update the Data Sources I don't see where the report data exists.
In version 9 SSRS the datasource was at http://(server)/EpiSSRSPortal/DataSource/(company)/(epicor_userid)/(reportname).xml . I tried looking for that info in V10 however I have not found it.
If I want to update and existing SSRS in V10 SSRS how can I do that?
I see a reference to a "SharedReportDataSource.rds" however I could not find that type of file on my server (except in the SSRS folder).
If anyone could offer some help here I would certainly appreciate it.
Thanks,
DaveOlender (DaveO)
PH: 651-246-3281
On Wed, Sep 3, 2014 at 3:06 PM, daveolender@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p><span>I would like to modify an existing V10 SSRS report (SalesOrderAcknowledgement). I installed the 2012 "Data Tools" and I open the SOForm - however when I try to update the Data Sources I don't see where the report data exists.</span></p>
In version 9 SSRS the datasource was at http://(server)/EpiSSRSPortal/DataSource/(company)/(epicor_userid)/(reportname).xml . I tried looking for that info in V10 however I have not found it.
If I want to update and existing SSRS in V10 SSRS how can I do that?
I see a reference to a "SharedReportDataSource.rds" however I could not find that type of file on my server (except in the SSRS folder).
If anyone could offer some help here I would certainly appreciate it.
Thanks,
DaveOlender (DaveO)
PH: 651-246-3281
</div> <div style="color:#fff;min-height:0;"></div>
Mr. Jose: Thank you for the reply.
I went into the web SSRS and found the "SharedReportDataSource".
When I open the properties - you are right it appears to be pointing to my report server. i.e.
Data Source=ERMC-SQL1;Initial Catalog=ERP10_Reports;MultipleActiveResultSets=True
That at least points me to the server and DB - however any clue what table(s) to look for?
I wonder if this Is this the proper way to develop SSRS in Epicor? Or is there a shortcut i.e. print as XML and use that as a datasource?
Any clues greatly appreciated.
DaveO
where @Table guid is a param of the report. IF you want to add data to your report you will have to modify the RDD as you did before, this will add fields to Table_Guid which you'd then have to add to ssrs by modying the Select statement to include your new fields.
On Wed, Sep 3, 2014 at 3:38 PM, daveolender@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p></p><p>Mr. Jose: Thank you for the reply. </p><p><br></p><p>I went into the web SSRS and found the "SharedReportDataSource".</p><p><br></p><p>When I open the properties - you are right it appears to be pointing to my report server. i.e.</p>
 Data Source=ERMC-SQL1;Initial Catalog=ERP10_Reports;MultipleActiveResultSets=True
That at least points me to the server and DB - however any clue what table(s) to look for?
I wonder if this Is this the proper way to develop SSRS in Epicor? Or is there a shortcut i.e. print as XML and use that as a datasource?
Any clues greatly appreciated.
DaveO
</div><div class="ygrps-yiv-2134498997"> <div style="color:#fff;min-height:0;"></div>
