web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

Liquid error: Value cannot be null. Parameter name: key  Profile Picture Liquid error: Value cannot be null. Parameter name: key Community member

Comments

*This post is locked for comments

  • Inogic Profile Picture Inogic 715
    Posted at

    Hi Jodi, To pass the selected records as parameters to the reports, it is best to have the reports display on the Grids where you can select multiple records. But for these to work, make sure that your reports use Joins in the queries to retrieve the data. Once you have designed a report including joins in queries you would automatically get the option to run report for selected records. HTH Sam

  • Community Member Profile Picture Community Member
    Posted at

    What is the best way to pass the selected rows to Reporting Services for use in a report?  I can't seem to get it to work  I created a dataset that accepts @id as the selected rows and uses "IN" like so: select * from table where table.guid IN ( @id). Here's my java snippedt in the onload: listselecteditems =  function ()         { //    get array of selected records        var frameDoc = document.getElementById("IFRAME_Saw").contentWindow.document;        var a = frameDoc.all['crmGrid'].InnerGrid.SelectedRecords;        var selectedItems = new Array(a.length); //       var theRows = "(";         var theRows = "";        for (var i=0; i < a.length; i++)        {            selectedItems[i] = a[i][0];            var guid = selectedItems[i] .substr(1,36); //           alert("guid " + guid); //           theRows = theRows + "'" + guid + "'";            theRows = theRows +  guid ;            if (i != a.length - 1)                { theRows = theRows + "," }        }  //      theRows = theRows + ")";        alert(theRows);              var thisServer = (SERVER_URL.substr(7,6));      if (thisServer == "crmtst")      { Url = 'http://crmtstdb.mhc.trk/Reportserver?%2fMHC_MSCRM%2f'; }       else      {Url = 'http://crmdb.mhc.trk/Reportserver?%2fMHC_MSCRM%2f'; };       var  restOfUrl = '&amp;rs:Commmand=Render&amp;';        restOfUrl = restOfUrl + 'rs:Format=PDF&amp;rs:ClearSession=true&amp;id=' + theRows;         Url = Url + 'Test'+ restOfUrl;         window.open(Url,'_blank', 'toolbar=0,status=0,resizable=1');         }