Thank You for the promt reply. I have tested both forumlas and they suppress all the records including the first and fifth.
I was thinking of getting the sum of the record count. If the sum is less than 10 then suppress all the records in the detail section, however I cannot sum the count...
I need to supress all the records in the detail section of a report if the record count is less than 5. If the record count is greater than 5 then display only the 1st and 5th record.
I have a running total formula that performs the count however it is not suppressing the 1st record if the...
DATE1 = totext(datetime({Anaheim_Import_Data.Incident_Date}),"MM-dd")
DATE2 = totext(datetime({Anaheim_Import_Data.Total_Date}),"MM-dd")
I cannot do the math of:
if not(isnull(DATE2)) then DATE1 - DATE2
I tried tonumber(totext(datetime({Anaheim_Import_Data.Total_Date}),"MM-dd") and several...
This worked perfectly to display the data.
totext(datetime({Anaheim_Import_Data.Incident_Date}),"MM-dd")
It does not let me perform simple addition or subtration.
In an access database the field "date1" is a text datatype that is formatted as "yyyy-mm-dd hh:mm:ss"
How do i shorten this to display only "mm-dd"?
I'm getting the left side but i need it to cut off.
LEFT({Anaheim_Import_Data.Incident_Date},6)
How do I convert this to "mm-dd-yyyy"?
I need a cross tab that sumarized the time for each department. The time on the database is in integers. I need this formula to format the time in a useful manner. I receive an error " A print time formula that modifies variables is used in a chart or map"
Help Appreciated!
NumberVar...
Thank You all for the replies. That was great perspective.
I stated my reasons why I think its appropriate to update the user id and sent it in written form to my senior team member.
If there is still disagreement then I will ask the senior member to inform the user.
I'm the junior member of a application support team. A user requested to have their user id updated due to a name change. The windows team has already updated the users id and email. However for this specific application we cannot update the existing id. We will need to create a new one and...
i want to automate the subtraction of the pay_amount from the balance. The columns are on different tables?
create or replace trigger test1
after insert or update or delete
of pay_amount on payment
for each row
BEGIN
select pay_amount into :new.balance from payment;
END;
/
When I need to view sqlserver data I can drag a database table directly onto the webpage. I am unable to drag a database view.
I am trying to display query results and I saved that query as a view.
Help appreicated.
in a section below the one containing your subreport.
Is there a workaround for this? My subreport is in the group footer but I need the date in the page header.
Help Appreciated! My subreport has date parameters in the page header. I would like to print that date parameter in the page header of the main report.
I tried a shared variable to no avail
Sub:
whileprintingrecords;
shared datevar x:={?end_date};
Main:
whileprintingrecords;
share datevar x...
Thankyou for your help. There are some changes and now the code should assign XX to BLD (i,J) if the B021 is present. I added a while loop, but not able to test it yet.
SELECT COUNT(*) INTO V_PV_COUNT
FROM C_ACTION
WHERE C_CNO = :NEW.CSM_CNO
AND C_TYPE =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.