When you run a report from EG, it creates a static report, just an image of rows and columns. If you are publishing a report to Information Delivery Portal, then you want to directly access the source data, and use Information Maps and Web Report studio to build the report. That said, if it is a very complex report, you may be stuck.
So, is the data set upon which all this is based registered in the SAS metadata repository? That would be the first necessary step.
Once the data set is registered in the repository, you can then build an information map off the data set. This lets you create calculated columns, make joins among multiple tables, format column headings, etc. Information maps can only be built off registered data sets.
Next, use the information map as the data source for a report in Web Report Studio. Build the report that you want to display to your users from the information map. Save the report.
Finally, add the report to a portlet in Information Delivery Portal as either a report portlet (where the user will be able to see the report when they open the page) or as an item in a collection portlet.
There are a lot of concepts involved here - registering a data set in the metadata repository, information map studio, etc. However, this approach will result in a truly dynamic report directly linked to the source data set. Every change in the source data set will be reflected in the web report.
