Column no show on Dynamic List

ReportServer (EN)
1

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.

2

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

3

Hi Arno,

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

Thanks,
kit.

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

4

Hi,

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

Cheers,
Thorsten

5

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.

6

Hi kit,

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

Cheers
Arno

7

Hi Arno,

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

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

Thanks,
Kit.

8

Hi Kit,

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

Cheers
Arno

9

Hi Arno,

Its chrome, Version 36.0.1985.125 m.

Thanks,
Kit.

10

Hi again,

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

Thanks,
Kit.

11

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

12

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

13

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

14

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

15

Hi Kit,

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

Cheers
Thorsten

16

Hello,

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

17

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

18

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