I have some crystal reports that uses a viewer and Report.xsd as a schema for the data/field names that will be returned by my Stored procedures.
I have updated the SPROCs to add 3 new fields. Next I updated the .xsd with the name and type of new fields so that they are in sync. No errors when I compile.
Next I check out my CR Report, and when I try Verify Database, it says its already up to date and doesn't add new fields.
So since i know this is not true, under Field Explorer, I right click and choose Set DataSource Location. Choose Properties from under Report/report name, go under filepath, erase it, then am given a prompt for a dataset and select the same dataset. Now the fields are updated, but no data will show.
I know there is data because I test the SPROC in Mssql Manager and it returns a row with data in these fields...Is this a glitch or am I doing wrong? anything anyone suspects which can be causing this behavior? Basically, though, I just want a solution so I can done with these reports...
Thanks in advance.