You are not logged in.
Pages: 1
Topic closed
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
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
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
Hi,
take a look at http://snag.gy/. Upload you pictures there and paste the url here.
Cheers,
Thorsten
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
Hi kit,
could you tell us what version of ReportServer and what browser version you are using?
Cheers
Arno
Offline
Hi Arno,
RS2.1.6-5543-reportserver-x64-bundle.exe
Runs on my PC, Win7 pro. SP1, 64bit. with 8GB ram.
Thanks,
Kit.
Offline
Hi Kit,
what browser (and version) are you using to access ReportServer?
Cheers
Arno
Offline
Hi Arno,
Its chrome, Version 36.0.1985.125 m.
Thanks,
Kit.
Offline
Hi again,
I just tried it on IE11.0.10. Still no column shows.
Thanks,
Kit.
Offline
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
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.
thanks,
kit
Offline
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
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
Hi Kit,
we will look into this and let you know as soon as we have any results.
Cheers
Thorsten
Hello,
Same issue here. Only happens for the nvarchar fields.
Database server: SQL Server 2008.
Offline
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
Pages: 1
Topic closed
