Solved

Data source for a crystal report

Posted on 2011-03-15
4
236 Views
Last Modified: 2012-05-11
I have a dataset in my C# program.  In the dataset there is a customer table adapter with a query called fillbyJournal.  I would like to use this query as a datasource for a Crystal report.  Currently is has a stored procedure as it datasource but I can't figure out how to keep it from asking for a password when I open it.

Any help would be appreciated!!!

Jerry
0
Comment
Question by:JDL129
  • 2
  • 2
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 35143544
You have to build the report to use a dataset that is passed in.  If you start with a database Crystal remembers that and always wants to login in.

Here is an example
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
0
 

Author Closing Comment

by:JDL129
ID: 35164566
Sorry for the B grade but you don't get an A if I have to dig out the answer from a link.  There is never the exact scenario.

Thanks for the reply.

Jerry
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35165452
Since it is against EE rules to copy and paste from a copyrighted source, pasting the link is the appropriate action.

mlmcc
0
 

Author Comment

by:JDL129
ID: 35169451
I just asked for information on how to do it.  I wouldn't expect you to break EE rules.

Sorry,
Jerry
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
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 demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

707 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

13 Experts available now in Live!

Get 1:1 Help Now