?
Solved

Crystal Report Embedded in aspx With Two ODBC Connections

Posted on 2013-10-24
4
Medium Priority
?
536 Views
Last Modified: 2013-10-28
I have a Crystal Report developed by someone in house that references two different ODBC connections that are created using Clarion's TopSpeed ODBC connector to connect to *.tps flat files. I need to set this report up embedded in an aspx page OR I need to access the data directory from asp.net c# and rebuild the report in a gridview.

I can't connect to the odbc connectors no matter what I do. I've scoured the internet and not found too much help with this.

Has anyone done this before? Can you point me to a site that explains it?
0
Comment
Question by:Carla Romere
[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
  • 2
  • 2
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39599331
What version of Crystal?

The versions I am familiar with only really support a single database connection.  Multiple may work in them but the SDK only supports 1 connection so there is no way to pass 2 connections to the report.

The recommended solution has always been use a subreport for one of the connections.

The newest versions may support it but then you will need to be using the versioin that is built for Visual Studio.

mlmcc
0
 

Author Comment

by:Carla Romere
ID: 39605580
I'm using the one for VS 2010 - if I run it purely from Crystal Reports, the report runs fine. When I embed it in an aspx page is when it blows up.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39605588
The problem is the SDK doesn't support 2 data sources so there is no way to set the second source.

mlmcc
0
 

Author Comment

by:Carla Romere
ID: 39605706
Okay, maybe I'll see if I can ditch the Crystal Report and attempt to connect to multiple ODBC connections directly from asp.net. Thanks for your help, mlmcc, - always on the ball!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

765 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