Posts

Showing posts with the label crystal-reports

How to compare feet/inches values in Crystal Reports?

Image
Clash Royale CLAN TAG #URR8PPP How to compare feet/inches values in Crystal Reports? I have dimension string value stored in the following format: 0' 0" I need a formula to check whether the value is greater than zero (0' 0"). Can anyone please advise what I need? I am just starting with Crystal Reports. 1 Answer 1 Use the Val() function. Val() Val (str) Arguments str is a text string. str Returns Fractional Number Action The Val (str) function reads a string containing Numbers (example: an address, phone number, or social security number) and converts them to a decimal value. Val stops reading the string when it finds the first character in the string that it finds that it cannot recognize as a number or as a space. Val (str) Val won't it return the same for 0' 0" and 0' 1"? – Peter just now ...

Crystal Reports - Removing duplicates in 2 data fields

Image
Clash Royale CLAN TAG #URR8PPP Crystal Reports - Removing duplicates in 2 data fields I have 2 data fields base on 2 xml files in my Crystal Report. First data field is - EXP TRANSID EXPID PAYMENT MONTH trans01 exp01 1,000.00 JANUARY trans02 exp02 2,000.00 JANUARY Second data field is - FEE TRANSID FEEID PAYMENT MONTH trans03 fee01 3,000.00 JANUARY trans04 fee02 4,000.00 JANUARY trans05 fee03 5,000.00 JANUARY My expected output is this: (I want this to happen) For the month of: January EXP FEE TRANSID EXPID PAYMENT TRANSID FEEID PAYMENT trans01 exp01 1,000.00 trans03 fee01 3,000.00 trans02 exp02 2,000.00 trans04 fee02 4,000.00 trans05 fee03 5,000.00 Is this possible? Thanks in advance! But the output is this: For the month of: January EXP ...

Vertical line not growing in C1reportDesigner(CrystalReport)

Image
Clash Royale CLAN TAG #URR8PPP Vertical line not growing in C1reportDesigner(CrystalReport) I have a report where In detail section I'm using vertical line that vertical line not growing even I set proeprty Anhcor="TopAndBottom" i tried also CanGrow & CanShrink=True but still its not working.I'm attaching screenshot & ReportDesign of it can any one please help.Thanks in Advanced By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.