Comments by Member 10424744

Member 10424744 24-Jan-14 12:11pm View

what can i do now ?

Member 10424744 24-Jan-14 12:05pm View

yes i have records
can i take out firstORdefault?

Member 10424744 24-Jan-14 12:01pm View

its showing null , what can i do now ?

Member 10424744 28-Nov-13 15:57pm View

i didt created, somebody has created .. when i running for report for some id its showing the data and for some its not showing the data . and there is data in the database ..

Member 10424744 28-Nov-13 15:51pm View

where is crystalreportdatabase ?

Member 10424744 26-Nov-13 14:18pm View

Deleted

Try
Cursor.Current = Cursors.WaitCursor
maConnection = InstantierConnexionBD()
Dim cryRpt As New Combined
'Report principal
Dim reportViewer As New ReportViewer
Dim strSql = My.Resources.SQLCellSiteGroupBySectorTechno.ToString
Dim dscmdFirst As New SqlDataAdapter(strSql, maConnection.getConnection)
Dim dsFirst As New DSCellSite
Dim dt As New DSCellSite.DataTable1DataTable

dscmdFirst.SelectCommand.Parameters.AddWithValue("@siteid", sLocation.getInstance.Location.Trim)
dscmdFirst.SelectCommand.Parameters.AddWithValue("@Version", sLocation.getInstance.Versions.Trim)
dscmdFirst.Fill(dsFirst.DataTable1)

cryRpt.SetDataSource(dsFirst)

'First SubReport CCNr

Dim strRptCCN = My.Resources.SQLReportsBySAnt.ToString
Dim dscmd1 As New SqlDataAdapter(strRptCCN, maConnection.getConnection)
Dim strRptGeneralInfo = "Select * from VRptCellSiteData2 Where locationID ='" & sLocation.getInstance.Location & "' And VersionsNum ='" & sLocation.getInstance.Versions & "'"
Dim dscmd2 As New SqlDataAdapter(strRptGeneralInfo, maConnection.getConnection)
Dim ds1 As New DSCellSiteSAnt
Dim da1 As New DSCellSiteSAntTableAdapters.vCCNRepFullTableAdapter
Dim da2 As New DSCellSiteSAntTableAdapters.vCCNRepBaseTableAdapter

dscmd1.SelectCommand.Parameters.AddWithValue("@siteid", sLocation.getInstance.Location)
dscmd1.SelectCommand.Parameters.AddWithValue("@AntVersion", PreviousVersion)
dscmd1.SelectCommand.Parameters.AddWithValue("@PostVersion", sLocation.getInstance.Versions)

' verifier si dscmd1 est utilisé. le commenter et l'enlever du code

dscmd1.Fill(ds1.vCCNRepFull) 'DataTable1= rptCCN
ds1.EnforceConstraints = False
dscmd2.Fill(ds1.DataTable2) 'Entete

da1.Fill(ds1.vCCNRepFull, sLocation.getInstance.Location, sLocation.getInstance.Versions)
da2.Fill(ds1.vCCNRepBase, sLocation.getInstance.Location, PreviousVersion) 'singletonLocation.getInstance.Versions)

MakeFullCCNReport(ds1.vCCNRepFull, ds1.vCCNRepBase)
cryRpt.Subreports("CCNTestSAnt.rpt").SetDataSource(ds1)

' ''Second SubReport Antenna
Dim strSql3 = "Select * from VrptCombineAntennaFeeders Where SiteID ='" & sLocation.getInstance.Location & "' And VersionsNum ='" & sLocation.getInstance.Versions & "' Order by AntennaNumber"
Dim dscmd3 As New SqlDataAdapter(strSql3, maConnection.getConnection)
Dim dsSubReport3 As New DSCombinedFeeders
dscmd3.Fill(dsSubReport3, "VRptCombineAntennaFeeders")
cryRpt.Subreports("Antenna").SetDataSource(dsSubReport3)

'' ''third subreport listening Antenna
Dim strSql4 = "Select * from VrptAntennaListing Where SiteID ='" & sLocation.getInstance.Location & "' And VersionsNum ='" & sLocation.getInstance.Versions & "' order by AntennaNumber"
Dim dscmd4 As New SqlDataAdapter(strSql4, maConnection.getConnection)
Dim dsSubReport4 As New DSAntennaListing
dscmd4.Fill(dsSubReport4, "VrptAntennaListing")
cryRpt.Subreports("AntennaListing.rpt").SetDataSource(dsSubReport4)

'Rename Exported File
If isPreview Then
maConnection.getConnection.Close()
reportViewer.CrystalReportViewer1.ReportSource = cryRpt
reportViewer.CrystalReportViewer1.Show()
reportViewer.CrystalReportViewer1.Refresh()
reportViewer.Text = "Report Combined"

reportViewer.Show()
Cursor.Current = Cursors.Default
Else
Dim reportName As String = "RptSLS-" & sLocation.getInstance.Location & "-V." & sLocation.getInstance.Versions

Member 10424744 26-Nov-13 13:32pm View

i have data in database but that data is not displaying in the crystal report .so please tell me where should i check

Member 10424744 26-Nov-13 13:10pm View

i have data in database but that data is not displaying in the crystal report .so please tell me where should i check

Member 10424744 25-Nov-13 12:19pm View

when we select somethg in dropdown box for eg : selecting A,B,C D .IN THE COMBBOX IT SHOULD NONE,A,B,C,D...

Member 10424744 25-Nov-13 12:16pm View

Please tell me what to do . i sent my code please check

Member 10424744 25-Nov-13 11:10am View

Public Sub LoadClusterInfo(ByVal clusterID As String, ByVal operation As OperationEnum, ByRef entities As RFDBEntities)
entities = New RFDBEntities
_clusterID = clusterID
_entities = entities
_operation = operation
_securityStatus = security.GetInstance.isDesigner Or security.GetInstance.isApprouver
If _securityStatus = False Then
If security.GetInstance.isAdmin Then
_securityStatus = True
End If
End If
cboHostsiteId.Text = "None"
cboHostsiteId.Items.Add("None")

SelectSecurity(_securityStatus)

FillFormCluster()

Member 10424744 25-Nov-13 11:05am View

still its not showing in the dropdown ,just its displaying in the combbox , ia m not able to select none ,other data is coming from database but i wan to select none , its not what shall i do

Member 10424744 25-Nov-13 10:24am View

its showing in the combobox now , but when i click it s not show in dropdown and if i select none i should write code for displaying none what should i write and where

Comments by Member 10424744 (Top 13 by date)