Can you describe the difficulty you are having?
(I have joins that reference the today() function in catalogues against SQL server and PROGRESS databases.)
I can add a field that uses the today function within the folders option but am unable to add it to the area where joins are created. I want to be able to work out the companies week number from todays date, the week number is held within a SQL table.
Another useful technique to use for this type of issue is to create the calculated column in SQL within a view of the original table. Then all Impromptu has to do is to report the database result of the calculation, as in:
Code:
begin tran
create view combo_data as
select a.*,b.week_no
from table1 a, weeks b
where getdate() = b.co_date
commit tran
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.