count of columns and get column names in fetched dataset
Hi,
I am trying to generate reports(table) programatically using birt runtime api's(kind of Adhoc reporting ), where the user can enter any SQL query , application should connect to the DATASOURCE and fetch the DATASET based on the query the end user is going to enter.
here is where i am facing issue, after fetching the DATASET I am not being able to fetch the number of columns present in the fetched DATASET.I have tried using getColumnMetaData but could'nt succeed.
can any one please guide me to come out of this problem, all i have is OdaDataSetHandle with which i must fetch the count of columns and column names(i.e, all metadata regarding the DATASET).
Thanks in advance.
I am trying to generate reports(table) programatically using birt runtime api's(kind of Adhoc reporting ), where the user can enter any SQL query , application should connect to the DATASOURCE and fetch the DATASET based on the query the end user is going to enter.
here is where i am facing issue, after fetching the DATASET I am not being able to fetch the number of columns present in the fetched DATASET.I have tried using getColumnMetaData but could'nt succeed.
can any one please guide me to come out of this problem, all i have is OdaDataSetHandle with which i must fetch the count of columns and column names(i.e, all metadata regarding the DATASET).
Thanks in advance.
0
Comments
There are few posts out there on working with column counts at report run time. I did some work for a question at StackOverflow, but could not get resolution. You might take a look at what is documented there and see if it gives you any help.
http://stackoverflow.com/questions/11672583/why-is-my-crosstab-being-cut-off-in-excel/16107798#16107798