Howdy all -
I can't seem to find a clean answer so I thought I'd throw this out to the forum. We have a report for our Development report called the "Development Snapshot" that details a lot of info from last year against the current year. I added a field to it (via the Expense tab in the Campaigns module) in order to display a goal. Later a requested change forced me to use that same field (which only has one data field) in a different manner so what I did was use the data field for a money field that changes and needs math run on it (sums and such) and the notes field for the number that DOESN'T change (which is only text).
The issue I'm having is that SSRS seems "temperamental" in what field its wants to display at any given time. See the attached image - The first image is when I took the field completely out of the report and simply put in "Goal here". It displays on each field properly. The second and third are when the goal field (the notes field from the expense tab of Campaigns) is used. Notice how different fields display each time. It simply is moody about which text it wants to display and which it doesn't.
My online searching has failed and I cannot find a solution. I thought I'd try here before I scrap the "goal" field altogether. Anyone got any ideas? I'd greatly appreciate any assistance if anyone else has run into this.
RJ
Hi Richard,
What is the stored procedure returning for those rows?
--Gawain
Ah, well. Far beyond my area of expertise: the only other thing I would guess would be something about the size of returns on those rows confounding the formatting of the SSRS template.
sometimes you will have to explicitly convert fields to the right type. did you use convert()?