vb.net Crystal report, only ttx datasource

[former_member704081]

Hi,

I have a crystal report that does not use a database connection, instead it uses a ttx file and a sql file to pull in data. The only table within the report is created from the ttx file.

I am attempting to run this crystal report using a vb.net crystal report app, which I have done in the past. The problem is that the application prompts me for log in info for the ttx file, which from my understanding it doesnt have any. I am not sure how to proceed here to get this report to run in a vb.net app. Had anyone else ever encountered this issue?

Thanks,

Chris Kretman

[former_member704081 · Accepted solution]

I figured this out. In the process i removed a bunch of parameters that were not needed. The issue was that I was setting the data source after setting the param values. I move the line rpt.SetDataSource(ds.Tables(0)) above my code where I fill the paramaters.

rpt.SetDataSource(ds.Tables(0))


            rpt.Refresh()


            'fill the parameters with values
            rpt.SetParameterValue("Filter_impPartID", Part)
            rpt.SetParameterValue("Props_DS_xadInventoryQuantityDecimals", "2")


            CrystalReportViewer1.ReportSource = rpt
            CrystalReportViewer1.Show()