I would like to show data around 2 different Views from the given period. Oth Views contain the Data/Time column. If there is no filter, is showing all data. I tried to create such a filter (query)

 

{rpt_print_transactions.Date/Time} >= {?@Start_date} and
{rpt_print_transactions.Date/Time} <= {?@End_date} and
{rpt_copy_transactions.Date/Time} >= {?@Start_date} and
{rpt_copy_transactions.Date/Time} <= {?@End_date}

 

 but is doesn`t work (I see no data in report).

I am calling for help, how it should look it is an Formula?.

 

Thank You in advance

Best Regards

Pzar 

 

{rpt_copy_transactions.Date/Time} >= {?@Start_date} and
{rpt_copy_transactions.Date/Time} <= {?@End_date} or
{rpt_print_transactions.Date/Time} >= {?@Start_date} and
{rpt_print_transactions.Date/Time} <= {?@End_date}

 

but this show only copy transactions.

 

You can show some example how to do the test about which you are writing?

 

Thanks in advance 

In report are some info about user (user ID, L. Name, F. Name ...) from Users.view, some info about print jobs from Pr.transactions.view and some info abou copy transactions from Cp.transactions.view.

 

That is all.

 

SELECT ...

FROM Users

 LEFT OUTER JOIN Pr_transactions ON Users.UserID = Pr_transactions.UserID

 LEFT OUTER JOIN Cp_transactions ON Users.UserID = Cp_transactions.UserID

 

You know that you have users, and they may or may not have printed/copied anything.  You can always filter out the users that have not copied or printed, but you can't do it the other way around.  The Left joins, what is to the left of the word join, forms the base table, and if it is not the user, then you will be limiting and or omitting the people that copied.

 

Check the SQL syntax and see if the joins are as expected.

 

good luck