Solved

Crystal Report Embedded in aspx With Two ODBC Connections

Posted on 2013-10-24
4
532 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:Hers2keep
  • 2
  • 2
4 Comments
 
LVL 100

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:Hers2keep
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 100

Accepted Solution

by:
mlmcc earned 500 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:Hers2keep
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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
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…

770 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