kelsanit
asked on
Crystal linking using view to filter data - Link Type >= or <=
I have the attached crystal report where there are two tables. One is a SQL View I created which provides the current fiscal date info - there are two fields I am using to link data to the InvoiceHeader tableprevious_qtr_start_date
previous_qtr_end_date
I am joining both fields to the "InvoiceHeader.posted-to-ar-date" and selecting Link Type <= for end date and >= for start date.
sample.rpt
In doing so it does not return any records. I have verified same format and still no luck. What is the best way to do this as the view was created to determine the current fiscal quarter and then provide the start and end dates for the previous quarter. The view works great on its own but cannot get to join to data table and return results.
previous_qtr_end_date
I am joining both fields to the "InvoiceHeader.posted-to-ar-date" and selecting Link Type <= for end date and >= for start date.
sample.rpt
In doing so it does not return any records. I have verified same format and still no luck. What is the best way to do this as the view was created to determine the current fiscal quarter and then provide the start and end dates for the previous quarter. The view works great on its own but cannot get to join to data table and return results.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.