Search results for query: *

I have a stored procedure that calls two parameters @Program which asks for a program code input and @MinPo which calls for a minimum Po Amount. The following is my stored procedure: CREATE PROCEDURE MROProgramByDollar ( @program varchar(4), @MinPo money ) AS Select di1.vendor_code...

I have a database where expediting notes are logged by my users and then a date stamp is attached to them. I am trying to extract the latest date for the very last expediting note that was recorded. For example if someone put in one note yesterday and another today I want only today's note to...

Thanks for all your help. I found a solution to my problem. I ended up creating a Global variable in my report header and creating fomulas based on the variable and placing them in the group headers in the report.

I have a field in my report that is a formula. It looks like this: cdbl(Count ({pvmro_orders_over_2500;1.ctlitem}, {pvmro_orders_over_2500;1.internal_po_num})/Count ({pvmro_orders_over_2500;1.ctlitem}, {pvmro_orders_over_2500;1.ctlitem})) I used the cdbl to convert it to a number because I...

Hi synapse, I mean that the fields in Da represent the orders purchased at the start of the fiscal year. I have the report grouped by item number. What I want to show is for each item number when there are no new orders, display the order history which is Db. If there are new orders then just...

I have a report that contains two details sections. I created a second details section to diplsay the exact information as the first with a little difference. Da displays the entire history of orders for a specific part number, Db displays only those records that have been ordered since the...

Thanks, will do!

I need to create a formula that will look at a field ( Expiry Date) and display items regardless of the data type. Unfortunately some of the dates were entered as date/time and others were entered as text. The report is pulling the information from a main frame database where dates are entered...

It stores it as both. If they physically enter the date it stores it as date. If they copy and paste it is stored as text

There is an online page that they can enter expiry date and other information about the part like qty and date rec'd etc. From that page the information is written to a database that stores all this info and from this databse we pull the data for the report. This is all done in real time, so...

I have an existing report that pulls the date from a date/time field. Information is entered into a databse and from there the report is generated. The problem that I am having is that sometimes instead of entering the date, people copy and paste the date in and it is captured as text. I need a...