Crystal Reports Cannot find fields

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Cannot find fields

Author	Message
AccessdbGuru Newbie Joined: 11 Sep 2009 Location: United States Online Status: Offline Posts: 2	Topic: Cannot find fields Posted: 11 Sep 2009 at 7:48am
	Hi Folks! I am working on Crystal Report 2008. And I cannot find the data fields i need for my report. All i see is command 1 and command 2 report fields and in it I dont find the particular field. How will I be able to find it? thanks! SMS
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Sep 2009 at 8:03am
	The available fields are defined by the command statements. If it is not lised under either of the commands then it is either excluded in the command itself or it was renamed. Go into Database Expert under Data tab Command1 and Command2 should be listed Right click on eitehr and select View Command from here you can see what your sources are and what the origianl fields from the sources are. You can also edit the command to include another field from said tables. Does this help/answer your question?
	IP Logged

rdseal Newbie Joined: 18 Jun 2009 Online Status: Offline Posts: 23	Posted: 11 Sep 2009 at 8:07am
	From Start Page click Report wizard, connect to DB. Then you should be able to see all the tables. Choose tables with fields that you need. Remember to link your tables correctly! and so on follow the wizard I hope this will help you to START Regards RDSEAL
	read read read
	IP Logged

AccessdbGuru Newbie Joined: 11 Sep 2009 Location: United States Online Status: Offline Posts: 2	Posted: 11 Sep 2009 at 8:48am
	Thanks. Here is what I see when I edit: EXEC spRQRPTPurchaseOrder '{?@xstrTranType}', '{?@xstrPONumber}', {?@xnReviewSession},@xstridfSecurityIDCurrent = '{?@xstridfSecurityIDCurrent}', @xnidfData = 1 Looks to me like a store procedure. Do i need to modify the sp to view the field i want to see.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 11 Sep 2009 at 8:57am
	I would guess yes but that is a guess as I can't see your set up. I don't use SPs much so lockwelle or hilfy might jump in here... Bottom line is Crystal only has access to the data that is defined by your source (the command which is calling a SP). You may be able to alter the SP or add in another command to get the missing data but that will need to be joined to the other commands. The fix in this case all depends on what the SP being used is doing and if the database design will let you include the "missing field" into that SP. Does this make sense? Also a word of caution... changing a SP or view at your source that may be used elsewhere can have adverse effects across your entire system. Make sure you know that changing this does noty alter the data set or cause oterh issues if that SP is used for multiple things. Edited by DBlank - 11 Sep 2009 at 9:00am
	IP Logged

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.