+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, [SIMS] Command Reporter Date issue in Technical; I'm trying to use command reporter to run the following report from SIMS: sims.jpg I can get command reporter to ...
  1. #1

    Join Date
    Jan 2014
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    [SIMS] Command Reporter Date issue

    I'm trying to use command reporter to run the following report from SIMS:
    sims.jpg

    I can get command reporter to extract this report however I wish to change the dates 16dec2013 and 20dec2013 each time I run it from the command line.

    I've tried the below so far but this has been unsuccessful.

    "C:\Program Files\SIMS\SIMS .net\CommandReporter.exe" /user:XXXXXX /password:XXXXXX /report:"Test Report 1 for SIMS BW CEM" /params:"2014-01-062014-01-06" /output:"test.csv"

    Any help would be greatly appreciated.

    Carl

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    Quote Originally Posted by cmitchell View Post
    I'm trying to use command reporter to run the following report from SIMS:
    sims.jpg

    I can get command reporter to extract this report however I wish to change the dates 16dec2013 and 20dec2013 each time I run it from the command line.

    I've tried the below so far but this has been unsuccessful.

    "C:\Program Files\SIMS\SIMS .net\CommandReporter.exe" /user:XXXXXX /password:XXXXXX /report:"Test Report 1 for SIMS BW CEM" /params:"2014-01-062014-01-06" /output:"test.csv"

    Any help would be greatly appreciated.

    Carl
    First thing I notice is you have a space in your opening DateRange tag - does removing that fix it?

    Also, it doesn't look like you ticked "Prompt at run time" on the date filter in SIMS report designer - that needs to be ticked if you want to change the filter at run time

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    You might want to check out this thread too: CLR /Params String particularly this post

    TL;DR - I had a lot of issues passing XML over command line, but passing a reference to an XML file worked flawlessly

  4. #4

    Join Date
    Jan 2014
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Date Range has no space, must have been a copy paste issue.

    "Prompt at run time" is ticked too.

    I've notice a lot of examples on this site have a parameter id but I have no idea of where to get that from for the fields in this query.

  5. #5

    Join Date
    Jan 2014
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Got it. Running the /paramdef switch generates the XML schema. Here's hoping!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 11th May 2013, 02:15 PM
  2. [SIMS] Command Reporter to pull sims to mrbs report
    By glennda in forum MIS Systems
    Replies: 5
    Last Post: 24th July 2012, 03:44 PM
  3. [SIMS] SIMs and Command Reporter
    By RuAware in forum MIS Systems
    Replies: 43
    Last Post: 25th February 2011, 06:57 PM
  4. Replies: 1
    Last Post: 19th October 2010, 09:48 AM
  5. [Sims] Command reporter working examples
    By browolf in forum MIS Systems
    Replies: 3
    Last Post: 1st July 2010, 12:45 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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