Hi ,
I don't want to show this page when the dimension called "SERVICIO" has no data.
Now it shows like this , i want to omit this page of the report
(http://i66.tinypic.com/21317pe.jpg)
Do you know how can i omit the page when the master dimension has no details data?
(filtering in the query is not an option for me right now)
Thanks in advance for your help.
Select the page. In the properties pane, you'll see a "Render Variable" property, which is what you'll use to define when the page renders.
Hi ,
I have located the option but i am not sure about how to configure that option.
Assuming taht my dimension is called "Service" , could you make me an example to configure render variable to omit pages with no details?
Hi,
Create a render variable '[service] is not null' and then assign it to the page. Also if it is a list there is a property called render page when empty, if I am right. Let us know if you still face any issue.
Good luck
New guy
Hello ,
When i try to create the render variable , i have to choose between a boolean , string or language variable.
What type should i select?
Remember that the Service dimension is not null , the null values are those from details...
Thank you in advance.
Hi,
Create a boolean variable as [detail]is not null and try. Let us know if there is any issue.
Good luck
New guy
ok , it shows an error:
CRX-API-0016 , (i translate from spanish) The entry string of the expression is null ""..
I have tried with several details...
If the master query doesn't have sufficient information to suppress the page from being generated, a render variable won't work. The variable will process on the level of the master, not detail.
Instead, set one of those lists to "Render Page when Empty: No".
Take a look at the attached report. I'm generating a list of all the product lines. There's a page set that shows the revenue for each product line for 2010. Mountaineering has no data in 2010, so using "Render Page when Empty: No", the Mountaineering page doesn't render. Setting it to Yes will show a page for Mountaineering, but it will return no results.
Hi,
[list Query].[xxxxxxxxx] is not null is working for me. Just saw Paul's reply, try that first and if it does not work try [Summary] is not null and [Detail] is not null and let us know.
Good luck
New guy[/list]