Broadcaster is not refreshing the value !

[Former Member]

Experts !

there is a date variable in my query's variable screen. So each time when u run the query , first the screen pops up where we enter variables.

This date variable is designed in such a way that its "Ready to input" also it has default value, which is thry customer exit. and it by defaults calculates systum date - 1 ( thru i step = 1).

Now, my problem is.. if users saves this report, and open it tomm. this variable is not refreshed again.

also, thru brodcaster, if they schedule for email once every week it sends the report with the original date ( when it was created / saved and scheduled ).

is there any other settings do i need to do ?

thanks..please help

[Former Member]

Does anyone has the solution... ?

please help Or let me know, how you handle such type of problem .

thankx

[Former Member]

Hi,

The customer exit will not run every time the report is broadcast. the variable values are stored in a table while scheduling the report and the broadcaster reads the values from that table only. Below Article provides a very good solution for this issue.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20d671c6-b377-2d10-7488-b75841c38...

Best Wishes,

Mayank

[Former Member]

OK well that was good...

But, looks like each broadcast needs this kind of code to be executed thru Process chain. what if i have 50 broadcast report, in this case will i need to execute 50 diff. Z programe ? that doesnt sound right !

also, what about saved reports ? say there are lots of reports with caldate or calmonth, and when users run those saved reports , based upon the current systemdate , the caldate or calmonths needs to get change automatically in the cariable screen, in this case also will i need to do the same ?

please give me your feedback.

thanx

[Former Member]

In the same z program you can update all the broadcast settings.

By saved reports, I think you mean bookmarks. This solution doesn't work for that. And Customer exits with i_step 1 doesn't get executed for bookmarks as well. So, I don't know how to make this work for them. If you find the solution let me know as well.

Regards,

Mayank

[Former Member]

Hello,

Looks like you have given some date in "General Calculation" tab in Broadcasting Settings in portal. Just clear any manual value you have given. While running query will automatically pick the default value of the variable.

I hope this will solve your problem.

Regards

Aman

[Former Member]

make the date varaible dynamic ( or default) according to your requirement.

For Example if you want to run a sales report for yesterday, use CALDAY variable in your report . based on system date always go back one day and default the date. and also make sure the variable as mandatory entry.