Sunday March 19th 2017

Categories

Insider

Archives

‘Crystal Reports’ Archives

Exit For

Exit For

The Exit For statement can be used inside the Do Part of For Statement to Stop Execution of the for Statement and continue processing at the next statement following the For Statement as Shown here; StringVar Business:= NumberVar Counter :=0; Booleanvar Found :=False; For Counter :=1 to UBound(Business) Do If ‘Construction’ in Business [...]

Important Array Functions – Redim, Redim Preserve, Ubound

Important Array Functions – Redim, Redim Preserve, Ubound

Redim The Redim Function is used to change the size of an array, numbers of array can be increased or decreased. Redim destroys any element that already exists in the array, the following example will return an empty string; Stringvar array Customer :=; REDIM Customer; Customer RedimPreserve Use the Redim Preserve function to change the [...]

For Statement

For Statement

For Statement is used when we need to execute the same statement multiple times. The Syntax for that is For Counter :=StartValue to EndValue Do Do StatementList; StringVar array Business:=; numbervar counter :=0; Numbervar Matchcount:=0; For Counter:=1 to UBound(Business) Do (if 'Industrial' in Business [...]

Why do we need Unlinked Sub-Reports?

Why do we need Unlinked Sub-Reports?

We quite frequently use the Linked Sub-Reports, however there are certain situations when Unlinked Sub-Reports become very useful. An unlinked sub-report is placed in another report but is not directly linked to data in the main report. Unlinked Sub-Reports are very useful in scenarios like a Dashboard reports each showing a different measure of [...]

Report development Methodology and Documentation

Report development  Methodology and Documentation

Most software products use a specific methodology or combination of several methodologies. A methodology is a set of processes that are executed in a defined order. Report development should also follow a methodology.The traditional methodology of water fall approach is being used by software developers. It commonly consist of steps as [...]

Computing Yields in Crystal Reports

Computing Yields in Crystal Reports

It is often desirable to compare investments, but how does a bond with a cost of $ 24,500, a face value of $25,000, a maturity in 10 years and semi-annual coupons of 6.5% to a bond with a cost of 25,500, face value of $25,500, a maturity in 8 years and quarterly coupon of 7 percent?The yields of 2 bonds can be computed and used as comparison. [...]

PreviousISNULL and NextISNULL

PreviousISNULL and NextISNULL

Previous is null returns the Boolean value True or False depending on the vale of the field in the preceding record. The preceding record is the detail record immediately before the current record in the report. The preceding record in the report might be different from preceding record in the database result set if sorting was not done on the [...]

On Frist Record and Last Record

On Frist Record and Last Record

Very useful and handy functions to evaluate first or last record. On First Record The OnFirstRecord Boolean function returns True if the current Record is first record in the report and False Otherwise. OnLastRecord The OnlastRecord Boolean function returns True if the Current record is last record in the report and False Otherwise.

Suppressing Sub-reports values based on Values from Other Sub-report

Suppressing  Sub-reports values based on Values from Other Sub-report

I came across a scenario where I was needed to supress records in on subreport based records in another sub-report. I used The shared Variable @SharedStatus1 1- Shared Numbervar OrderStatus := {Orders;1.Status}; Status; 2- Then I created another formula @SharedStatus2 in the sub-report where the orders of similar status were required to [...]

Using Static Array Function to pull the data like Branch Offices- NYC, Toronto, London, Singapore

Using Static Array Function to pull the data like Branch Offices- NYC, Toronto, London, Singapore

Static Arrays are quite handy in showing fixed list like NYC, Toronto, London, Singapore. The formula for that is below; StringVar array Cities:=MakeArray('NYC','Toronto','London', 'Singapore'); numberVar Counter :=0; For Counter :=1 to UBound(Degree) do Degree; join(Cities, ',' ); It will Show results like NYC,Toronto,London, [...]

 Page 5 of 16  « First  ... « 3  4  5  6  7 » ...  Last »