• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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
0
Ernesto
Asked:
Ernesto
4 Solutions
 
CodeCruiserCommented:
Reporting is meant to be readonly and I am not aware of any way of inserting data from CR into database.
0
 
LinInDenverCommented:
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
 
ErnestoAuthor Commented:
I do not have the option export as odbc in save as options,
IS CR 2008 for vb 2010
tsm
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
mlmccCommented:
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
 
LinInDenverCommented:
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
 
James0628Commented:
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now