Skip to Content
0

Crystal Reports 2013 - How to add new fields to SQL Command

May 31, 2017 at 08:32 PM

57

avatar image
Former Member

I needed to change the table that a report was pointed to. The new table has all the same fields plus the additional 3 fields that I need. I did this through the Database expert and the new fields are showing in the Database Fields but not in the SQL Command. I need to insert a summary and create a running total with one of these fields but the field doesn't show up in the drop down lists either. How do I fix this. I have already tried verifying the database with no luck. TIA

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Brian Dong May 31, 2017 at 09:23 PM
0

Hi,

You shouldn't have to add the new fields into the report with the Database Expert. You just need to edit the SQL Command and add the new fields into the query directly.

Once you do that, they should show up in the Field Explorer.

Good luck,

Brian

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Jun 01, 2017 at 03:37 PM
0

If you're just linking tables in your report instead of using a Command, the new fields won't appear in the SQL that Crystal generates until they are actually used in the report.

-Dell

Share
10 |10000 characters needed characters left characters exceeded