-
Apr 29th, 2018, 12:08 PM
#1
Thread Starter
Member
Proble with Dataset passin in a RDLC Report in Visual Basic
Hi again,
I am here one more time to solve a strange problem i am facing....
I am developing a project, and at this point i design the reports...
In a windows form i put a Report Viewer, in which i associate
a RDLC Report file.
In the form i am preparing a Dataset who contains a Table
When finish the prparation of the Dataset, i am assign the
Datasource for the Report as follow :
Code:
With Me.ReportViewer1.LocalReport
.DataSources.Clear()
.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("EveryVehicle1", ReportDataSet.Tables("Report")))
End With
the Data set i have prepare is the ReportDataSet
After that, i have Add a new Dataset in my project, named "Every_VehicleDataset.xsd"
There i add a Table named "EveryVehicle1" containg the same things as "Report" Table.
After that i add to the RDLC File a Dataset following thw wizard and choosing the table from "Every_VehicleDataset.xsd"
I named that Dataset as "EveryVehicle1"
After that, i add the fields of the Dataset in a Tablix in the Report File,
and i run my project!
Everything is fine, exept one column of the Table, that is not show data at all!
I have the column, I have the Header, but no Data
Here is a picture with empty column...
Any one can help me?
-
May 2nd, 2018, 06:34 AM
#2
Re: Proble with Dataset passin in a RDLC Report in Visual Basic
Σπερααα.
Haven't used windows reports, just Crystal but 3 options:
Check that the report you create has the this column included (i guess it does, as seen from your picture)
Check that the datatable contains that column and that column brings back data. (somtehing like a ?DataqsetX.DataTable(0)("columnname").ItemArray.Count).
Check that you are in the correct format on the column. Meaning the datatable may have a double and you are trying to convert to datetime. Check the formatting.
ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·
-
May 2nd, 2018, 11:15 PM
#3
Thread Starter
Member
Re: Proble with Dataset passin in a RDLC Report in Visual Basic
Originally Posted by sapator
Σπερααα.
Haven't used windows reports, just Crystal but 3 options:
Check that the report you create has the this column included (i guess it does, as seen from your picture)
Check that the datatable contains that column and that column brings back data. (somtehing like a ?DataqsetX.DataTable(0)("columnname").ItemArray.Count).
Check that you are in the correct format on the column. Meaning the datatable may have a double and you are trying to convert to datetime. Check the formatting.
Καλημέρα!
Every thing you say, i have checked them and its ok all!
The problem is remaining!
-
May 3rd, 2018, 02:57 AM
#4
Re: Proble with Dataset passin in a RDLC Report in Visual Basic
Does ReportViewer have a .DataSources.Update() and .DataSources.Refresh() ?
If so, try using these options after .Clear , μαζί, χωριστά κλπ.
ἄνδρα μοι ἔννεπε, μοῦσα, πολύτροπον, ὃς μάλα πολλὰ
πλάγχθη, ἐπεὶ Τροίης ἱερὸν πτολίεθρον ἔπερσεν·
-
May 4th, 2018, 01:14 PM
#5
Thread Starter
Member
Re: Proble with Dataset passin in a RDLC Report in Visual Basic
Οκ,
What you say i have not try them.
I will and i will let you know!
Thanks again!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|