Dynamic Crystal Report 9.2 Generation

[zafarnazir]

i am making a vb.net application
i want to add a crystal report in it
i have installed crystal report 9.2 software on my pc
i have added a blank crystal report in my project
i want to make its connection programetically like this one

con1.ConnectionString = "Data Source=" & servername & " ;Initial catalog=Babar;user id=sa;password=trees"

cmd1 = New SqlCommand("ins_prodcat1", con1)
cmd1.CommandType = CommandType.StoredProcedure
cmd1.Parameters.Add("@cid", SqlDbType.NVarChar)
cmd1.Parameters(0).Value = cid1
cmd1.Parameters.Add("@cname", SqlDbType.NVarChar)
cmd1.Parameters(1).Value = cname1
cmd1.Parameters.Add("@dis", SqlDbType.NVarChar)
cmd1.Parameters(2).Value = discount1
cmd1.ExecuteNonQuery()
cmd1.Dispose()

but crystal report is only providing connection through data connection wizard.
i do not want to do it with wizard.

i want to add fields and columns programmetically at run time after reading from database.
i want to do it programmetically. Please help me

 

[zafarnazir]

dynamic crystal report error

i have also tried to do it by studying some articles from internet but i am getting error when i try to add following header files

Imports CrystalDecisions.crystalreports.engine
Imports CrystalDecisions.reportsource
Imports CrystalDecisions.shared

above 3 lines give error although crystal report 9.2 software is installed on my machine.

Imports CrystalDecisions.windows.forms
above single header file works fine on my machine

pleas help me

 

[Administrator]

Hello,

I moved your post to the correct forum. The "Forum Feedback/Bugs" forum is for feedback on the use of this forum and is not to be used for software questions. Please post to the appropriate forum in the future and I'm sure someone will provide better service.