Set excel data type [message #909358] |
Thu, 06 September 2012 22:31  |
Eclipse User |
|
|
|
Hello, I'm a college student and new to BIRT still learning all how to use it. I'm using it to make stock market reports for my investing club and I'm getting the raw data from my broker in excel format. When I set up the data source I use the excel as source option, obviously lol. There is an option that asks if I want to use the second row as data type. If I don't check this, the data comes in as "string" and I can't do anything with the data. The problem is I don't know how to say what type it is in excel on the second row. The data type is already set in excel to there respective types but that does not transfer over to BIRT so I have to use the second row as type. The data is just one column for the dates and the other four are OHLC. I tried just putting "date" above the dates and "decimal" above the OHLC columns but I get an error for unknown data type in BIRT. I'v been scouring the internet for the past two weeks trying to find a solution but to no avail. So in short I just need to know how to exactly state the syntax in the second row. Please help me. Thank you!
|
|
|
|
Powered by
FUDForum. Page generated in 0.04967 seconds