Recent content by teamssc

ok, Setting the Parameter data type on the ribbon was the trick. Real lifesaver. Thanks again! (and yes, I'll read why not use parameters prompts)

Thanks Duane, I had used DateValue([Loss Reported]) before, but couldn't get the parameters to work, still can't with DateValue([Loss Reported]). So I'll read the link you posted and see if I can figure it out. Thanks

Access 2016 I've created a query of 2 identical tables, combining different years of data. There is a text field called "Loss Reported". Sample Data "1/1/2018 1:10:25 PM" I created a new field in the query from "Loss Reported" to trim to time and convert the data to a true date (this works...

When you take a memo field and allow it to grow can anyone come up with a way to indent all of the lines, after the first line?

I have a Crystal XI report that is pulling data from a MSSQL database. One of the fields, that is a memo field, has data typed in all CAPS. If there is a punctuation mark in the data then Crystal puts a space before the punctuation mark. I need to take that space out. I'm not really sure...

amazing it would be that hard... but I'll go to work on it thanks

oops, missed this GroupHeader#2 is printing out even if the details are completely empty. Suggestions?

Ok, did it and I agree, now it doesn't matter how tall the details_c section is. thanks

OK, Its Details_c.... I have it suppressed but had it open about 1/2" inch. That took care of it. lbass, no crap, you have saved my life on this project. You are one of the most paitent people I know. I don't have a clue how to thank you enough.

Sorry for being so long getting back to this topic... it's the first day I've made it back to the job site. LB, You're a life saver. I really think I only have a formatting issue at present. I'm getting alot of white space after the Group Header #2. I'm also getting white space after the...

lbass... let me step back through a few things because it's still not working correctly 1) whileprintingrecords; shared BooleanVar noprint; noprint:= isnull({?Manufacturer}) and isnull ({?MfgPartNumber})then noprint: = TRUE Should the this still be used in the subreport? Which by the way I...

lbass, what you suggested about moving the sub to detail_a and the main data to detail_b still formated data correctly and then I screwed something up trying to set something up ... so bear with me till I get back to that point.

lbass, If my subreport is moved to detail_a and my company fields are moved to detail_b then my data is out of order, unless I'm not understanding something...

>>Ok, so you're not trying to suppress an entire section, only certain fields? If so, just format each field you want to suppress using your formula.<< No, It's working correctly and suppressing the subreport when the criteria is not met. My problem is that I'm now not getting the main report...

Almost got what I need by doing the following: I created a Details B and moved the subreport to it. Now either your formula placed in the subreport, or my formula placed in the subreport section expert, and as you suggested "check the 'Suppress Blank Subreport' checkbox", work. I get the...