Thanks to all who attended today's OpenText Support Community Event: Customer Contributions to Knowledge Program.

A recording of the event and the next steps to start your contributions can be found here:

Customer Contributions to Knowledge Presentation

Let's get started!

Display Data Source name in report

Hi there,

I have 3 Data Sources (Development, Acceptance and Production) and I want to display in my report which Data Source I'm using. This to prevent I'm not deploying a report to Production while the Data Source is still on Acceptance. How can I do this?

Thank you.

Best Answer

Answers

  • edited July 9

    To display a data source name on a report, do the following:

    • On the Data Explorer tab, add a report variable named something like "dataSourceName".
    • In the beforeOpen event of the data source, add code like: vars["dataSourceName"] = this.getName();
    • Drag the report variable to the layout and drop it. A data element will automatically be created to display the value.

    If there are multiple data sources on a single report, follow the instructions above for each data source and create visibility expressions for the data elements that display the names to control which name(s) are displayed.

    Jeff F.

     

    Customer Support Engineer I

    Website: www.opentext.com

     

    emailsupport-logo-opentext.gif

     

     

     

Sign In or Register to comment.