Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can modify the <code>Hidden</code> expression to achieve this:</p> <p>Turn all the selected reports into a string using <code>Join</code>, then check if the relevant report name is in the string, something like:</p> <pre><code>=IIf( InStr(Join(Parameters!WhichReport.Value, ","), "Occupancy Report") &gt; 0 , False , True ) </code></pre> <p>Or, for a different item:</p> <pre><code>=IIf( InStr(Join(Parameters!WhichReport.Value, ","), "Capacity Report") &gt; 0 , False , True ) </code></pre> <p><strong>Edit after comment:</strong></p> <p>I guess you're getting mismatches as values like <code>PitchNightsSold</code> and <code>PitchNightsSoldAndCapacity</code> will confuse the expression as written.</p> <p>I would use a Dataset similar to the following to control item visibility:</p> <pre><code>Label Value ----- ----- Occupancy Chart1 Pitch Nights Sold Chart2 Capacity Chart3 Pitch Nights Sold And Capacity Chart4 Pitch Nights Sold And Occupancy Chart5 Pitch Nights Sold Capacity And Occupancy Chart6 </code></pre> <p>Then expressions like:</p> <pre><code>=IIf( InStr(Join(Parameters!WhichReport.Value, ","), "Chart1") &gt; 0 , False , True ) </code></pre> <p>Will only ever apply to one item.</p> <p>Since these are your own internal constant values, you can call them whatever you want; just make them distinct and unambiguous. The label will remain unchanged so users will be unaffected when running the report.</p> <p><strong>Edit after comment:</strong></p> <p>In a comment @glh offers a good solution to similar <code>Value</code> values:</p> <blockquote> <p>...if you wrap you join in commas and search for them this will remove the partial finds.</p> </blockquote> <p>So something like:</p> <pre><code>=IIf( InStr("," + Join(Parameters!WhichReport.Value, ",") + ",", ",PitchNightsSold,") &gt; 0 , False , True ) </code></pre> <p>Would work very well, too; credit to him for the suggestion.</p>
    singulars
    1. This table or related slice is empty.
    1. POMultiple Choice and Hidden Reports
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIan Preston
    1. USIan Preston
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COHi Ian, Thanks for the reply, your solution sort of works but it fails on my last 3 reports and I think its all to do with the name of the reports Report 1 - Occupancy Report 2 - Pitch Nights Sold Report 3 - Capacity Report 4 - Pitch Nights Sold and Capacity Report 5 - Pitch Nights Sold and Occupancy Report 6 - Pitch Nights Sold, Capacity and Occupancy Report So when I use your solution and run Report 4 I get the Pitch Nights Sold Report and the Capacity Report and then the Combo report and all I want to see is the combo report.
      singulars
      1. PO
      1. USwafw1971
    2. CODid you change the name for each report item? You can't just use the same piece of code each time, you have to update it for your own purposes.
      singulars
      1. PO
      1. USIan Preston
    3. COHi Ian, I updated it with the name of each report when I went in to change that reports Visibility. =IIf( InStr(Join(Parameters!WhichReport.Value, ","), "PitchNightsSoldAndCapacity") > 0 , False , True )
      singulars
      1. PO
      1. USwafw1971
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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