SSRS core reports modification - E10

Yahoo Archive
1
All SSRS Reports in E10 use a built in Data Set of Dynamic SQL bit. Uses a tableguid param on the report to excecute the appropriate query against the generated tables

InvcHead_GuidParam

You have to modify the DataSet on the report to look at or pull from your new / changed tables.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Jul 9, 2015 at 11:36 AM, henry_czyz@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>I got that. Problem what I have is query modification. We did few report modifications using sub-reports. Unfortunately sub-report cannot be added in header, so we have to modify query. <br>All core reports are using shareddatasource and query with T parameter so I have some trouble understand logic. <br><br><br>thanks<br><br><br>henry</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

2
Hello,

Anyone modified core reports (like Traveler, Invoice Form, Order Form etc). in E10 ?
I'd like get some info about it.


thanks

henry


3

What are you looking for?  All reports are customizable.

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, July 09, 2015 8:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] SSRS core reports modification - E10

 

 

Hello,

Anyone modified core reports (like Traveler, Invoice Form, Order Form etc). in E10 ?
I'd like get some info about it.


thanks

henry

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
4
If you have embedded Education the SSRS training has an example of modifying an existing report.  If you don't check with your CAM they may be able to get the manual for you.  I think someone has a YouTube video on modifying reports.

You basically copy the RDD, copy the reports to the customReports folder mimicking the existing folder structure.  Create a new Report Style pointing to the copies and the new RDD.  Test it, this will still be the standard report but shows that all the setup is correct.  Modify the RDD if needed.  Then using Report Builder modify the report.  If you are adding a field you will need to do some hand editing of the query statement to add the new fields.

All movement of reports has to be done from either the SSRS report manager or Report Builder. Regardless of the use of the word "folder" there is no directory outside of SSRS, everything is inside in the Report database.

Make sure you make copies and never touch the original.  That way you can always go back to it to see if it is an Epicor issue or something you added.



Jim Kinneman
Encompass Solutions, Inc.
5
I got that. Problem what I have is query modification. We did few report modifications using sub-reports. Unfortunately sub-report cannot be added in header, so we have to modify query.
All core reports are using shareddatasource and query with T parameter so I have some trouble understand logic.


thanks


henry