The report you requested requires further information.
Server name: localhost
Database name: report
User name: sa
Password:
Use Integrated Security
มันเป็นเพราะอะไรครับ
อันนี้ code vb.net
Code (VB.NET)
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Web
Imports CrystalDecisions.Shared
Imports System.Data.SqlClient
Imports System.Data
Imports System.Data.OleDb
Public Sub showdailyReport()
Try
Dim sql As SQLCon = New SQLCon
' get parameters from POST method
Dim reportName As String = "DailyReport"
Dim dateFrom As String = Request.QueryString("dateFrom")
Dim dateTo As String = Request.QueryString("dateTo")
'Dim cmd As New SqlCommand
Dim viewName As String = Request.QueryString("viewName")
Dim query As String = "select * from " & viewName & ""
rpt = New CrystalDecisions.CrystalReports.Engine.ReportDocument
rpt.Load(Server.MapPath("DailyReport.rpt"))
rpt.SetParameterValue("PaDateFrom", dateFrom)
rpt.SetParameterValue("PaDateTo", dateTo)
rpt.SetParameterValue("PaCommand", query)
Catch ex As Exception
Console.Write(ex.Message)
End Try
End Sub
รบกวนพี่ๆเพื่อนช่วยหน่อยครับ ขอบคุณครับ
Tag : .NET, Ms SQL Server 2005, VBScript, Crystal Report, Web (ASP.NET), VB.NET