Search results for query: *

I'm trying to show these titles when month number is input. When number 1 to 6 is entered all the months is visible but when number >=7 is entered JUL to DEC is not visible. Where did the code go wrong. Help.. Also if there is more elegant way of coding this that would be great. Thanks. The...

I'm using CR XI. I have two group headers GH1 and GH2. GH1 is a grouped by Name and GH2 is grouped by Run Numbers. I have column titles for GH1 in Page Header but how to create column title for GH2 and not have it repeat in the same page but on different page? Thanks.

Hi: We lost our CR Enterprise 9 CD. We called Crystal and the Customer service said that they've just took down the link to download it last week and don't have the CD anymore, which is hard to believe. But if anyone out there knows of any link to download or anyone can burn us the CD, we would...

Yeah, I looked again at the 22 x 22 and no way it can fit 150 fields. So I program VBA to open the other 3 reports when users click on the first report. This way they don't have to click 3 different times. Thanks for your help.

Even on 21" x 21" all 150 fields does not fit across. So what I did was use Legal size page setup and broke down the report into 4 separate reports ie. r_Datasheet1 to r_Datasheet4. I wanted to put all 150 fields into one so I have to run the report one time and not four separate times. I hope...

I'm designing a report with 150 fields and wanted to find out a way to fit them in a single design view report. If using a legal size landscape page setup I have to use 4 design view pages and therefore have 4 different reports instead of having 1 report with 4 pages. Thanks.

Using CR 9. My Data: PCR# MEDS 10-01-2446 MID 10-01-2446 MOR My Formula: Minimum(Meds, PCR#)&" & " &Maximum(MEDS, PCR#) to get "MID & MOR". I want to filter the report that only shows "MID & MOR". How can I bind the formula to the selection criteria? Thanks.

Thanks LB. Worked like a charm. You ROCK!!

Hello: Environment: CRX field1: PC 647(F) PC 647F,647F,647F,647F,647F CONDITI ;PC 148(A) 30/10 would like to count how many times the variation of PC 647(F) or 647F or 647(F)occurs in this field. I tried instr function but only gives me the first occurence. Thanks.

Thanks for the link. Yes both queries have parameter promts and in this case I have to enter 4 parameters. Start and End date for both queries. I'm trying to limit entering start and end date to just twice. It's more of passing the parameter from 1st query to second query.

Hello: I am trying to create a report that uses two queries and both queries uses parameters. q_HRI and q_HRI_Refs both is prompting for start and end date. How can I pass the start and end date from q_HRI to q_HRI_Refs. The reason for using two queries are the data from each queries are...

Hi: Is it possible to dlookup fields from queries? I tried this: =DLookUp("[HRI Refused Svcs]", "q_HRI_Ref/Refsd_Cnt", "[Program] = '10'") It didn't work maybe because the syntax is wrong. Perhaps there is a better way to reference fields from queries. If it's not possible, maybe I can...

Ok. Looks like I'm having about the same problem as some people but not quite. I am using CR9. Here is my data: Name Jan Feb Mar Apr EMT1 Ttl Runs 4 18 19 25 Ttl Late 0 1 6 2 % Compliance I'm not sure how to do that because %...

Hi: This is my formula: =DLookUp("[CONTACT/REF DATE]","tbl_Referred","[NAMEDATE] = '" & [Reports]![rpt_Ref_Clients_All]![NAMEDATE] & "'") This works to look up the same value of the same record but I would like [CONTACT/REF DATE] value from the next record and so I tried...

Hi lbass: Thank you. That worked. But for learning purposes, can this be done with while do loop? Like while {PTID} = groupmember do {ICD_Text}. What do you think?

I would like to concatenate these records so that they are in one record like: RECNO PTID ICD_TEXT 4 0002 TWO STAB WOUNDS TO BACK;L THIGH HEMATOMA; RECNO PTID ICD_TEXT 4 0002 TWO STAB WOUNDS TO BACK 5 00003 L THIGH HEMATOMA 6 00004 MULTIPLE LACS 7 00004 R MIDDLE AND LOWER LOBE...

I am trying to background color the whole GroupHeader Section but this code doesn't work. What's wrong? Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If [Mos_Enrolled] > 0 Then GroupHeader0.BackColor = 12632256 End Sub This is an Event Procedure that I put in...

begins with "=

So here's the result with both unions and "WHERE" statement where it is now. Org_Type tbl_Prov.Prov tbl_OBGYN_List.Prov DR. A DR. B DR. E HOSP HOSP_A HOSP_A HOSP HOSP_B HOSP_B PEDIA HOSP_C HOSP_C OBGYN OB A OB A OBGYN OB B OB B OBGYN OB C OBGYN OB D PEDIA PEDIA...

Not quite. A field in my form, example: Providers Vacc_Ordered Vacc_Filled ABD 100 50 CAD 500 500 So, Vacc_Filled field is some kind of formula and will automatically calculate based on some criteria. From time to time, we...