Additional Feilds added to view
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16431
Printed Date: 26 Apr 2024 at 8:20pm
Topic: Additional Feilds added to view
Posted By: masterdineen
Subject: Additional Feilds added to view
Date Posted: 15 May 2012 at 4:41am
|
Hello there
I have a report that is using a sql server view
I have added two more columns to the view and i now want to bring them into the report.
How do i do that.?
I am using CR XI
The report has taken a quiet a bit of development so only want to add the additional fields
Regards
Rob
|
Replies:
Posted By: lockwelle
Date Posted: 15 May 2012 at 5:04am
| verify database should update the schema |
Posted By: masterdineen
Date Posted: 15 May 2012 at 5:15am
|
have tried that, not updating,
is there anything else i could do
Thank you for replying.
|
Posted By: DBlank
Date Posted: 15 May 2012 at 5:30am
| if you have a production and development server make sure you made the changes/updates in both locations and/or the report is pointing to the correct server. |
Posted By: masterdineen
Date Posted: 15 May 2012 at 11:25pm
|
Hello DBlank all changes have been made in appropriate areas. Is there anything else i could try. |
Posted By: DBlank
Date Posted: 16 May 2012 at 1:49am
| Is the report table using an alias (overridden table name)? |
Posted By: masterdineen
Date Posted: 16 May 2012 at 2:32am
| no. All orignal |
Posted By: DBlank
Date Posted: 16 May 2012 at 2:46am
|
The 3 areas I can think of are what we covered.
The databse needs to be refreshed The odbc points to the wrong db server The report is using overridden tables so you need to change the view in use not the view that it looks like it is using. Now I have sworn all 3 of those are correct and spent hours looking at the view and the report and eventually figured out either option 2 or 3 was not correct and then fixed it in one minute. Sorry but these are the only culprits I can think of for the scenario you described. |
Posted By: masterdineen
Date Posted: 16 May 2012 at 3:41am
|
All i have done, is update my sql server view with two additional columns.
Now i just need to add them to the report.
No worries
THank you for your help, and answers.
|
Posted By: masterdineen
Date Posted: 16 May 2012 at 3:52am
|
Hello DBlank
I have fixed it. After checking alias's. Whoever created the crystal report reference it to a different view in database.
THank you very much.
|
Posted By: DBlank
Date Posted: 16 May 2012 at 3:55am
 I would rename the source (in DB, DB expert) to avoid that in the future or put a hidden field in a report header to notify others that an alias is in use
|