Solved

get data from cr to database

Posted on 2013-06-25
6
315 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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 35

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 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