Hi Everyone,

   I have a project which will migrate crystal report from vb to .net,
and I decided to use vb.net and crystalreportviwer. However I have the
code with vb6 like (using crystl32.ocx)

  with .crystalreport
    .sqlquery = 'mysql query is here'
    .action = 1
     .....

this to do the query from my odbc settings.

How to use this kind of way in crystalreportviewer?


Thanks,
R

Rob,

Have a look at this,

http://www.vb-tips.com/ReportSample.aspx

Cor

Hi Cor,
   Thank you for your replying.
   This is very good example and I have learned something from it. I
have another question for you regarding the crystalreportviewer, for
example in vb6 i will do
   with rpt
    .action =1   'do the report loading
    .sqlquery = select ** from  *** where ....     ' this will do the
runtime query from my ODBC settings.

  At the first part of program user has login in program with ODBC
settings. I need to get solutions that how crystalreportviewer uses
runtime sql to do the report loading.  I have finished like:

    parameterfield.fieldname ='***'
    parameterfield.add ...    'Add the pareameterfield value
    parameterfields.add(parameterfield)

    How to get parameterfields and SQL QUERY to do the report loading
based on ODBC, or you can give me some sample code.


Thanks a lots
Rob

Build a string for arithmetic operation
clearing dataset or datatable
Force form to foreground?
Replacing control arrays in .NET
Structures and Delegates and ByRef Arguments
Split a large application
Using an Excel sheet as a DB table
Problem drawing a WMF File VB.NET2005 (and Working in VB6)
Example of System::Collections::Generic::LinkedList [noobie]
How to set default value for char