Solved

how to get parameter fields from ASP .NET to CR

Posted on 2004-11-01
755 Views
Last Modified: 2012-08-13
Hi all,
I am writing a ASP .NET program (C#) to view a CR (8.5), and the CR takes a fews parameter fields, how can I use C# API to pass the parameter fields to CR to output the report?

one  more question is, when I view the CR (directly), it will prompt for sql connection username and password, I have made  a  file dsn for the connection, and it prompt out for these info everytime I view the report, can I pass these fields by using ASP.NET API too? Thanks a lot!
0
Question by:ultrafish
    9 Comments
     
    LVL 100

    Expert Comment

    by:mlmcc
    0
     
    LVL 1

    Accepted Solution

    by:
    // Create report instance
    private ReportDocument reportDocument = new ReportDocument();

    // Assign values to instance
    reportDocument.Load(strLocation);  // location of report
    reportDocument.SetDatabaseLogon(dbUser,dbPass); // username and password for DB access

    // Assign parameters to report
    reportDocument.SetParameterValue(paramName,paramValue);
    reportDocument.SetParameterValue(paramName,paramValue);
    reportDocument.SetParameterValue(paramName,paramValue);

    You didn't mention what you want to do with the report.  Your options are to sent it to a viewer, export or print.

    // Print
    reportDocument.PrintOptions.PrinterName = printerName;
    reportDocument.PrintToPrinter(1, false, 0, 0);

    // Export - This will require export options to be defined.
    reportDocument.Export();






    0
     

    Author Comment

    by:ultrafish
    if I have to choose the datasource like
    data.dsn
    how can I choose it?
    thanks~~~
    0
     

    Author Comment

    by:ultrafish
    also, I cannot find the method SetDatabaseLogon and SetParameterValue method
    which library has to be imported?

    and if I want to print directly, how can I do that? thanks
    0
     
    LVL 1

    Expert Comment

    by:Sevnn
    I have never needed to choose a dsn.  I did a quick check and ReportDocument has a parameter:

    reportDocument.SetDataSource(dsnSource);

    Hope this helps.  Thanks for the points ultrafish, this is my first accepted response (also my first day to be a member of EE).  Good Luck.
    0
     
    LVL 1

    Expert Comment

    by:Sevnn
    using CrystalDecisions.CrystalReports.Engine;
    using CrystalDecisions.Shared;

    Is "reportDocument" working at all for you?

    What do you mean by printing directly?
    0
     

    Author Comment

    by:ultrafish
    is that only exist in 2003 and CR 9.0?
    I am using CR 8.5 and VS.NET 2002 only, I don't have the method SetDatabaseLogon() and SetParameterValue()
    0
     
    LVL 100

    Expert Comment

    by:mlmcc
    0
     
    LVL 1

    Expert Comment

    by:Sevnn
    Ahhh, You weren't specific about your .Net development environment.  You referenced CR 8.5 but I understand that as a reference to what version the reports were originally written in.  I don't know if CR 8.5 components in 2002 would be similar to the code I posted.  What I posted is from a working program in .Net 2003 with CR 9.0 (Crystal Decisions).  Hopefully mlmcc's link will provide the information you need.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: Foundations of Front-End Development

    Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.
    Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

    856 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

    9 Experts available now in Live!

    Get 1:1 Help Now