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...

Solved this myself. Rookie error. I needed to enforce the join between the tables on the view.

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...

Lbass once again your a lifesaver. I was really overcomplicating my solution and spent a very frustrating day trying to find a solution. You definitely helped me have a bright start to my monday. Thanks a million, Kieran

If I do need to a date range array, any help in how to build this would be much appreciated.

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...

thinking about it Ian's suggestion seems the only feasible solution to me. I could use a subreport of the demographic which takes the date para from the original report and use Ian's trick and then pass back the demographic date into the main report.

lbass and Ian; It will always be the one combination of the two years values per the entire report and will not change per group or account. I was also wrong in saying that it will be current year and current year minus one. If the user runs a report it will first look to grab the same year...

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...

Madawc, sorry about that Verson 11. Lbass once again you come through with the goods. Good lateral thinking there ! Many thanks

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...

i have worked out how to do this using variable counters that reset according in the group section and in the page headers.

PS this is crystal reportts v11

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 -...

Lbass your a saviour. Man it was so simple and i was starting over complicate it using arrays etc. In a second you fixed it up for me. Thanks a bunch !

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...