#1 2014-08-11 09:25:09

cheong wai kit
Member
Registered: 2014-08-11

Column no show on Dynamic List

Hi,

I have created a dynamic list report and when i have choosed 'add all' on 'configure list'. The columns does not show on the right side and i can't able to add 'subtotals' since there is no column for me to select. But when i preview, i can see the records.

Please help,
Thanks.

Offline

#2 2014-08-11 09:55:29

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Column no show on Dynamic List

Hi,

the way to configure a "subtotals" report is the following:

1) choose the columns (via "select columns") that are to be part of the report
2) select aggregations for attributes
3) click the "subtotals" button and select the columns that should be used as grouping characteristica. Here you should see those columns that were selected in step 1 but are not to be aggregated (step 2)

I hope this helps. If you still encounter problems, could you maybe send us one or two screenshots illustrating the issue?

Cheers
Arno

Offline

#3 2014-08-11 10:07:23

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi Arno,

Thanks for the speedy reply. Can you guide me on how to send/upload screenshot?

Thanks,
kit.

[img=select columns]file:///C:/Users/Cheong%20Wai%20Kit/Desktop/2014-08-11_1801.png[/img]
[img=after columns selected]file:///C:/Users/Cheong%20Wai%20Kit/Desktop/2014-08-11_1801_001.png[/img]

Offline

#4 2014-08-11 10:34:27

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: Column no show on Dynamic List

Hi,

take a look at http://snag.gy/. Upload you pictures there and paste the url here.

Cheers,
Thorsten

Offline

#5 2014-08-12 01:54:01

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi.

Thanks Thorsten. The step 1 is how i added my columns to display, but step 2 shows nothing added into the list. However when i do step 3 (preview), it shows the records.

step 1. http://snag.gy/LIExd.jpg
step 2. http://snag.gy/POhC2.jpg
setp 3. http://snag.gy/9J59I.jpg

please help, thanks in advance.

kit.

Offline

#6 2014-08-12 06:00:41

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Column no show on Dynamic List

Hi kit,

could you tell us what version of ReportServer and what browser version you are using?

Cheers
Arno

Offline

#7 2014-08-12 06:08:14

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi Arno,

RS2.1.6-5543-reportserver-x64-bundle.exe

Runs on my PC, Win7 pro. SP1, 64bit. with 8GB ram.

Thanks,
Kit.

Offline

#8 2014-08-12 06:43:34

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Column no show on Dynamic List

Hi Kit,

what browser (and version) are you using to access ReportServer?

Cheers
Arno

Offline

#9 2014-08-12 07:07:49

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi Arno,

Its chrome, Version 36.0.1985.125 m.

Thanks,
Kit.

Offline

#10 2014-08-12 08:22:39

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi again,

I just tried it on IE11.0.10. Still no column shows.

Thanks,
Kit.

Offline

#11 2014-08-12 09:38:39

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi,

After a few tries, i notice i need to do a CAST (in mssql) to varchar in oder to be able to show the column into the list. Is that a bug?

http://snag.gy/z1ONW.jpg  <-- after mssql sql statement changed.

Thanks,
Kit

Offline

#12 2014-08-12 10:08:10

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi Arno,

Back to the steps on howto add subtotal. I have tried to applied a SUM on the qty, but there is not subtotal that i can select nor show on the last page.

http://snag.gy/aXmzX.jpg

thanks,
kit

Offline

#13 2014-08-12 10:19:34

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Column no show on Dynamic List

Hi Kit,

casts should usually not be necessary. Could you send us the definition of the underlying table and the base statement that you used to define the dynamic list?

Cheers
Arno

Offline

#14 2014-08-13 01:22:07

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

Hi Arno,

CREATE TABLE[DO] (
  [plant]               NVARCHAR(5),
  [do_no]               NVARCHAR(15),
  [qty]                 NUMERIC,
  [truck_name]          NVARCHAR(10)
)
--------------this statement does not shows the selected columns ----------------------------------------
select distinct cast(do_no as varchar(20)) as do_no,
       cast(plant as varchar(20)) as plant, qty
from do
where plant = ${plant}
and truck_name = ${truck}
--------------this statement shows the selected columns ----------------------------------------
select do_no, plant, qty
from do
where plant = ${plant}
and truck_name = ${truck}

The database is MSsql.

Thanks,
Kit

Last edited by cheong wai kit (2014-08-13 01:23:05)

Offline

#15 2014-08-13 19:35:00

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: Column no show on Dynamic List

Hi Kit,

we will look into this and let you know as soon as we have any results.

Cheers
Thorsten

Offline

#16 2014-08-22 21:11:52

Dennie
Member
Registered: 2014-08-22

Re: Column no show on Dynamic List

Hello,

Same issue here. Only happens for the nvarchar fields.
Database server: SQL Server 2008.

Offline

#17 2014-08-23 11:31:04

Thorsten J. Krause
datenwerke
Registered: 2012-02-15
Website

Re: Column no show on Dynamic List

Hi,

for the sake of completeness: The issue concerned all the "new" JDBC4 datatypes; ROWID, NCHAR, NVARCHAR, LONGNVARCHAR, NCLOB, SQLXML.
It's resolved in the development build and we will push a new build (RS2.2.0_pre2) to sourceforge by the end of the day.

Because of the upcoming 2.2 release we will probably not port this back to the RS 2.1 (stable) branch, unless you specifically require it.

Cheers,
Thorsten

Offline

#18 2014-08-25 02:19:00

cheong wai kit
Member
Registered: 2014-08-11

Re: Column no show on Dynamic List

_
           /(|
          (  :
         __\  \  _____
       (____)  `|
      (____)|   |
       (____).__|
        (___)__.|_____

Offline

Board footer

Powered by FluxBB