Results 1 to 2 of 2

Thread: crystal report location

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2013
    Posts
    37

    crystal report location

    I wanted the user to have freedom to change the layout of crystal reports at runtime...but as I didnt get any solution for this. I want to place the crystal reports outside the exe file so that user can open crystal reports and edit it..but HOw to access crystal reports outside exe.

    Im using crystal report with typed dataset. In windows app vb.net 2008 and mssql 2005

    Dim sql1 As String = "select company_name,pobox,city,address,telephone,fax,website,email,logo,sign,supplier_name,date,created_by, request_id,request_no from company,request where request_id ='" + txtRequestId.Text + "'"
    Dim sql2 As String = "select no,item_name,group_name,description,qty,request_id from request_item where request_id ='" + txtRequestId.Text + "'"

    Dim dbConn As SqlConnection = cl.sqlConn()
    Dim da As New SqlDataAdapter()
    Dim ds As New dsRequest()

    da = New SqlDataAdapter(sql1, dbConn)
    da.Fill(ds, "details")

    da = New SqlDataAdapter(sql2, dbConn)
    da.Fill(ds, "items")

    Dim oRpt As New rptRequest
    oRpt.SetDataSource(ds)

    I could use rptRequest before because before it was inside project but now I have placed it outside..so how to access rptRequest.rpt. Please help as Idnt know much about rptRequest. If anyone knows about runtime layout designer for cyrstal reports or any other reporting please let me know. Im ready to pay money also.Please help.

  2. #2
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,509

    Re: crystal report location


Tags for this Thread

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