Post reply

Totals for NON-HIDDEN values in reporting Services

  • March 14, 2007 at 11:29 pm

    #175645

    I have a report that in the data section calculates how many services in total of 3 different types (health check, consult, immunisation) have been provided to particular clients for a date range.

    The report displays those individuals that have a total number of services >= X (parameter value) and all others are hidden.

    Does anyone know of a way in Report Services itself to total ONLY the NON-HIDDEN values?

     

     

  • March 19, 2007 at 5:37 pm

    #695832

    Perhaps you could use a subreport which displays individuals with a total number of services < X?

  • March 19, 2007 at 6:12 pm

    #695834

    Thanks for looking at this Sam  

    I've managed to use two different views, one that provides all the details needed by the business (this hides data not needed) and the other provides the totals.

    I have then reported the totals with appropriate graphs first and on a new page the details report all sorted in the same order by business unit. Seems clunky but it does work and so far as the business is concerned it is all in one report.

     

    David

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply