Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I come across a strange problem.
I've 4 numeric fields in the SQL Server Database. When I do Select * from database and show those fields in Straight table as dimensions, they are exporting as numeric columns in Excel file.
Now I've created a qvd file of the same data, when I load same fields from qvd file listing all the column names in the Load statements, the problem occurs.
This time when I show the same set of fields in Straight Table, they are being exported as string columns.
I'm not doing any transformation on these columns neither there is any variable defined which sets the number format.
So, not sure why the datatype of these columns getting changed.
Now, I've tried Load * from qvd file. and it's working absolutely fine. In this case all the fields being exported as numeric.
Any idea why this is happening and how do I avoid this.
Thanks,
AVB
Solved this.
Solved this.