Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

i want make form to call report with 2 date

Status
Not open for further replies.

farawala

IS-IT--Management
Sep 11, 2007
1
EG
i want to make form to call report which retreive data between two date those i write it in the form .
ijust made the report and i made in it 2 variable called d1 and d2 , then i made button in this form with 2 text item called d1 and d2 then i run the form to call this report but the text item not allow to me to insert the date however i justified the data type and format mask and every thing .
i wrote this trigger in the button (when button pressed):
Declare
d1 date ;
d2 date ;
PL paramlist;
Begin
PL:=create_parameter_List('d1');
PL:=create_parameter_List('d2');
add_parameter(PL,'D1',text_parameter,to_char(d1));
add_parameter(PL,'D2',text_parameter,to_char(d2));
Run_product(Reports,'c:\store_room\by date.rdf',asynchronous,RunTime,FileSystem,PL);
Destroy_Parameter_List(PL);
End;
 
Potentially several problems here. First off, you are passing NULL values into the parameters because D1 and D2 are unassigned. Second, you are creating two separate parameter lists, so only one of the two dates gets passed to the report.

You also mention that the text item does not allow you to enter a date. What error message are you receiving, and what are the names of the fields that contain your dates?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top