i am creating a solution in which a material is issued to different persons. every material has different types. for every issued material there is issue date. i have generated a report in which i want the list of all the materials which is issued between certain dates.for this i have created a script and entering the dates via custom dialogue and in the calculated result i have used this calculation

Issuing Tapes::g_Issue Date & "..." & Issuing Tapes::g_Issue Date

both the values are global.

what i want is that i also want to enter the types of material along with the issue dates . so there are three input fields in the custom dialog box first is from date second is to date and third is category of product. plz help me how can i achieve the correct result .

Plz help me out

I cant quite follow what you need but I think you are talking about a find. BTW, you range that you posted has the same global as start and end...

Enter Find Mode []

SEt Field [ IssueDate; Issuing Tapes::g_Issue DateFROM & "..." & Issuing Tapes::g_Issue DateTO ]

Set Field [ Product; gProduct ]

Perform Find []

Thanks for your reply.

Now start from beginning:

I have a table with four columns. e.g product_id, prod_category,issue_date and remarks.

Now I want to generate report on certain condition.

I need a report of the product which is issued between 01-01-2009 to 31-01-2009 and prod_category=general. for this report I have three parameter as below:

1. From_date.=01-01-2009

2. To_date.=31-01-2009

3.Prod_category='General'

I used custom dialogue box for this. my both parameter for issue date is working and giving correct out put but when I add the third parameter e.g prod_category "No Result Displayed".

Can you tell me how to overcome this problem ??

Thanks.

-John

Did you try my previous suggestion? Are you sure that gProduct is set to global?

yes i have tried your previous suggestion but its not working and g_product is set to be global. trying your suggestion it's not showing the data that lies between certain dates. it's only showing data depending upon from date it's not taking to date.

i am sending you the attachment of script that i have used.

BTW, you range that you posted has the same global as start and end...

Your set field for the date range has the same start and end global fields.

ok. you sugggest me right i have corrected this ,now its working fine.