I have been scratching my head at this for quite a bit this morning, and even though it's a lower priority project, it just bothers me that it feels like I'm that close, and can't figure it out.
Long story short, I have a table that pulls data from a SQL query that executes a stored procedure. This table has all of the data I need, but unfortunately, the stored procedure casts all the values as varchar data type. I am trying to allow a chart to plot values from this table, but I need to get those data into a numeric form before the chart can handle it properly.
I'd prefer not to mess with the database or stored procedures if possible. I am wondering if there is any way within the Designer to create that dataset and then somehow modify it to change the column data types to numeric ones. My first thought was to do something like creating the base dataset as a custom property of the root container, and then query that using CAST AS statements to convert the datatypes, but I'm not sure that's possible.
Any workarounds? I have seem some similar threads that show some python codes, but I'm not sure how to set that up to get it to output to a table component.