Data not Exported to CSV/XML

I have a table where one of the columns is hidden based on the following criteria:
=IIF(Fields!ChildIsEmpty5.Value, true, false)

If the Fields!ChildIsEmpty5.Value is false (so the column is showing), and I export the report to CSV or XML, the data in that column is not exported.

Is there another property I can select to get this data to be exported? Or is this functionality not supported?

Thanks for any help you can provide!
Jessica

Jessica,

This functionality is by design. Fields where visibility (hidden) is expression-based are not output to CSV/XML by default.

If you always want this column present in the CSV/XML output, you can set DataElementOutput property of the column to 'Yes'(or in Data Output tab, set data output to 'Yes')

Thanks!

|||But what to do if i need to show or hide object, depending on some condition(expression) in export also?|||

Still not working.

I selected the report item (textbox), right click, select properties, data output tab and I set the output from auto to yes. This item still does not show up in the xml output file.

thanks,

Helmut.

Data not Exported to CSV/XML

I have a table where one of the columns is hidden based on the following criteria:
=IIF(Fields!ChildIsEmpty5.Value, true, false)

If the Fields!ChildIsEmpty5.Value is false (so the column is showing), and I export the report to CSV or XML, the data in that column is not exported.

Is there another property I can select to get this data to be exported? Or is this functionality not supported?

Thanks for any help you can provide!
Jessica

Jessica,

This functionality is by design. Fields where visibility (hidden) is expression-based are not output to CSV/XML by default.

If you always want this column present in the CSV/XML output, you can set DataElementOutput property of the column to 'Yes'(or in Data Output tab, set data output to 'Yes')

Thanks!

|||But what to do if i need to show or hide object, depending on some condition(expression) in export also?|||

Still not working.

I selected the report item (textbox), right click, select properties, data output tab and I set the output from auto to yes. This item still does not show up in the xml output file.

thanks,

Helmut.

Data mapping and Importing app for SQL server

Hello,

Our company often receives data from outside sources to add to our application. This data is usually provided to us in Excel, CSV, XML, etc. The files that we receive usually have different columns from the columns in our database, so we have to map these columns to our table structure to import.

I'm looking for an application that will easily allow me to load up the data file (whatever type it may be), expose the columns in the data file, allow me to map these columns in our SQL server, then import the data. I know that this can be done as DTS, however I'm looking for alternatives. Does anyone have any recommendations?

Thanks in advance.

I just dont have a solution to your post but i have the same problem. I just want to get notifications on reply event of this thread. Hopefully some one will answer you and i will benefit.

Data Load Problem

Hi all,

I have some data in a CSV file that looks like this:

<Column Name1>, <Column Name2>, <Column Name3>, <Column NameN>
<Column Value1>, <Column Value2>, <Column Value3>, <Column ValueN>
<Blank Line>
<Column Name1>, <Column Name2>, <Column Name3>, <Column Name4>, <Column NameN>
<Column Value1>, <Column Value2>, <Column Value3>, <Column Value4>, <Column ValueN>

The rub is that I don't know how many columns I am going to have but each <Column Name> has a <Column Value>.

I need to load the data into different tables based on the <Column Name>.

Any ideas?

Thanks for all the information this forum has very helpful!!!

What would really be nice is that if I could load these into a hash table where the key was <Column Name> and the value was <Column Value>.

Anyone ever done anything like that?

Thanks!