Click here to Skip to main content
15,564,534 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Please help me with my project work. Pin
Mycroft Holmes27-Nov-13 23:00
professionalMycroft Holmes27-Nov-13 23:00 
GeneralRe: Please help me with my project work. Pin
Peter_jnr29-Nov-13 5:44
professionalPeter_jnr29-Nov-13 5:44 
GeneralRe: Please help me with my project work. Pin
Mycroft Holmes29-Nov-13 13:32
professionalMycroft Holmes29-Nov-13 13:32 
AnswerRe: Please help me with my project work. Pin
Eddy Vluggen28-Nov-13 11:08
professionalEddy Vluggen28-Nov-13 11:08 
GeneralRe: Please help me with my project work. Pin
Peter_jnr29-Nov-13 5:45
professionalPeter_jnr29-Nov-13 5:45 
QuestionRe: Please help me with my project work. Pin
Eddy Vluggen6-Dec-13 6:55
professionalEddy Vluggen6-Dec-13 6:55 
AnswerRe: Please help me with my project work. Pin
Peter_jnr16-Feb-14 12:54
professionalPeter_jnr16-Feb-14 12:54 
QuestionVB 2010 Report is Blank Pin
nyt197227-Nov-13 21:34
professionalnyt197227-Nov-13 21:34 
Hello,

I have this table
XML
RollNo Fee ForMonth
1       500  JAN
2       400  JAN
3       300  FEB
4       400  FEB
5       400  JAN


Created a Crystal Report, Dragged Fields from the Fields List on Crystal Report.

Added a Report Viewer to Form

shows the Report

but when I add parameters it shows blank report

Here is the formula
VB
IF (Length({?forMonth})>0) THEN
{tblFeePayment.ForMonth} = {?forMonth}
ELSE
TRUE



and below is the button Clicked event code

VB
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
       Try
           Dim cryRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
           Dim strReportName As String = "RptFeeReceipts.rpt"
           Dim strPath As String = "D:\Projects\SchoolManagementSystem0821\School Management System\School Management System\Reports\ReportTest.rpt" ' + strReportName
           cryRpt.Load(strPath)
           cryRpt.SetParameterValue("formonth", txtmonth.Text.Trim())
           Dim frm As New FeeReceiptsPrint(cryRpt)
           frm.Show()
       Catch ex As Exception
           MsgBox(ex.Message)
       End Try
   End Sub


And the FeeReceiptsPrint Code is here:

VB
Public Class FeeReceiptsPrint

    Private _cryRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument

    Sub New(ByVal cryRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument)
        ' TODO: Complete member initialization 
        _cryRpt = cryRpt
    End Sub

    Private Sub FeeReceiptsPrint_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        CrystalReportViewer1.ReportSource = _cryRpt
        CrystalReportViewer1.Refresh()
    End Sub
End Class


Pls Help,

Regards.

modified 28-Nov-13 2:50am.

QuestionWhat do i need to dim the textbox name as? Pin
RedIrishMan26-Nov-13 17:21
RedIrishMan26-Nov-13 17:21 
AnswerRe: What do i need to dim the textbox name as? Pin
RedIrishMan26-Nov-13 17:38
RedIrishMan26-Nov-13 17:38 
AnswerRe: What do i need to dim the textbox name as? Pin
Bernhard Hiller26-Nov-13 23:39
Bernhard Hiller26-Nov-13 23:39 
QuestionScroll Bar Acts Wiered Pin
DipeshTrivedi25-Nov-13 4:28
DipeshTrivedi25-Nov-13 4:28 
AnswerRe: Scroll Bar Acts Wiered Pin
Mycroft Holmes25-Nov-13 12:29
professionalMycroft Holmes25-Nov-13 12:29 
QuestionSorting using User Session Pin
Commish1323-Nov-13 15:14
professionalCommish1323-Nov-13 15:14 
AnswerRe: Sorting using User Session Pin
Bernhard Hiller24-Nov-13 21:51
Bernhard Hiller24-Nov-13 21:51 
QuestionFunction Calling 2 Different Stored Procedures Pin
Commish1322-Nov-13 7:18
professionalCommish1322-Nov-13 7:18 
AnswerRe: Function Calling 2 Different Stored Procedures Pin
Richard MacCutchan22-Nov-13 8:06
mveRichard MacCutchan22-Nov-13 8:06 
GeneralRe: Function Calling 2 Different Stored Procedures Pin
Eddy Vluggen22-Nov-13 8:09
professionalEddy Vluggen22-Nov-13 8:09 
GeneralRe: Function Calling 2 Different Stored Procedures Pin
Richard MacCutchan22-Nov-13 8:33
mveRichard MacCutchan22-Nov-13 8:33 
AnswerRe: Function Calling 2 Different Stored Procedures Pin
Eddy Vluggen22-Nov-13 8:07
professionalEddy Vluggen22-Nov-13 8:07 
GeneralRe: Function Calling 2 Different Stored Procedures Pin
Commish1322-Nov-13 9:22
professionalCommish1322-Nov-13 9:22 
GeneralRe: Function Calling 2 Different Stored Procedures Pin
Eddy Vluggen26-Nov-13 12:28
professionalEddy Vluggen26-Nov-13 12:28 
Questionhow to display the size of the camera sensor in vb.net Pin
fitriadinurdin21-Nov-13 20:33
fitriadinurdin21-Nov-13 20:33 
QuestionRe: how to display the size of the camera sensor in vb.net Pin
Eddy Vluggen22-Nov-13 8:11
professionalEddy Vluggen22-Nov-13 8:11 
QuestionOverlapping with a Picturebox other controls having the picturebox transparent background VB .NET (update) Pin
jose mandurrino19-Nov-13 0:35
jose mandurrino19-Nov-13 0:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.