Data Connectivity: New columns in SQL not showing in linking

Print Page | Close Window

New columns in SQL not showing in linking

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10444
Printed Date: 03 May 2024 at 1:38pm

Topic: New columns in SQL not showing in linking

Posted By: tlspidle
Subject: New columns in SQL not showing in linking
Date Posted: 06 Jul 2010 at 10:49am

I have added new columns in my SQL db and can see them in CR2008 filed explorer but they do not show up when I try to link them. I have tried granting permissions in SQL to the new column. Tried verifying DB, setting location, closing and re-opening CR all to no avail.

Can anyone tell me the secret to seeing new SQL columns?

Thanks

Terry

Print Page | Close Window