Avatar of 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

I  am joining both fields to the "InvoiceHeader.posted-to-ar-date" and selecting Link Type <= for end date and >= for start date.
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.

Crystal Reports

Avatar of undefined
Last Comment

8/22/2022 - Mon