Author: shane1961

Posted on

RDLC reporting with parameters

Featured Imgs 23

I have a parameter in a RDLC report named "allocated_jobs"

There are no Available Values assigned.
It has 1 Specify Values: RTrim(Allocated = "True")

ie; Only rows with field name Allocated and it's contents equal "True" are to be in the report.

Me.JobsDataReportViewer.LocalReport.ReportEmbeddedResource = "Data_Reporting.JobsList.rdlc"
*Data_Reporting is the stored report path in my.settings*

Dim param_allocatedjobs As New ReportParameter("allocated_jobs")
Dim reportparameters() As ReportParameter = {param_allocatedjobs}

Me.JobsAppTableAdapter.Fill(Me.ReportJobsDbDs.JobsApp)

Me.JobsDataReportViewer.LocalReport.SetParameters(reportparameters)

Me.JobsDataReportViewer.RefreshReport()

The report runs fine, no errors, but without the desired return of the parameter.

All help welcome, thankyou.

Shane.

Posted on

DateTime in TextBox (Visual Basic)

Category Image 101

My textbox datatype is DateTime.

Using the click event of a button, this code is placed following MyTableBindingSourceAddNew()

Dim CurrentDateTime As DateTime = DateTime.Now.ToString("dd.MM.yy hh:mm:ss")
Me.SaleDateTextBox.Text = CurrentDateTime

I then update table with TableAdapter.

On my form I have a dropdown combobox in a toolbar, display member being "SaleDate"
This displays DateTime, but time is always 12:00:00AM
The SaleDateTextbox.Text populates as Date.Now.

I am not getting correct date and time in both textbox and combobox.

All help appreciated.

Shane.

Posted on

Error with Day Function

558fe5180e0e8fc922d31c23ef84d240

Hi all.

I have this code and it is correct.

Dim logDayName As String = WeekdayName(Weekday(LogDateTextBox.Text))
Dim logMonthName As String = MonthName(Month(LogDateTextBox.Text))

The following code is an error on the Day function.

 Dim logMonthDay As Integer = Day(LogDateTextBox.Text)

Please offer assistance. Thank you, Shane.