Friday, March 9, 2012

problem with dynamically created RDL files and reports

Hello,

I have a strange problem with a dynamic created RDL resp. dynamic created report.

I have followed the programming tipps on the microsoft site to create programmatically a RDL file and this RDL file is accepted by the reporting server. But when the report is rendered out of that RDL some fields are somehow modified. In one field after the first line (which holds the correct value) all values in the following rows are cut after the fifth character. Other fields contain every now and then strange signs like a caret...

My report items in the RDL e.g. look like this:

- <TableCell>
- <ReportItems>
- <Textbox Name="Details_PBN">
- <Style>
<TextAlign>Left</TextAlign>
<FontFamily>Courier New</FontFamily>
- <BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Value>=Fields!PBN.Value</Value>
</Textbox>
</ReportItems>
</TableCell>

Do I have to do some datatype conversion in my RDL when I create it or how could this be possible?

Any help appreciated!!

I solved it myself. I write the solution down here, perhaps someone else has the same problem.

The data I that is in included in the report is queried from an oracle database. I also created the datasource for the report dynamically and there I used the provider "Oracle". This seemed to cause the problems, because after I changed it to OleDB and uses Provider="MSDAORA.1" as provider in the connection string, it worked like intended.

so... Code on, folks!!!

No comments:

Post a Comment