Showing posts with label holds. Show all posts
Showing posts with label holds. Show all posts

Thursday, March 22, 2012

Crystal Reports and Objects

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

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

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