Solved

get data from cr to database

Posted on 2013-06-25
6
310 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now