Solved

get data from cr to database

Posted on 2013-06-25
6
313 Views
Last Modified: 2013-07-09
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
Comment
Question by:edo60
6 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39275918
Reporting is meant to be readonly and I am not aware of any way of inserting data from CR into database.
0
 
LVL 14

Assisted Solution

by:LinInDenver
LinInDenver earned 250 total points
ID: 39275922
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
 

Author Comment

by:edo60
ID: 39276124
I do not have the option export as odbc in save as options,
IS CR 2008 for vb 2010
tsm
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 125 total points
ID: 39276232
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
 
LVL 14

Accepted Solution

by:
LinInDenver earned 250 total points
ID: 39276247
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
 
LVL 34

Assisted Solution

by:James0628
James0628 earned 125 total points
ID: 39277469
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sum Before Standard Deviation 2 21
Open a link in vb.net 2 16
Change to file doesn't show up 16 57
Please explain purpose of GZIP 4 37
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question