Crystal Reports - spaces in columns
Hi -
I am using CR10 and trying to create a report that has spaces in the column name
In CR the sql statement looks something like this
SELECT
table_name1.LastName
,table_name2.User id
FROM table_name1
INNER JOIN table_name2
ON table_name1.id=table_name2
This gives a error in SQL so it should look something like this:
SELECT
table_name1.LastName
,table_name2.[User id]
FROM table_name1
INNER JOIN table_name2
ON table_name1.id=table_name2
Is there any way to change this in CR10 so that it sends the proper format to the sql server
Thanks in advance
I am using CR10 and trying to create a report that has spaces in the column name
In CR the sql statement looks something like this
SELECT
table_name1.LastName
,table_name2.User id
FROM table_name1
INNER JOIN table_name2
ON table_name1.id=table_name2
This gives a error in SQL so it should look something like this:
SELECT
table_name1.LastName
,table_name2.[User id]
FROM table_name1
INNER JOIN table_name2
ON table_name1.id=table_name2
Is there any way to change this in CR10 so that it sends the proper format to the sql server
Thanks in advance
ASKER
thanks mlmcc but how is that done in crystal reports.
I just drop the field onto the report and crystal creates the sql
I just drop the field onto the report and crystal creates the sql
Did you select the tables and just putting the fields on the report?
If so, Crystal should add the appropriate deliiters to the SQL.
mlmcc
If so, Crystal should add the appropriate deliiters to the SQL.
mlmcc
Is the issue with Crystal or the Export?
What version of Crystal?
mlmcc
What version of Crystal?
mlmcc
ASKER
Crystal 10
Yes, I select the tables and put the fields on the report.
When I view the SQL (Database -> Show SQL Query) in Crystal it has not added the anything to accommodate for the space.
table_name2.User id needs to be table_name2.[User id]
So I get a SQL error when running the report
Yes, I select the tables and put the fields on the report.
When I view the SQL (Database -> Show SQL Query) in Crystal it has not added the anything to accommodate for the space.
table_name2.User id needs to be table_name2.[User id]
So I get a SQL error when running the report
Try a VERIFY DATABASE.
Another idea would be to delete that table from the report then run the report and then add the table back.
mlmcc
Another idea would be to delete that table from the report then run the report and then add the table back.
mlmcc
ASKER
Database verify says "Up To Date"
I removed the table, ran report (no issues) then error again when I added.
I removed the table, ran report (no issues) then error again when I added.
No idea. I generally use fieldnames with no spaces or use underscores for them.
When you select the tables you can't change the SQL that is generated. Almost sounds like there is a problem with your Crystal install.
Is it a full version of Crystal 10 or one of the versions that came with Visual Studio?
Do you have Visual studio 2003, 2005, or 2008 installed?
If so is Crystal for Visual Studio installed?
mlmcc
When you select the tables you can't change the SQL that is generated. Almost sounds like there is a problem with your Crystal install.
Is it a full version of Crystal 10 or one of the versions that came with Visual Studio?
Do you have Visual studio 2003, 2005, or 2008 installed?
If so is Crystal for Visual Studio installed?
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No answer given
SELECT
table_name1.LastName
, 'table_name2'.'User id'
FROM table_name1
INNER JOIN table_name2
ON table_name1.id= 'table_name2'.'User id'
mlmcc