Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
exporting to sql db in crystal 8.0
- Thread starter thminer
- Start date
synapsevampire
Programmer
By SQL db do you mean SQL Server? SQL is a language common to many databases.
Are you exporting using ODBC, or a native connectivity?
The report needs to be properly set up to accomplish this, and you can only write to a new table.
-k
Are you exporting using ODBC, or a native connectivity?
The report needs to be properly set up to accomplish this, and you can only write to a new table.
-k
Dear Thminer,
I just did a test and was able to export data to a table with no problem.
Look at the report in crystal ... do any of the fields contain a special character like the > symbol?
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
I just did a test and was able to export data to a table with no problem.
Look at the report in crystal ... do any of the fields contain a special character like the > symbol?
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
Dear Thminer,
As SV states ... it must be to a new table or you will get an error message that the table already exists.
Also, do not put any column headers on the report or it creates those as columns before the data.
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
As SV states ... it must be to a new table or you will get an error message that the table already exists.
Also, do not put any column headers on the report or it creates those as columns before the data.
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
- Thread starter
- #5
synapsevampire
Programmer
The data wouldn't, however you may be violating naming rules for the field/column names themselves if they contain them.
-k
-k
Dear Thminer,
Can you give a better example of your data? I just modified the data in a column to contain a > symbol and it exported fine.
Hmm, in my odbc connection I have the use ANSI Quoted identifiers checked,Do you have quoted identifiers set to on or off?
It might be helpful to list all your settings so that we can see what is different.
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
Can you give a better example of your data? I just modified the data in a column to contain a > symbol and it exported fine.
Hmm, in my odbc connection I have the use ANSI Quoted identifiers checked,Do you have quoted identifiers set to on or off?
It might be helpful to list all your settings so that we can see what is different.
regards,
ro
Rosemary Lieberman
rosemary-at-microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
You will get answers more quickly if you read this before posting: faq149-3762
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question