Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
About VB.NET, Visual Studio 2010, Win7, RDLC Report...
 
In My project, I have used many RDLC Reports but didn't face any problem.
 
But since I added Report and given Report Data Source "DataSet1" which is having Inner join Query, The Report creates rows but all of them are blank (Rows with no text!)
 
Only text appearing in the report is of header... Other rows are balnk... I have verified all color and other minor settings.
 
I have checked the results putting in Data Grid View... The result is fine... So the only problem is with RDLC report which I cant understand...
 
Code Snippet is here...
 
cmd.CommandText = "select a.cname,sum(j.ctot),sum(j.dtot) from acc a inner join jrn j on a.cname=j.cname where a.type='" & tabs.cmbgroup.Text & "' group by a.cname"
        da.SelectCommand = cmd
        ds.Clear()
        da.Fill(ds)
        accBindingSource.DataSource = ds.Tables(0)
        ReportViewer1.RefreshReport()
        DataGridView1.DataSource = ds.Tables(0)
Posted 25-Jan-13 19:15pm
Comments
Sandeep Mewara at 26-Jan-13 7:17am
   
You speak of SSRS & share code for grid databind? DataGridView1.DataSource = ds.Tables(0)?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web03 | 2.8.150305.1 | Last Updated 26 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100