Search results for query: *

Thanks, Dell. But, can I sort on a field that is not part of my formula or used in any other way in my report? Thanks, Angie

Hi, I use CR11 and have a group in the header, suppressed if duplicated, then formulas in the detail sections. I put a suppress field in my detail section so I could sort on it, but then my group header repeats for each detail section. Looks like this: [Group Header] Group #1 Name [Detail]...

Hi, I found a closed thread on this subject but I need a little more help. I use CR11 and inserted RecordNumber into a Detail section in my report. It works just fine, but I understand it is a field that cannot be altered. What I need to do is reset the starting number in the next group...

Yes, the text box is in the same row with a formula, and if there is data in the subreport that needs to flow to the next page, the text box is repeated on page 2. It IS a text box and therefore there is no formula associated with it from the database. I can't find any kind of ID or specific...

Hi LB, I see how this could potentially work, but it's a text block and isn't a field from a table. Any suggestions? Thanks, Angie

Sorry, I use CR XI not X. Thanks, Angie

Hi all, I have a subreport that has a text block that is marked "Suppress if duplicated" except that it shows up on the next page if the data flows there. I have the text box and the formula in the Details section, and I'm using CR X. How can I suppress it on subsequent pages? Thanks for...

Sorry 'bout that HTML thing! Thanks for this. Works like a dream. Thank you, lbass! Angie

Hey there- I just found this post from last May asking the same thing: thread149-1369151. Synapsevampire has and alternate solution but I am unsure how to add it to my formula. Here's what he wrote: "Does it already have page breaks in the field? If not, then it will be a trickier, if so...

Hmmm. It didn't change anything. Any idea why? Is there any other way to do this hanging indent? Thanks for your input, lbass! Angie

Hello- Do any of you know if it's possible to format a detail section to show a hanging indent? I want the firstline to be flush left and the subsequent wrapped lines to indent. I use CR11. Thanks for your help. Angie

Hello- This is probably a simple fix, but I'm not understanding why it's happening. I have a simple report that contains one-to-many releationships, one Constituent to many object records. I have put a DistinctCount for Constituent ID in the footer, and it works on all pages EXCEPT the first...

Thank you! It works perfectly. I knew there was a function but I just couldn't find it. Best, Angie

Sorry, meant to also add that I use CR 11. Thanks! Angie

Hi all- I am wondering if anyone can help me. I have a subreport that pulls in information on exhibitions and I am trying to add a period at the end of one particular object report. So far, only this one object reports’ exhibition records end not with a date, but with RegNotes. All other...

If I change the "December" line to this, it's error free: if MyDate[2] = "December" then MyMonth:=12 ); Does this wreck the formula? And what do I do with this once it's correct? THank you, thank you so much for your help...Angie

Thanks for the quick response. Just tried this and CR is asking me for a number after the "12 else" here: if MyDate[2] = "December" then MyMonth:=12 else ''); A

Hello. I started a thread last week and got some great feedback, but I still don't have a workable formula for my issue. Here it is: I use CR11 with The Museum System that utilizes MS Access. I have a text field called Display Date that we use to enter dates for bibliography records and I...

Hi out there- Can anyone help me with this? Much appreciation... Angie

Sorry. Here's the formula I am referring to: whileprintingrecords; stringvar array MyDate:= join({ReferenceMaster.DisplayDate}," "); datevar OutDate; numbervar MyMonth; if ubound(MyDate) = 3 then (if MyDate[2] = "January" then MyMonth:=1 else if MyDate[2] = "February" then MyMonth:=2 else if...