Procedure request

This public forum is for user-to-user discussions of ASP Report Maker. Note that this is not support forum.

Procedure request

Postby vladsn07 » Fri Apr 07, 2017 3:24 am

There is a procedure for obtaining data from the database [dbo].[Statistics].
How can I pass in the data @FromTime = '01 .01.2016 ', @ToTime = '01 .03.2017'? Manually I can convey:

EXEC [dbo].[Statistics] @FromTime = '01.01.2016', @ToTime = '01.03.2017'.

The date can be any, depending on the selected date, a report is generated.

You can get a step-by-step instruction on how to do this?
How to specify VEV if there is no data other than the procedure request?
vladsn07
 
Posts: 55
Joined: Tue Mar 21, 2017 1:10 am

Re: Procedure request

Postby motfs » Mon Apr 10, 2017 10:06 am

Try to use Extended Filter to filter the records. Read Field Setup -> Report Page -> Extended Filter in help file for more detail.

Extended Filter is the closest approach to filter records with user input.
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm

Re: Procedure request

Postby vladsn07 » Tue Apr 11, 2017 10:32 pm

There is no function of manually requesting time from the database.

I have a procedure, it requires parameters @FromTime and @ToTime. How do I request them from the database?
vladsn07
 
Posts: 55
Joined: Tue Mar 21, 2017 1:10 am


Return to General Discussion (ASP Report Maker)