Solved

Crystal Report Embedded in aspx With Two ODBC Connections

Posted on 2013-10-24
4
530 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

910 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

21 Experts available now in Live!

Get 1:1 Help Now