Search results for query: *

Version 11 Crystal. I need to store a date value from a status history record and then use that value in the next occuring status history record. Group 1 Case File Number Group 2 Status Record Number In group 2 if Status Outcome = Refused then store Decision Date. Then go to next Status...

If you using crystal 12 you can do optional prompts and date ranges, however you may have a problem using min and max function when its optional. Here is my solution so you can display the date range on your report: if not hasvalue ({?start date}) then "No Date Range Selected" else if...

Relating to BO XI I have only just started working with Business Views and List of Values (LOV) so my predicament is probably easily sorted. I have a business view joining three tables. Table A Table B Table C Episode Clinic Region Code 1 1...

I will begin by describing what i want to achieve and then the methodology that i think i could use to achieve it (any other solutions gratefully accepted). Using CR 11. User will put in a date range which runs the report. ie 1 Jan 2007 - 31 Dec 2007. I then want to run the report pulling...

I want a formula that can take a Date (Year) parameter, and look through my data set and find data that is minus one year of the parameter. However if the minus one year data is not available it needs to keep on looking back until it finds a year with some data. ie user enter 2008. I then...

I need to have superscripted footnote markers on these columns for some medical reports i am designing. Crystal doesnt handle supersript so instead i have been free-form placing a small text object of the * or # next to text but slightly above it to give the appearance that its superscripted ie...

This should be a simple fix but i am a bit stuck getting finding a way to make it work. I have a report with a series of subreports sitting in the group sections Page Header - contains a set of Column Headings etc etc etc GF1 A - subreport 1 GF1 B - subreport 2 GF1 C - subreport 3 GF1 D -...

I am trying to figure out something which should be very simple (I would have thought). Group Header 1 Region North Group Header 2 Patient Gender Male Group Header 3 Age Group 25-34 Group Header 4 Patient Episode *...

I have seen some posting on this topic already but i just cant get it to work for my scenario. I have a cross tab that i want to display with decimal points for the percentage values. When i do it crystal is truncating the decimal points to zero decimal points and hence the percentage values...

I have a crystal crosstab like this Symptom A Symtom B TOTAL No of Males 3 7 10 No of Female 6 1 7 However I would like to both suppress any values in the symptom A and Symptom B column that are...