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.
