May 26, 2010 at 6:10 am
Hi team of experts,
Can you please take at the code my SSRS is generting.
The date values are all messed up. In other words, I am not sure why ID is prepended to the value.
So, instead of a value of 6/29/2009, I am getting ID06_26_2009. The rest are that way.
Is there a way to remove the ID from all the values?
Better still, is there a way to instruct SSRS to display value from <DataField>....</DataField>
as opposed to value from
Fieldname="..."
Please advise.
The code is too long. That's why I didn't paste it here.
Please advice.
Here is the code and thanks a lot.
<DataSets>
<DataSet Name="FIB">
<Fields>
<Field Name="IncidentType">
<DataField>IncidentType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ID06_26_2009">
<DataField>06/26/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID07_03_2009">
<DataField>07/03/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID07_17_2009">
<DataField>07/17/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID07_24_2009">
<DataField>07/24/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID07_31_2009">
<DataField>07/31/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID08_07_2009">
<DataField>08/07/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID08_14_2009">
<DataField>08/14/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID08_20_2009">
<DataField>08/20/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID08_28_2009">
<DataField>08/28/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID09_04_2009">
<DataField>09/04/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID09_11_2009">
<DataField>09/11/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID09_18_2009">
<DataField>09/18/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ID09_25_2009">
<DataField>09/25/2009</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="Year_to_Date">
<DataField>Year-to-Date</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
June 9, 2010 at 7:23 am
I have seen this before as well. It has something to do with special characters or ALL numbers field names. Unsure what the issue is w/ it though. Are you trying to grab the name of the field for some reason?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply