Search results for query: *

Ok, this is a little off topic, but it might help me to understand what it going on - if you are willing to help? I have two filters on my dataset (dataset_AutoDailyProd): Filter 1: =Fields!WgtGross.Value + Fields!WgtPaw.Value <> 0 Filter 2: =DateValue(Fields!Date_Key.Value) BETWEEN...

If I use NON EMPTY and/or do not include the formula: =Fields!WgtGross.Value+Fields!WgtPaw.Value <> 0 In the dataset, then the report just fails anyway - I think because there is too much data to process. Any other suggestions? Thanks again

Hi, I have a dimension "mill name" for which I have production data measures in the same cube. The problem I have is that there are some days where a mill does not produce any product and their row is therefore missing in the tablix I have created to summarise the production data per mill...

That's perfect, thanks a lot LB. The only difference for me was to replace: numberVar dur := datediff("s",{Orders.Order Date}, currentdate); //get the seconds between 2 dates With numbervar dur := currentfieldvalue; Thanks again!

Thanks for the speedy reply LB. Bascially the cross-tab currently contains only numeric figures, including downtime in seconds (per "gradespec"), and then summarised for the total of all of the "gradespecs". Instead of seeing total seconds, the customer would rather see hh:mm:ss - which is...

thread767-1611629 Hi lbass, In the above post you mention the following: "I think you can use an inserted crosstab and just select the summary->right click->format field->display string->x+2 and convert the seconds to a string there." I've tried right clicking on the field I am trying to...