About gh_cr05

gh_cr05 · 03-21-2024

Hi The following is my sql query output.:I want to return (var Name parTxtID) A24/0012 from the first row second column (text_id) if the parent_aliquot in the second row second column (var parSampNum) 74465 for (var SampNum ) 74466 is equal to the va...

gh_cr05 · 08-04-2022

Hi I have the following formula in a subreport: How can i make these symbols come up as superscript in a report? Thanks If ({TEST.COL1} = "F" and (isNull({TEST.COL2}) or {TEST.COL2} = "NONE")) then " * " Else IF ({TEST.COL2} = "EXT" ) then...

gh_cr05 · 07-25-2022

Hi i run Crystal Reports from an Application. With one subreport i have found an issue. When i run it from the application the Headings in a crosstab report do not wrap correctly. See pic1. However Print Preview from Crystal reports for the...

gh_cr05 · 06-14-2022

Hi I have a crystal report where i need to display a note in the subreport footer based on whether a field in the group above meets a condition. In the attached image the 2nd highlighted note should only be displayed if any one of the Test Methods ...

gh_cr05 · 02-16-2022

Hi I am trying to find a way to group multiple replicates of a column to report all the fields in one table in cross tab. What should I group them by or is there a formula I can use for the crosstab row? Scenario as explained below: 2 replica...

gh_cr05 · 03-23-2024

That code did not work. However i got the solution from elsewhere. I had to create an Alias table on the Sample table and link them in the Database link on the correct field to get this to work. Thanks for the effort put. Regards

gh_cr05 · 09-11-2022

Hi SajeeshSorry for the late reply. I do encounter the same problem as you occasionally. I just manually update the y-axis Maximum scale to a number above the max e.g. in the above case would adjust it to 1.81. For your example I right clicked any p...

gh_cr05 · 09-06-2022

Hi SajeeshDo you create the chart manually in Crystal? In that case you right click on any one of the y-axis values - then go to Scales and set the maximum value to above 1.80. What i have done is created a formula in the chart subreport - i.e. essen...

gh_cr05 · 08-04-2022

I have attached 2 images. The first pic shows the output where there is a double hash followed by some text. The double hash comes from a formula called accredited which is in the second pic. If ({TEST.COL1} = "F" and (isNull({TEST.COL2}) or {TEST.C...

gh_cr05 · 08-04-2022

This gets appended to another text in the subreport.

User Statistics

User Activity

Crystal reports formula get value from another column based on value from a third column

Superscript in Crystal reports 2016 formula

Header in Actual report and Print Preview Crystal Reports Crosstab vary

crystal reports conditional formula for group

Combine cross tab tables in crystal report

Re: Crystal reports formula get value from another column...

Re: Crystal reports multiple series charting

Re: Crystal reports multiple series charting

Re: Superscript in Crystal reports 2016 formula

Re: Superscript in Crystal reports 2016 formula