count of columns and get column names in fetched dataset
Options
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
-
skorada,
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#16107798Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax