Query from two tables in report

by

In Crystal report wizard, locate your odbc created with username and password.

Then you will see a Command text, You can put your Query in there.

This code for VB.NET

 Private CRPT As New ReportDocument
    Private APPPATH As String
    Private PARAM As New ParameterFields
    Public PARAM_DESC As New ParameterDiscreteValue
    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

        APPPATH = Application.StartupPath & "\REPORT\sample.rpt"
        CRPT.Load(APPPATH)
        Me.CrystalReportViewer1.ReportSource = CRPT

        PARAM = CRPT.ParameterFields

        PARAM_DESC.Value = Format(DatePicker1.Value, "yyyyMMdd")
        PARAM("DATEP").CurrentValues.Clear()
        PARAM("DATEP").CurrentValues.Add(PARAM_DESC)
        Me.CrystalReportViewer1.Refresh()
    End Sub

This code is for C#:

CRPT = new ReportDocument();
            APPPATH = Environment.CurrentDirectory + "Sample.rpt";
            CRPT.Load(APPPATH);
            Report_Viewer.Refresh();
            CRPT.SetParameterValue("syear", Servercls.year);


            CRPT.SetParameterValue("smonth", Servercls.month);
            CRPT.SetParameterValue("sday", Servercls.day);
            CRPT.SetParameterValue("datevalue", Servercls.Datevalue);
            Report_Viewer.ReportSource = CRPT;

            sc.configureCrystalReport();
            Report_Viewer.Refresh();

Your crystal report parameter name must be the same with in your Code Behind.

More Related Contents:

  1. Store image to database blob; retrieve from db into Picturebox
  2. Is it safe to store usernames and passwords in the database?
  3. Return Last ID (IDENTITY) On Insert row VB.NET MySQL
  4. Delete the entire content of all table in a Database [closed]
  5. MyISAM versus InnoDB [closed]
  6. How do I find the MySQL my.cnf location
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. MySQL select one column DISTINCT, with corresponding other columns
  9. MySQL Syntax error message “Operand should contain 1 column(s)”
  10. How to use mysql JOIN without ON condition?
  11. How to remove all non-alpha numeric characters from a string in MySQL?
  12. Define a variable within select and use it within the same select
  13. ERROR: Error 1005: Can’t create table (errno: 121)
  14. MySQL – force not to use cache for testing speed of query
  15. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  16. How to count all rows when using SELECT with LIMIT in MySQL query?
  17. MySQL FULL JOIN?
  18. Using Count to find the number of occurrences
  19. How to fix double-encoded UTF8 characters (in an utf-8 table)
  20. How to integrate ElasticSearch with MySQL?
  21. MySQL INSERT INTO … VALUES and SELECT
  22. MYSQL select DISTINCT values in two columns
  23. MySQL LOAD_FILE() loads null values
  24. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  25. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  26. How to compare timestamp dates with date-only parameter in MySQL?
  27. How to sort a MYSQL table in a permanent way?
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment