jeffs88keys

Very grateful for your time. I will give this a shot. Thank you !!!

Hello, I understand that this may be an html box on my report. I need to accomplish the following, and I'm not sure if can be done. If [field1] is blank or if [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS OUT OF COMPLIANCE" (and maybe in red???) (otherwise) if [field1] is blank or [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS IN COMPLIANCE" (and maybe in blue???) Thanks !!!

@CoopperBackpack I think we may be off. This is not a details datapage...this is a tabular report. I completely used the wrong terminology and I'm so sorry. Seeing the screenshot below, the elements that you see beginning with Vacation_Entry are the details shown in the example above. The two elements beginning with Trips_V2 are the 2 fields that are being tested to create either of the 2 return phrases that I'm looking for. I hope that clarifies easier. I'm sorry if I wasted your time with the previous snafu in terminology.

Hi @CoopperBackpack, Sorry for the delay..... my notification didn't go off. So I have this on a Details Report, and is based on a 2 table view. Table 1 lists the "trips", and Table 2 lists the components of the trip. The Details report shows the details of the Table 2 trip, but I am looking for the query above to be based on the Table 1 "trips". So if [trips:field 1] (text field) is blank OR if [trips:field 2] (file upload) is empty, then it creates the statement above in Red. Otherwise, a different statement is made (see OP above). I've attached a sample of what the display would look like.

Thanks, but Rules don't apply for what I'm looking for. Thanks.

Hello, I understand that this may be an html box on my report. I need to accomplish the following, and I'm not sure if can be done. If [field1] is blank or if [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS OUT OF COMPLIANCE" (and maybe in red???) (otherwise) if [field1] is blank or [field2] (a file upload field) is empty, then return a statement "DISCLAIMERS IN COMPLIANCE" (and maybe in blue???) Thanks !!!

This worked perfectly. Thank you so much for your time to help me.

Thank you so much for this. I'll give it a shot.

Hey guys....real rookie here, so any help appreciated. I have a details report set up that is derived by using a passthrough external parameter. From the details report, I would like to have a button to "Add a New Record" which will include the same passthrough parameter variable into a form. How do I create the button (separate html code on my web page?) and how do I setup the passthrough parameter on the button? Thanks !

So, I've come up with a wish list for my existing app. Unfortunately, it will require a basic re-write of about 1/2 the datasheets. I'm wondering what would be the best way to do this, while still allowing my existing apps to continue working. What I don't want to do is create new datasheets for testing purposes, and then come back to the original ones and modify them. I'd rather create new ones and then replace the old with the new. But I need to make sure the data is in place. Just looking for any thoughts from someone who has done this before.

2 tables: Sales_person and Sales_Entry. Sales_Entry is authenticated by the email address of the sales_person. I would like to create a 2nd user (the sales person's assistant) to be able to have their own login, yet have record level authenticated access to the sale's person's data. (The purpose for this is to eventually provide the assistant with filtered data not including all the information that the sales person sees). Is there a way to create an authentication that accesses information that is already authenticated to another user? (If that terminology makes sense) Thanks !

I"m using Compliance version, and it seems the "Details" feature in DataPage Reports does not work correctly. Once the details are loaded, I attempt to click on any field and I'm taken to the URL shown below. Anyone else experiencing this? Thanks !!

Thank you, however, I'm trying to run a report that basically has 2 forms of criteria. This year to date AND last year to date. I fully understand how to do one of them (your link), but not to produce the report with both sets of criteria. Thanks

I have a table called "Sales" which has fields Salesperson, Date_of_Sale, and Sales_Amount For any given Salesperson, I would like this report to show the sales for the current year-to-date AND the prior year-to-date. I'm completely comfortable with creating it if it were only for this year, but how do I get the field in place to reflect the prior year-to-date as well as make a subtraction between the 2 fields? At a loss, and I appreciate the help.

Hi, @Vitalikssssss Thanks for the reply. I'm not sure this is what I'm looking for. I'm actually looking for the ability to enter multiple items in the original Form (sales order form), not in a Report. (Assume I don't have any records yet, and I want to add more based on someone keying in their sales order).