CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Page 32 of 39 FirstFirst ... 2229303132333435 ... LastLast
Results 466 to 480 of 580

Thread: Crystal Report

  1. #466
    Join Date
    Jul 2003
    Location
    Chennai
    Posts
    42

    Re: Re: Re: Clarification needed ... to Babu

    hi..

    I use Oracle has a Database .... so I left the DSQ portion,

    What else i should do...


    Originally posted by K.Babu
    You have to specify all the information in logoninfo(n) property

    DSN = Data Source Name
    UID = User Logon ID
    PWD = Logon password
    DSQ = "c:\projects\data.mdb" [or server name]
    your's
    Soundar

  2. #467
    Join Date
    Aug 2003
    Posts
    30

    Checkboxes in Crystal Reports ?

    Hi all,



    I just started using Crystal Reports a few days ago and thus don't have any real experience with it. I'm trying to have checkboxes in my report, which will be checked or not depending on a boolean value in my database. What's the easiest way to achieve this with Crystal Reports ?

    Thanks in advance,
    Maxime

  3. #468
    Join Date
    Oct 2003
    Location
    Indore, India
    Posts
    6

    Exporting Crystal Report

    Hi

    i am writing code for exporting crystal report file. but get the following error:

    Error in File C:\Inetpub\wwwroot\HR\SkillMatrix.rpt: Error detected by export DLL:

    i am pasting code.


    ReportDocument crReportDocument =new ReportDocument();

    crReportDocument.Load"C:\\Inetpub\\wwwroot\\HR\\SkillMatrix.rpt");

    CRSkillReport.ReportSource = crReportDocument;


    ExportOptions exportOpts = new ExportOptions();

    DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
    exportOpts = crReportDocument.ExportOptions;

    exportOpts.ExportFormatType = ExportFormatType.Excel;
    exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;

    diskOpts.DiskFileName = "c:\\abc.xls";
    exportOpts.DestinationOptions = diskOpts;

    try
    {
    crReportDocument.Export ();
    }
    catch (Exception err1)
    {
    Response.Write("<br>");
    Response.Write(err1.Message.ToString());
    }


    Thanks

  4. #469
    Join Date
    Oct 2003
    Location
    Indore, India
    Posts
    6

    Re: Exporting Crystal Report

    This problem is solved

    Thanks



    Originally posted by SayliJoshi
    Hi

    i am writing code for exporting crystal report file. but get the following error:

    Error in File C:\Inetpub\wwwroot\HR\SkillMatrix.rpt: Error detected by export DLL:

    i am pasting code.


    ReportDocument crReportDocument =new ReportDocument();

    crReportDocument.Load"C:\\Inetpub\\wwwroot\\HR\\SkillMatrix.rpt");

    CRSkillReport.ReportSource = crReportDocument;


    ExportOptions exportOpts = new ExportOptions();

    DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
    exportOpts = crReportDocument.ExportOptions;

    exportOpts.ExportFormatType = ExportFormatType.Excel;
    exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;

    diskOpts.DiskFileName = "c:\\abc.xls";
    exportOpts.DestinationOptions = diskOpts;

    try
    {
    crReportDocument.Export ();
    }
    catch (Exception err1)
    {
    Response.Write("<br>");
    Response.Write(err1.Message.ToString());
    }


    Thanks

  5. #470
    Join Date
    Aug 1999
    Location
    India, TamilNadu, Chennai.
    Posts
    269

    View Pictures from database.Table.field contains picture filename with path.

    Dear Friends,

    I received more emails regarding, how to view pictures in the database file.

    The database table field contains picturename and its path. they want to display get pictures from the stored path.

    I Attached VB 6.0 sample Code to this reply

    Project used software:
    Windows 2000
    VB 6.0
    Crystal Report using with RDC Method Engine 8.5
    MS Access 97

    Attach file name: CRPhoto.zip

    I hope this sample code will help all developers.

    Regards,
    K.Babu
    Attached Files Attached Files
    Please avoid sending emails to my personal mail:
    write your doubts as thread in Codeguru
    Crystal Reports Forum
    .

    This will help all people having similar matters, and will let people who know solutions on the specific topic
    share their knowledge.

    Visit my company web site (Qmax Test Equipments Private Limited)

    Yours friendly,
    K.Babu

  6. #471
    Join Date
    Dec 2001
    Location
    UK
    Posts
    308

    Open Crytal file in ASP Page

    Hi,
    how to open the Crystal report in the ASP page..

    thanx in adv..

    Venu
    Venu Bharadwaj
    "Dream it. U can do it!"

  7. #472
    Join Date
    Oct 2003
    Posts
    9
    Hello..

    I'm new in Crystal Reports. I have a question..

    I have a VB project, and on one form i have data in DataGrid.
    This data are results of an SQL query. Database is Baza.mdb .

    Are there on the forum (or WEB) any instructions how to print those data in DataGrid trough Crystal Report ???
    Or maybe you can help me?

    Thank you...

  8. #473
    Join Date
    Aug 1999
    Location
    India, TamilNadu, Chennai.
    Posts
    269

    Sample VB Code for Export PDF Format from Crystal Report 8.5 in VB at Run Mode.

    You can find out the answers from the VB code for the following questions.

    Q:
    How to open MSAccess database file from select path in VB at run mode?
    How to hide password prompt dialog box, from the protected database file?
    How to open OCX report file to RDC method?
    How to Export PDF format without Preview screen?
    How to Hide export prompt dialog box?
    How to Filter the data records in VB at Run mode?
    How to open automatically Exported PDF file with acrobatreader?

    Code:
        Dim crrpt As New CRAXDRT.Report
        Dim crapp As New CRAXDRT.Application
        
        Set crrpt = crapp.OpenReport("C:\Projects\quotation.rpt")
        crrpt.Database.Tables(1).Location = "C:\Projects\BrCusinfo.mdb"
        crrpt.Database.Tables(1).SetLogOnInfo "CRSS", "BrCusinfo.mdb", "Admin", "hello"
        
        crrpt.RecordSelectionFormula = "{quequotation.QuotationNo} = " & 58
        crrpt.ExportOptions.ApplicationFileName = "C:\Projects\expquotation.pdf"
        crrpt.ExportOptions.DestinationType = crEDTApplication
        crrpt.ExportOptions.DiskFileName = "C:\Projects\expquotation.pdf"
        crrpt.ExportOptions.PDFExportAllPages = True
        crrpt.ExportOptions.FormatType = crEFTPortableDocFormat
        crrpt.Export False
        
        'Remarked Viewer Report Output
        'CRViewer1.ReportSource = crrpt
        'CRViewer1.ViewReport
    Last edited by K.Babu; October 28th, 2003 at 06:44 AM.
    Please avoid sending emails to my personal mail:
    write your doubts as thread in Codeguru
    Crystal Reports Forum
    .

    This will help all people having similar matters, and will let people who know solutions on the specific topic
    share their knowledge.

    Visit my company web site (Qmax Test Equipments Private Limited)

    Yours friendly,
    K.Babu

  9. #474
    Join Date
    Oct 2003
    Location
    Malaysia
    Posts
    3

    Printing Problem

    Hi Babu!

    I am using Activex Viewer in Crystal reports 8 to show the reports on Web with ASP. The reports appears properly Crystal report environment.Even the report appears fine when used in Visual basic. But When seen on web the alignment of the report is changing.The text is not taking the pagesetup margins at all.

    Looking forward from u...

    ravi

  10. #475

    Crystal Reports Utility

    Does anyone know of a utility that will compare the differences betweent two .RPT files?

    Thanks,
    Bob

  11. #476
    Join Date
    Oct 2003
    Posts
    1

    NET Crystal Reports Login Text Database

    Hello ,

    I am using Crystal Reports Net with a cvs file through an DAO Connection.

    When add the database file within the crystal report designer,everything is ok.Crystal reports recognize the file as text database and its fields.

    However,when i bind the report to the crystal report viewer (at runtime) the login screen appears asking for password.The problem is that i have NOT used a secure logon.

    I tried to use TableLogInfo but the dialog still appears!!

    LOGIN FAILED ((((

  12. #477
    Join Date
    Oct 2003
    Posts
    1

    Error returned: 20614 meaning: Starting

    I am currently using CR 7.0 on a winnt 4.0
    platform (I know, I know, nothing I can
    control) with sql 2000. I am getting the
    following error

    User Session has timed out, I have tried
    everything suggested by crystal in the pdf
    file outlining this error. From there they
    suggested that I insert code to display the
    true error code, which is:

    Error returned: 20614 meaning: Starting
    background processing failed

    Here is how I got this error

    On the web page (asp) I go in to the search
    page and perform a search, it takes about 10
    minutes but the report comes up. So far so
    good...

    Now if I do the search again and then have
    another person login to the same search page
    and perform a search (can be totaly
    different searches) the second person will
    get this error, while my search will
    complete.

    Can someone help me out? Thanks

  13. #478
    Join Date
    Nov 2003
    Posts
    6

    changing the default display for Boolean fields in Crystal Reports **RESOLVED**

    Hi,
    I'm trying to change the default display of a boolean field value so that it would display a String of my choice (in this case a different language than English).
    I've tried using IIF in the formula of the Boolean Text property (in the Boolean tab in the field's Format Editor) but it says that the formula's result must be a number.

    Any ideas?

    Thanx
    Last edited by Shafan; November 9th, 2003 at 04:23 AM.

  14. #479
    Join Date
    Jan 2003
    Location
    India
    Posts
    9

    Please help me

    Dear Mr. Babu
    Please help for the following problem.

    I have designed a report in crystel report 8.0. with password protected MS Access database. When I save the report with save report with data, on prevewing through my VB project it opens up the report but did not refresh with any new data that is being added to dadabase. When I run the same report without saving with save with data option it gives me the error : error no 20535 Invalid secession parameter.

    A am pasting the sample code that I used: where cr1 the crystel report control

    with cr1
    .reset
    .reportfilename=app.path & "\report1.rpt"
    .LogInfo="aaaa" '(this is the password)
    .WindowParentHandle=MdiForm1.hwnd
    .WindowState=crptMaximized
    .Destination=crptToWindow
    .Action=0
    end with

    This same code works fine with database without any password. And gives me updated data on previewing.
    Please how can get refreshed report from a password protected database.

    Thanks to you.
    Biswas

  15. #480
    Join Date
    Mar 2002
    Posts
    3
    Hi, Babu

    Crystal Reports 8.5 makes a tmp file with size 0 kb when I open a
    report. This is when I am developing and with the compiled version of my app.
    CR puts the files in de lowest directory where the user has rights (not in the tempdir, but dir's like C-root) and doesn't delete them. Very annoying.

    Do you know if there is a hotfix? Or do you have another solution?

    I develop with Crystal Reports 8.5, Visual Basic 6.0 under Windows XP and 2000.

    Regards,
    John

Page 32 of 39 FirstFirst ... 2229303132333435 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured