Results 1 to 3 of 3

Thread: crystal report char(13)

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    crystal report char(13)

    hello! how would i do this?
    this is a reciept

    description amount
    item1 5.00
    item2
    6 X 3.00 18.00
    ======
    23.00

    also the only options are .showDialog and .show
    how would i directly print without previewing it?

    tnx
    *****************
    VB6,PHP,VS 2005

  2. #2
    Fanatic Member kregg's Avatar
    Join Date
    Feb 2006
    Location
    UK
    Posts
    524

    Re: crystal report char(13)

    Sorry to tell you this, but you really haven't explained your question properly.

    We human programmers are not mindreaders... well not very good ones anyway! You'll need to give a much more in-depth explanation about what you have done and what you are trying to do. The more detail you give, the more accurate we can be with our answers.

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    Re: crystal report char(13)

    ok sorry...

    this is the actual code:

    Code:
     SqlConnection conn = new SqlConnection(cVar.conString);
                conn.Open();
                SqlCommand comm = conn.CreateCommand();
                comm.CommandText = "SELECT * FROM tblPOS WHERE RECEIPT_NO = "+ lblReceiptNo.Text +"";
                cVar.dataReader = comm.ExecuteReader();
    
                    if (cVar.dataReader.HasRows)
                    {
                        cVar.dataReader.Close();
                        SqlDataAdapter da = new SqlDataAdapter(comm);
                        DataTable dt = new DataTable();
                        da.Fill(dt);
    
                        crReceipt cReceipt = new crReceipt();
                        cReceipt.SetDataSource(dt);
                        frmPrintPreview fPrintPreview = new frmPrintPreview();
                        fPrintPreview.crystalReportViewer1.ReportSource = cReceipt;
                        fPrintPreview.ShowDialog();
    i'm going to print the receipt no.
    1. why crystal report is too slow when preview? (use this in other report)
    2. how can i print directly without showing the print preview?
    3. in receipt how can i print items like below

    Description Amount
    Milk 75.00 --> 1 item only (1 line)
    orange
    5 X 10.00 50.00 --> if the item greater than 1 (2 lines)
    ===========
    125.00
    no problem if all items are 1 i can print it line by line the problem is that how if the item is greater than 1 i must print (no. of items times the unit price at the bottom) because the paper is 3inches wide only. remember that this is a receipt
    *****************
    VB6,PHP,VS 2005

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