Search results for query: *

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

Thanks for your input but it is still not what I need. The main report Detail has fields which populate OrderNumber, Company, City, State The subreport then brings up the corresponding Order Information based on matching the OrderNumber (this works correctly) In the subreport I have the...

I'm new to this but if I understand correctly the following is saying create to a varible called "noprint" and if both fields return empty then suppress the detail. whileprintingrecords; shared BooleanVar noprint; noprint:= isnull({?Manufacturer}) and isnull ({?MfgPartNumber})then noprint: =...

lbass, thank you for your persistance and patience... I had such a mental block that I couldn't pass a formula to the subreport I was haveing trouble seeing the obvious. When you asked about how the fields are displaying that is is where I caught the error. In starting to write my...

Thanks for your continued help. I wish I understood this better. I guess I thought the subreport would go in the details section... Yes? No?

The forumla field does show in the linking screen, and yes I can link to it, however the subreport doesn't return any data. I've read somewhere that the formula is the last thing calculated in a report so the subreport runs before the calc is done, thus no data is passed to the subreport...