Member Avatar

I can post a single line of row I selected from datagridview but I want to select specific multiple rows then display it in my crystal report. BTW I'm using VB2010. Dim cmd As New OleDbCommand("Select * From Data1 Where ID = " & Form4.DataGridView1.SelectedRows(0).Cells(0).Value.ToString() & "", Form4.con) Dim adpt As New OleDbDataAdapter(cmd) Dim DtSet As New DataSet Form4.con.Open() adpt.Fill(DtSet, "Data1") Dim crystal As New CrystalReport1 crystal.SetDataSource(DtSet.Tables("Data1")) CrystalReportViewer1.ReportSource = crystal CrystalReportViewer1.Refresh() Form4.con.Close()

Member Avatar
+0 forum 3
Member Avatar

Hi, I tried to view crystal report by using crystal report viewer in Visual Studio 2010. However when i tried to declare ReportDocument, it is underlined with blue curly line. I had done the following in the code behind file. [CODE]Imports System.Data Imports System.Data.Odbc Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports CrystalDecisions.Web[/CODE] the first two crystalDecisions was underlined with green curly line as well, and i had no idea how to solve it. i had done the following in asp.net page [CODE]<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %> ... <form ID="crystalForm" runat="server"> <div> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" PrintMode="ActiveX" …

Member Avatar
+0 forum 2
Member Avatar

I am trying to make a report which gets its data from a windows form's textboxes. My code works fine but upon display of the report, a window always appear asking to enter parameter values. How can I bypass or remove this window? Here is my code: [code] Dim report As rptVoucherReceipt = New rptVoucherReceipt Dim crParameterDiscreteValue As ParameterDiscreteValue Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldLocation As ParameterFieldDefinition Dim crParameterValues As ParameterValues crParameterFieldDefinitions = report.DataDefinition.ParameterFields crParameterFieldLocation = crParameterFieldDefinitions.Item("parAmtWords") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value = frmPremPay.txtAmtWords.Text crParameterValues.Add(crParameterDiscreteValue) crParameterFieldLocation.ApplyCurrentValues(crParameterValues) crParameterFieldLocation = crParameterFieldDefinitions.Item("parPayAmt") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value …

+0 forum 0
Member Avatar

How can I use 'like' keyword with wildcard characters(*) in RecordSelectionFormula of crystal report? [CODE] rptdoc = new ReportDocument(); rptdoc.RecordSelectionFormula = " {View1.RefNo}= '" + textbox1.Text + "'"; [/CODE] I need to use 'like' instead of '=' .....

Member Avatar
+0 forum 3

The End.