Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Additional Feilds added to view Post Reply Post New Topic
Page  of 2 Next >>
Author Message
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Topic: Additional Feilds added to view
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 15 May 2012 at 5:04am
verify database should update the schema
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 15 May 2012 at 5:15am
have tried that, not updating,
 
is there anything else i could do
 
Thank you for replying.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 15 May 2012 at 11:25pm

Hello DBlank

 

all changes have been made in appropriate areas.

 

Is there anything else i could try.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 May 2012 at 1:49am
Is the report table using an alias (overridden table name)?
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet Posted: 16 May 2012 at 2:32am
no. All orignal
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet 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.
IP IP Logged
masterdineen
Newbie
Newbie
Avatar

Joined: 28 Sep 2010
Location: United Kingdom
Online Status: Offline
Posts: 26
Quote masterdineen Replybullet 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.
IP IP Logged
Page  of 2 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.