I have an object called vehicle for talk sake and vehicle holds an ID for a customer
I then have an object called customer. which holds customers details
These are all in a project called project1 in visual studio 2005
I have another project project 2 with my forms etc and a crystal report.
This project has a reference to project1 however when in my crystal report is it possible for me to use the vehicle object and subsequent customer object as the source for the data and if so how is this done.If both points to same database then you can design the report having the data from those objects
Showing posts with label holds. Show all posts
Showing posts with label holds. Show all posts
Thursday, March 22, 2012
Tuesday, March 20, 2012
Crystal Reports - Suppress Section
Hi,
How do one suppress a section if ANOTHER section is suppressed.
The one section holds details such as Name, Surname, Contact Number.
I have insert a "Suppress Blank Section" that will suppress that section if it's blank. However, how do i suppress the OTHER section based on this section.
Suppression Rule: ??
English: Suppress section 1 if section 2 is suppressed
Thanks in advance.Is that another section a GF/GH ?
If yes, yo can suppress it conditionally when:
Count ({table.name}, {table.group_field})=0
How do one suppress a section if ANOTHER section is suppressed.
The one section holds details such as Name, Surname, Contact Number.
I have insert a "Suppress Blank Section" that will suppress that section if it's blank. However, how do i suppress the OTHER section based on this section.
Suppression Rule: ??
English: Suppress section 1 if section 2 is suppressed
Thanks in advance.Is that another section a GF/GH ?
If yes, yo can suppress it conditionally when:
Count ({table.name}, {table.group_field})=0
Crystal Reports
Sample Code:
-----------------------
g_m_cnnRAM.BeginTrans
ChangeClosingStock // The Function Which Holds Views
crReports.SQLQueryString = Select LotNo, Variety, Cl_Kgs, Value from ClosingStockView
frmViewer.Show
frmViewer.CRViewer1.ReportSource = crReports
g_m_cnnRAM.CommitTrans
frmViewer.CRViewer1.ViewReport
frmViewer.CRViewer1.Zoom (1)
------------------------
The Above is the Sample Code. After the CommitTrans, the ViewReport is Called. At this time if ClosingStockView is Altered, I Get the Someother Modified Data instead of my Data. If I give CommitTrans After ViewReport the System gets Hung.
Find me a solution for this.
Ashok.SSend me the code so that I can check
-----------------------
g_m_cnnRAM.BeginTrans
ChangeClosingStock // The Function Which Holds Views
crReports.SQLQueryString = Select LotNo, Variety, Cl_Kgs, Value from ClosingStockView
frmViewer.Show
frmViewer.CRViewer1.ReportSource = crReports
g_m_cnnRAM.CommitTrans
frmViewer.CRViewer1.ViewReport
frmViewer.CRViewer1.Zoom (1)
------------------------
The Above is the Sample Code. After the CommitTrans, the ViewReport is Called. At this time if ClosingStockView is Altered, I Get the Someother Modified Data instead of my Data. If I give CommitTrans After ViewReport the System gets Hung.
Find me a solution for this.
Ashok.SSend me the code so that I can check
Subscribe to:
Posts (Atom)