0 Replies Latest reply: Apr 19, 2012 12:05 PM by brittney holmes RSS

    Load Script - SQL Ordinal Position rather than SQL Column Name

      I'm trying to minimize the number of reports that I have to manage by giving clients the exact same report and just wiring the report to each client db (one glove fits all).  However, clients have the option of defining a few SQL column names, which may or may not be different for each client.  For example, one client may want to name ColumnA "Manager" another client may want to name ColumnA "Director", while another may want to name ColumnA "Supervisor".  The position of the ColumnA will always stay the same.  With that, is there a way in QV to pull in the ordinal position of a column from SQL?  I'm trying make this report as dynamic as possible.