import Data from XML without funktion

Hello,

i have great problems with the xml connection.

i get data from sql server into a xml file. generate a dashboard and use the connection manager.

but when i preview or export the file it wont get new data, not on loading or refreshing per click.

if i use the preview xml data format and copy it into the xml file, nothing happens.

Is here anyone to help me?

Do you have some vb code wich will create the right format for xml using the sql server?

Sorry for my bad english.....

Andreas