| Author |
Topic |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-06-02 : 09:38:58
|
| Hi,The client requested that the default date of a report will be todays date. However, he also wants the option that he will be able to set up a report subscription with the date a week before today and that report will be automatically send out with last weeks data.Do i need to separate reports for this since he also wants to be able to have the date todays date?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-02 : 09:42:12
|
| It would be a seperate subscription and not a completely "new" report. You can set up numerous subscriptions all with different pre-determined parameters(like the date in your example).Talk sense to a fool and he calls you foolish. |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-02 : 09:44:46
|
| Hi,The default is currently today(). How can i set up a new subscription with last weeks date?What must i write in the date field?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-02 : 09:47:42
|
| Use expressions. Take today's date, and use one of the date functions to subtract one week. I am not home and do not have access to Report Manager and the subscriptions page to provide a more direct answer. You'd have to go to that section and see way can be done.Talk sense to a fool and he calls you foolish. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-04 : 08:04:52
|
| Hi,I wasn't able to do that. The client wants also a monthly subscription in addition to the weekly one.Can anyone pleeeze help?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-04 : 09:12:19
|
| Setup up a subscription to run the report(s) on a monthly schedule.I'd like to recommend a book to read that I recently finished, but I am not sure if I can post it here.Talk sense to a fool and he calls you foolish. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-04 : 09:22:47
|
| I think maybe the client means that he wants to set up reports to run everyday but that one report will show last month figures till today, the other report last weeks figures until today and the third one to show todays figures.Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-04 : 09:56:11
|
| That sounds like you need to use linked reports.Talk sense to a fool and he calls you foolish. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-05 : 06:34:40
|
| Hi,I have date_from and date_to parameters. Can't i in some way set up 3 report subscriptions and set date_from for the weekly report to todays date less 7 days?Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2009-06-05 : 09:26:36
|
| Yes, that should work. Forget what I said about using a linked report, I was going in a different direction.Talk sense to a fool and he calls you foolish. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-06 : 05:49:53
|
| Hi,How do i set the default date to last weeks and to last month?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-06-09 : 04:10:35
|
Hi,I have the default date_from set to Todays date.If the user wants to set up a subscription with date_FROM =Today.AddDays(-7)(last week) how do i do that?Thanks Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
|
Default date in subscription