Impromptu 7.3 Joins

[gwynfijones]

Is there any way that i can create a join using the today function ?

 

[drlex]

Can you describe the difficulty you are having?
(I have joins that reference the today() function in catalogues against SQL server and PROGRESS databases.)

soi la, soi carré

 

[gwynfijones]

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.

 

[drlex]

Ah, in that case I believe you'll have to recreate the calculation when creating the join.

soi la, soi carré

 

[griffindm]

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:

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!

http://www.decisionsupportgroup.com