I just started using Crystal Reports (9) for the first time today, please bear with me. I'm still stumbling around a little.
I have a report with a Cross-Tab based on a rowset returned from an SQL Server stored procedure. After formatting everything the way I wanted, I realized I needed another column (to replace my column headings in the Cross-Tab). So I modified my SP to add it, but I can't make Crystal Reports see the new column!. I've done every sort of refresh I can find. I even deleted the SP, hit refresh, then added it again and hit refresh again.
I could delete the Cross-Tab and re-add it, but I'd have to reformat everything and that's sucky and I would like to know the right way, anyway.
How do I make the report see the new column so I can work with it?
-E²
P.S. I will say that while I think I'll like Crystal Reports once I get used to it, I'm not initially impressed with the way things are laid out. I was looking for straightforward properties, thinking the Expert thingies were Wizards, which they sort of are and are not. I ran into a few problems, for example, Borders on a Cross-Tab aren't Borders and part of Format, no, they're Grid Lines and only accessible through the expert!
-------------------------------------
A sacrifice is harder when no one knows you've made it.
I have a report with a Cross-Tab based on a rowset returned from an SQL Server stored procedure. After formatting everything the way I wanted, I realized I needed another column (to replace my column headings in the Cross-Tab). So I modified my SP to add it, but I can't make Crystal Reports see the new column!. I've done every sort of refresh I can find. I even deleted the SP, hit refresh, then added it again and hit refresh again.
I could delete the Cross-Tab and re-add it, but I'd have to reformat everything and that's sucky and I would like to know the right way, anyway.
How do I make the report see the new column so I can work with it?
-E²
P.S. I will say that while I think I'll like Crystal Reports once I get used to it, I'm not initially impressed with the way things are laid out. I was looking for straightforward properties, thinking the Expert thingies were Wizards, which they sort of are and are not. I ran into a few problems, for example, Borders on a Cross-Tab aren't Borders and part of Format, no, they're Grid Lines and only accessible through the expert!
-------------------------------------
A sacrifice is harder when no one knows you've made it.
![[sad]](/data/assets/smilies/sad.gif "[sad] [sad]")
"Reread schema" would be intuitive. Lots of things would be!