ReportServer Forum

cedispin

Member

Registered: 2014-12-12

Pivol Table Doubt

Hi

I installed the ReportServer version RS2.2.0_pre2-5572-reportserver-x64-bundle.

Now I am testing the Dynamic List features.

I record the SELECT * FROM LPM_ADV in QUERY field. And I tested in List mode and it worked very well.

Now I setuped the Dymanic List as Pivot Table.

I selected the columns: SITE, USERID, NUMPAGES where:

SITE and USERID are Dimension = LPM
NUMPAGES is Aggregate field = SUM

In Preview Screen

I inputed the LPM / All in Row and NUMPAGES in Columns, but this report didn't showed me any record.

Are these steps correct? Are there other configuration mode?

Tks

Cadu

cedispin

Member

Registered: 2014-12-12

Re: Pivol Table Doubt

Could you help me?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Pivol Table Doubt

Hi Cedispin,

from what you describe everything seems correct. Does ReportServer give you any response? So is there a "no data found" or a similar message or is the space below the Columns/Rows/Filter inputs simply empty?

What happens, if you do not use the "all" dimension but specifically select SITE or USERID?

Kind regards
Arno

cedispin

Member

Registered: 2014-12-12

Re: Pivol Table Doubt

Hi

Arno

In both cases with "all" or "SITE or USERID" the results were empty.

For Example:

           VOLUME
All

         VOLUME
SITE

         VOLUME
USERID

Tks

Cadu

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Pivol Table Doubt

Hi Cadu,

what database are you working on and could you send us the query underlying the dynamic list?

Regards
Arno

cedispin

Member

Registered: 2014-12-12

Re: Pivol Table Doubt

Arno

I am using the Microsoft SQL 2008 Express and my query is:

SELECT SITE as Site
      ,USERID as Usuario     
      ,PRINTJOBNAME as NomeTrabalho
      ,FINALACTION as TipoTrabalho     
      ,RELEASEIP as EnderecoIP
      ,PRINTJOBCOLOR as Colorido
      ,PRINTJOBDUPLEX as Duplex
      ,RELEASEMODEL as Modelo
      ,USER_FULL_NAME as NomeCompleto
      ,PRICE as Valor
      ,SERIALNUMBER as NoSerie
      ,DEVICEGROUP as GrupoDispositivo
      ,FINALDATE as DataLiberacao     
      ,USER_COST_CENTER as CentroCusto
      ,RELEASEHOSTNAME as Hostname
      ,PRINTJOBPAPERSIZE as TamanhoPapel
      ,RELEASEMODELTYPE as TipoModelo
      ,SUBMITIP as DesktopEnvio       
      ,SUBMITDATE as DataEnvio
      ,FINALSITE as SiteLiberacao
      ,RELEASEUSERID as UsuárioLiberacao
      ,NUMPAGES as NumeroPaginas
     
FROM dbo.VW_REPORTS     
WHERE FINALDATE BETWEEN ${start_date} AND ${date_end}

tomharney

Member

Registered: 2014-03-11

Re: Pivol Table Doubt

cedispin

If it were me, I would write my aggregate queries in SQL Server first to verify what you are trying to attempt is valid.   Then translate that into an aggregate within ReportServer.  What you've listed here doesn't appear to be an aggregate query.

Others in the forum might find it helpful if you could describe, as clearly possible, what you are trying to accomplish.   If I were to guess (based on what you said initially), I assume you are trying to analyze the print volume of the users in this dataset?  How do you want to analyze it?  By user?  By location?  By Month?  By Year?

cedispin

Member

Registered: 2014-12-12

Re: Pivol Table Doubt

Tom

Sorry, if i wasn't clear in my objectives, but you have perfect in your analyze!

I am trying to analyze the print volume of the users in this dataset, By user,  By location,  By Month,  By Year, By CostCenter, By Papersize, By Color, etc.

I am going to add the sum() function in my query and I will test again.

Regards

Cadu