Results 1 to 2 of 2

Thread: Subscription of SSRS report every Saturday morning based on invoice dates Monday - Fr

  1. 05-11-2015, 12:06 PM #1
    donalejandro
    donalejandro is offline Registered User
    Join Date
    Apr 2013
    Posts
    39

    Subscription of SSRS report every Saturday morning based on invoice dates Monday - Fr

    I am using 2013 SSRS extracting data from db2 (iSeries) I am trying to get my reports more automated by having subscription running on invoice date from Monday – Friday and the report will be generated on Saturday morning. The problem is I have to input the dates earlier in the week. I would like to have the subscription run the program every Saturday morning automatically based on the Saturday’s date. The problem I have is that the date field in db2 for May 9, 2015 is: 20150509. How can I get SSRS to recognize the date format generate the report from invoice date Monday – Friday and generate on Saturday morning. I suppose I can format the dates but I don’t know how to do that. All I want is to run a report every Saturday morning. Any help or suggestion are appreciated. Thank you in advance.
    Reply With Quote Reply With Quote
  2. 05-26-2015, 02:12 PM #2
    donalejandro
    donalejandro is offline Registered User
    Join Date
    Apr 2013
    Posts
    39
    Wow! I have 198 views, but nobody seems able to answer my question. I had better results from a different forum. How sad
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules