Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>Answering my own question here, hoping someone else might find this useful:</p> <p>I was under the (false) impression that the unique "DataSourceID" given to a data source on the server would be sufficient to identify it uniquely.</p> <p>So in my generated RDL, I had something like :</p> <pre><code> &lt;DataSources&gt; &lt;DataSource Name="MyDataSource"&gt; &lt;Transaction&gt;true&lt;/Transaction&gt; &lt;DataSourceReference&gt;MyDataSource&lt;/DataSourceReference&gt; &lt;rd:DataSourceID&gt;6ba7c588-e270-4de9-988c-d2af024f10e1&lt;/rd:DataSourceID&gt; &lt;rd:SecurityType&gt;None&lt;/rd:SecurityType&gt; &lt;/DataSource&gt; &lt;/DataSources&gt; </code></pre> <p>Now this worked once, when my data source was indeed called "MyDataSource" and located in the same directory as my report which I published through the RS WebService API.</p> <p>As soon as I moved the data source elsewhere, it stopped working.</p> <p><strong>THE SOLUTION:</strong><br> This may sound silly, but I really didn't "get it" at first: the <code>DataSourceReference</code> needs to have the full and complete "path" on the Reporting Server to that data source I want to reference. Just specifying the unique ID won't do....</p> <p>So once I changed my RDL to:</p> <pre><code> &lt;DataSources&gt; &lt;DataSource Name="MyDataSource"&gt; &lt;Transaction&gt;true&lt;/Transaction&gt; &lt;DataSourceReference&gt;/MyProject/DataSources/MyDataSource&lt;/DataSourceReference&gt; &lt;rd:DataSourceID&gt;6ba7c588-e270-4de9-988c-d2af024f10e1&lt;/rd:DataSourceID&gt; &lt;rd:SecurityType&gt;None&lt;/rd:SecurityType&gt; &lt;/DataSource&gt; &lt;/DataSources&gt; </code></pre> <p>(notice the <code>&lt;DataSourceReference&gt;/MyProject/DataSources/MyDataSource&lt;/DataSourceReference&gt;</code>)</p> <p>since that moment it works like a charm.</p> <p>Hope someone might find this useful some day!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload