get data from cr to database

Is any way to get data from the report to a table in database?
I mean in the example that im attached  the column ref is a position of the ittem on the sheet compousing by the page number+the number of the item on the sheet, that isnt in the database, is any way to retrive this information to the database?
tsm
edo
Crystal-Reports---requis-totaliz.pdf
ErnestoAsked:
Who is Participating?
 
LinInDenverConnect With a Mentor Commented:
Just want to make sure - are you actually attempting to EXPORT the report (clicking the little envelope icon) or are you going to FILE | SAVE AS?

Make sure you are trying Export - the ODBC choice isn't available under "Save As"
0
 
CodeCruiserCommented:
Reporting is meant to be readonly and I am not aware of any way of inserting data from CR into database.
0
 
LinInDenverConnect With a Mentor Commented:
You can export to an ODBC connection (instead of exporting to PDF, Excel, etc... ODBC is a choice on the export format drop down).

You choose the applicable ODBC to use, then it will prompt you for a login and password. It will prompt you for a table name. Type it in and it will populate that table.

You can really only do this into a new table, which Crystal will create on the fly. Can't append to an existing. Crystal will also determine the column/field names in the table, based on what they are called in the report.

I have done this a lot, and then will typically run an SELECT INTO statement to get the data out of the crystal generated table into the table I want to append it to... then delete the Crystal generated table.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
ErnestoAuthor Commented:
I do not have the option export as odbc in save as options,
IS CR 2008 for vb 2010
tsm
0
 
mlmccConnect With a Mentor Commented:
Are you using CR2008 (stand-alone full version) or the version built for VS2010?

Check the version of Crystal.

DO you have any ODBC database drivers loaded or ODBC connection built?

Did you load the Crystal ODBC export drivers?

mlmcc
0
 
James0628Connect With a Mentor Commented:
Another, less direct, option would be to export the report to something like an Excel file and then using something else to import that file into the db.

 James
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.