Hi:
I have made a few minor changes to a report and now one of the fields will not display in BIDS, IE, or Tessitura. I have tried placing it in another cell, renaming the field in the stored procedure, and nothing works. Other than rebuilding the report, does anyone have any suggestions?
Thanks, James
Pasting a couple of replies to this question in here that came through email but didn't post here:
From Ryan Creps:
"Do you see the data values for the column returned in a query window from the procedure?
+Ryan Creps
+Tessitura Network"
And from Lori Field:
"Maybe you already checked these...refresh dataset in BIDS, verify the field has data in the table, or confirm that the visibility property isn’t set to hidden in BIDS."
Yes, I refreshed the dataset in BIDS, and the field definitely has data in it, I executed the procedure in SSMS. It is a very strange problem. If the report was not on Live I would reboot.
James
I am going to rebuild the report, I will post again if that fails too
James.
Pasting in a reply from Ryan Creps for reference:
"The other thing to notice….Is your datasource connecting to the database you expect? You might be seeing the TEST database in BIDS, but the production DB or Dev DB when you try to run it through Tessitura?
+Ryan Creps+Tessitura Network"