Report Email Schedule Parameter

[blaue_Tomate]

Hi Forum,

i want to send a Report from my Pentaho Bi Server via Email.
The Report has 2 Parameter, From(Date) and To(Date) and should schedule every week.
The 2 Parameter are dynamical and the Date depends on the current Date. They change when the Report starts up.
Sending via Email works fine with SMTP.

The only Problem is, that sending via Email is not dynamically. The Parameter dont change when the Email is sent.
They are allways the same.

I dont think this is usefull, when you are getting the same report every day/week/month.

Is there any workaround ?

greets

[hansva]

This problem is explained here somewhere on the forum.
the solution is/was using a function inside the report in stead of parameters if i am not mistaken.

If you do a search the correct answer should appear !

greetz,
Hans

[blaue_Tomate]

I only opened a new Thread because i didn´t found something in the forum.

Maybe you can help me finding this thread.

[blaue_Tomate]

How do I use a formula step in my sql query ? It dont works with ${date1}

where date1 =DATE(Year(NOW()); MONTH(NOW())-1; DAY(NOW())-1) (FORMULA)

[blaue_Tomate]

Maybe with a Hidden Parameter ?

[blaue_Tomate]

How do I use a formula step in my sql query ? It dont works with ${date1}

where date1 =DATE(Year(NOW()); MONTH(NOW())-1; DAY(NOW())-1) (FORMULA)

hidden parameter doesnt work! can anybody help me ?

[blaue_Tomate]

Hi Forum,

i want to send a Report from my Pentaho Bi Server via Email.
The Report has 2 Parameter, From(Date) and To(Date) and should schedule every week.
The 2 Parameter are dynamical and the Date depends on the current Date. They change when the Report starts up.
Sending via Email works fine with SMTP.

The only Problem is, that sending via Email is not dynamically. The Parameter dont change when the Email is sent.
They are allways the same.

I dont think this is usefull, when you are getting the same report every day/week/month.

Is there any workaround ?

greets

This is the answer :

http://michaeltarallo.blogspot.co.at...ho-report.html