locked
Feed SSRS Report field values through PowerShell script RRS feed

  • Question

  • I am new to PoweShell scripting

    I want to perform below mentioned actions on given script

    1. Open SSRS report

    2. Feed StartDate(calendar date picker field), Enddate(calendar date picker field), dropdown field1, dropdown field2 values through powershell scripting

    3. then click view report button (This is happening)

    $ie = New-Object -com internetexplorer.application;
    $ie.visible = $true;
    $ie.navigate("share point link to particular SSRS report");
    while ($ie.Busy -eq $true) { Start-Sleep -Seconds 1; }    #wait for browser idle

    $field1=$ie.document.getElementByID("XYZ")
    @($field1).value = "1/1/2015"
    $ie.document.getElementByID("ABC").value = "9/18/2016";
    $dropdown1=$ie.document.getElementByid("1A2B").value ="Life"
    $ie.document.getElementByID("9X8B").value= "Life";
    $Link=$ie.Document.getElementByID("456")  

    $Link.click();

    Monday, September 19, 2016 4:20 PM

Answers

All replies

  • From my experience with SSRS report s on a report server this cannot be done as the fields are all managed by the ASPX code on the server.

    There may be a way to decorate the URL with custom queries.  Post in report server forum for answers as they would be able to answer this better,


    \_(ツ)_/

    Monday, September 19, 2016 4:53 PM
  • Here is a discussion on using the url https://msdn.microsoft.com/en-us/library/ms155391.aspx

    \_(ツ)_/

    • Proposed as answer by jrv Monday, September 19, 2016 7:13 PM
    • Marked as answer by Richard MuellerMVP Tuesday, September 27, 2016 4:47 PM
    Monday, September 19, 2016 4:54 PM
  • I am new to PoweShell scripting

    I want to perform below mentioned actions on given script

    1. Open SSRS report

    2. Feed StartDate(calendar date picker field), Enddate(calendar date picker field), dropdown field1, dropdown field2 values through powershell scripting

    3. then click view report button (This is happening)

    $ie = New-Object -com internetexplorer.application;
     $ie.visible = $true;
     $ie.navigate("share point link to particular SSRS report");
     while ($ie.Busy -eq $true) { Start-Sleep -Seconds 1; }    #wait for browser idle

    $field1=$ie.document.getElementByID("XYZ")
     @($field1).value = "1/1/2015"
     $ie.document.getElementByID("ABC").value = "9/18/2016";
     $dropdown1=$ie.document.getElementByid("1A2B").value ="Life"
     $ie.document.getElementByID("9X8B").value= "Life";
     $Link=$ie.Document.getElementByID("456") 

    $Link.click();

    • Merged by Mike Laughlin Monday, September 19, 2016 6:55 PM Duplicate
    Monday, September 19, 2016 6:21 PM