|
You need to handle programatically
Some thing like this
With reportDocument.ReportDefinition.Sections("Section3")
DirectCast(.ReportObjects("Borrower"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.LS_LockConfirmation_CO.Item(0).PrimaryBorrower
DirectCast(.ReportObjects("BorrowerName"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.LS_LockConfirmation_CO.Item(0).PrimaryBorrower
DirectCast(.ReportObjects("CoBorrowerName"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.LS_LockConfirmation_CO.Item(0).PrimaryBorrower
End With
Chinna Srihari,
Tech Lead, Capgemini
|
|
|
|
|
hii ,
thank u for the code ..
i need to to translet to me somethings ,
what ReportObjects("Borrower") stand for ?
and what is dsLockConfirmationCO stand for ?
how can i use this code ?
thank u .
|
|
|
|
|
Hi,
This is quit simple
In Report designer we have
Report Header (Section 1)
Page Header (Section 2)
Detail (Section 3)
So in Section 3 we have lables and its value to be displayed.
here ReportObjects("Borrower")--> Borrower indicates value field name
dsLockConfirmationCO is dataset object from which we need to assign the value
Chinna Srihari
Tech Lead, Capgemini
|
|
|
|
|
hellow ,
thank u for ur help ..
but i am sorry i can't figure out how to use the ( dsLockConfirmationCO )
and how do i assign values to it !
can anyone help me ?
thank u
|
|
|
|
|
Hi,
This is how it works.
We need to display the data in report.
One case is retrieve the data from data base, assign it to reports.
here dsLockConfirmationCO is typed dataset which i have populated from database.
In your case you may be retrieving data from data base and display it on the report. So, create your own dataset and populate it and assign the values to report object.
Here in my case dsLockConfirmationCO is dataset do nopt confuse
Srihari Chinna
Tech Lead, Capgemini
|
|
|
|
|
hellow ..
here is my code ,
Dim reportDocument As New rptStationsGroup
Dim dsLockConfirmationCO As New DataSet
dsLockConfirmationCO = New DataSet("BusLines")
With reportDocument.ReportDefinition.Sections("Section3")
DirectCast(.ReportObjects("BusLineNo"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.LS_LockConfirmation_CO.Item(0).PrimaryBorrower
End With
in dsLockConfirmationCO i have a blue line , that say .
'LS_LockConfirmation_CO' is not a member of 'System.Data.DataSet'.
thank u
|
|
|
|
|
Hi Man,
dsLockConfirmationCO is dataset
LS_LockConfirmation_CO is table in dataset
Item(0) is Row
PrimaryBorrower is field in typed dataset
Chinna Srihari,
Tech Lead, Capgemini
|
|
|
|
|
hi , i understand , but when i write this code
Dim reportDocument As New rptStationsGroup
Dim dsLockConfirmationCO As New DataSet
dsLockConfirmationCO = New DataSet("BusLines")
With reportDocument.ReportDefinition.Sections("Section3")
DirectCast(.ReportObjects("BusLineNo"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.Tables.Item(0).Columns("BusLineNo")
End With
i recive :
Value of type 'System.Data.DataColumn' cannot be converted to 'String'.
|
|
|
|
|
Hi
Have you populated the dataset.
Give me the complete method code and let review.
|
|
|
|
|
hi ,
what u mean by populated ?
i have a CrystalReport it is a file ,
i view it in crystalviwer , when i click a button i run this code
Dim reportDocument As New rptStationsGroup
Dim dsLockConfirmationCO As New DataSet
dsLockConfirmationCO = New DataSet("BusLines")
With reportDocument.ReportDefinition.Sections("Section3")
DirectCast(.ReportObjects("BusLineNo"), CrystalDecisions.CrystalReports.Engine.TextObject).Text = dsLockConfirmationCO.Tables.Item(0).Columns("BusLineNo")
End With
thank u for ur patience ,
|
|
|
|
|
sorry for disturbing , anyone have any idea or other method ?
|
|
|
|
|
i've created a program (VB.NET + SQL 2000 + CrystalReports)
the program running greate on the same machine where i've developed on it.
but when i create the setup and install it on other machine, the problem appears....
"when i click on the button that calls the CrystalReport.rpt an unhandled exception thrown telling me the a V6.dll file not found or something like that... "
what i should do?
Militiaware
Faris Madi
|
|
|
|
|
You need to install Crystall report as well
Chinna Srihari
Tech Lead, Capgemini
|
|
|
|
|
thanx for the tip Mr. Srihari
if i want to intall the crystal report.. where is shall found it in the VS kit.
Militiaware
Faris Madi
|
|
|
|
|
Hi,
you do get it from the .NET CD.
Or try this
http://thinstall.com/help/index.html?crystalreports9forvisuals.htm
I have installable with no way that i can send it to you.
I am sorry for that
Chinna Srihari,
Tech Lead, Capgemini
|
|
|
|
|
Also
http://www.microsoft.com/downloads/details.aspx?FamilyID=0cecc8ab-92dd-402b-a590-c623bc8daf52&DisplayLang=en
Chinna Srihari,
Tech Lead, Capgemini
|
|
|
|
|
thanx again Mr. Srihari
but you make me like swimming in the jungle...
and this is this first time dealing with Crystal Reporst....
Is there any way to build a merge module (deploying) can include the crystal reports DLLs, without entering that jungle....
Militiaware
Faris Madi
|
|
|
|
|
what is wrong with following code:
Private Sub DgridSR_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
If DgridSR.Col = 3 Then
DgridSR.Columns(3).Text = Val(DgridSR.Columns(1).Text) * Val(DgridSR.Columns(2).Text)
End If
End Sub
|
|
|
|
|
I think the handle part is missing at the end of defnition line
Private Sub DgridSR_RowColChange(LastRow As Variant, ByVal LastCol As Integer) handles DgridSR.RowColChange
Other wise tell us the error happening with you and we shall try to help you out of this issue
Regards
Rizwan Bashir
|
|
|
|
|
dev dhoundiyal wrote: what is wrong with following code
Syntactically, not alot - why do you get an error? Do you not get the behaviour you expect? What behaviour do you expect?
Do you think that providing more information would have helped us answer your question?
Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-- modified at 8:08 Wednesday 10th May, 2006
|
|
|
|
|
how can we make a combo to remember last selected value when application starts
|
|
|
|
|
Same as anything you want an application to remember anything, save it to somewhere and retrieve it when needed.
Save it to registry or local file (local ini or config) if you want it to affect the local/cliend user.
Save it to database or server file if you want it to affect all users.
Save it to database and manage with user profile if you want more sophisticated "remembrance".
YMMV.
|
|
|
|
|
if it has this control, it support unicode or not.
|
|
|
|
|
VB.NET doesn't come with a .NET chart control.
I recommend that you use the ZedGraph[^] chart control. It's feature rich, looks great, and it's free.
|
|
|
|
|
If you want a free chart component you can use OWC11 library (office web component library).
I have used this and its ok.
Mandar Patankar
Microsoft Certified professional
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
