b*****t 发帖数: 68 | 1 本周Topic
Group Meeting 18 -----4/26/2014
• Helen –Got Job offer/Job Hunting Experience
• Crystal Reports 2013--Part1
• SQL & SSRS Class Q & A
• Demo: Present a Super Report Project --Jean
• Career & Office Tips |
|
b*****t 发帖数: 68 | 2 本周Topic
Group Meeting 19-----5/3/2014
• Crystal Report 2013 Part2,3 Review
• Crystal Report 2013 Part4--Migrating from Crystal Reports to SQL
Server Reporting Services
• SQL & SSRS Class Q & A
• Interview Story ,Experience & Tips—Will, Jean, Carol, Elee |
|
A*****O 发帖数: 394 | 3 已经买好票了,但是版上的指南说要提前和代理或者航空公司注册SSR TWOV,代理叫我
找航空公司直接做。打哪个电话能找到合适的人做这件事啊?有谁做过能说说经验吗?
谢谢! |
|
k*********8 发帖数: 861 | 4 从中国回美国,无绿卡。
回美国第一站在温哥华转机(加航),看了置顶,好像其他条件都符合了,但是用里程
票 如何在订票纪录里作注释SSR TWOV?
谢谢 |
|
t******n 发帖数: 3347 | 5 之前要求必须两段都是AC
现在改成了:
NOTE 43595: Facility available if transiting through
Vancouver International Airport (YVR) AND arriving on
aircraft operated by Air Canada or Jazz Air (insertion of
SSR TWOV in PNR is required), or Air China, Cathay Pacific,
China Airlines or Philippine Airlines. Note: codeshare
flight numbers of these carriers operated by another
carrier are not included. Connecting flight can be with any
carrier. |
|
l******t 发帖数: 2113 | 6
决了
nope, 从美国经过温哥华可以是加航(含Jazz),国航,国泰,华航,和菲律宾航空
NOTE 43595: Facility available if transiting through
Vancouver International Airport (YVR) AND arriving on
aircraft operated by Air Canada or Jazz Air (insertion of
SSR TWOV in PNR is required), or Air China, Cathay Pacific,
China Airlines or Philippine Airlines. Note: codeshare
flight numbers of these carriers operated by another
carrier are not included. Connecting flight can be with any
carrier. |
|
s******x 发帖数: 15232 | 7 好像我写
http://www.mitbbs.com/article_t/Travel/31465579.html
的时候就已经没有要求了
provided:
-holding a valid US visa (SEE NOTE 39687), and
-arriving on a direct flight from Beijing, Shanghai, Hong Kong
, Guangzhou, Manila or Taipei on aircrafts operated by Air
Canada or Jazz Aviation at YYZ or YVR (insertion of SSR TWOV
in PNR is required), or by Cathay Pacific, China Airlines or
Philippine Airlines at YVR only (Note: passengers may depart
Canada via YVR and YYZ on another carrier), and |
|
b******g 发帖数: 81 | 8 Agree with iMaJia, SQL Server is called Database Engine, SSIS, SSAS, SSRS
are called XXX Service. When you try the Connect button in SQL Management
Studio, the drop down menu lists them separately. |
|
j*****n 发帖数: 1781 | 9 In addition, SSIS, SSAS, and SSRS are independent services, that is, they
can be installed on other server(s) if you want. Also these services can
connect to multiple resources (SQL Service DB Engine, or even other DB such
as Oracle). |
|
u*********e 发帖数: 9616 | 10 Hi,
I am working on a SSRS report from a store procedure I created.
The returned the dataset is showing in the picture
I create a dataset using tableadapter. I can preview the dataset without any
issue (in pic2)
Later I bind the dataset using objectDataSource, and select the datasource
in the rdlc file.
I drage and drop the values from the field to the table.
When I run the result, the first two columns display values correctly.
However, the rest columns all return empty string.
any idea why? |
|
u*********e 发帖数: 9616 | 11 yes, I was. the fields are directly referenced. I suspect SSRS has issue
with store procedures that do table variable manipulation. |
|
i****a 发帖数: 36252 | 12 no, SSRS doesn't care what you do in the SP
you have Visual Studio (or Business Intelligent Studio if you installed it
with SQL server disk)? check the report in design view. |
|
u*********e 发帖数: 9616 | 13 thanks for responding. I use VS to design the rdlc file. It's was a straight
Fields!Stmt_Created_Date.Value drop in textbox. The field of "Group_Code"
and "Group_Member_Code" can be displayed without any problem but not for the
rest.
I did some research. One person raised the similar issue like mine. His
storeprocedure created a table variable and used cursor to combine different
rows into one row then put into the table variable and select the result as
the return set. That's very much like min... 阅读全帖 |
|
g***l 发帖数: 18555 | 14 先用SP把TABLE建好,填充好,最后SSRS显示一下TABLE就可以了,避免弄一个复杂的
JOIN QUERY去显示。 |
|
u*********e 发帖数: 9616 | 15 thanks for the suggestion. Not a fan of cursor myself either. I will see
what I can do to improve the sp.
the question I have is that, what could cause the report not returning all
the data even though the sp itself returned the data as expected? I thought
SSRS just treated all returned dataset as strings. |
|
i****a 发帖数: 36252 | 16 agree
haven't looked at LZ's code, but basic idea should be, retrieve data, leave
formatting to SSRS.
易比较出错,最后出REPORT的时候可以用MONTH() DAY() |
|
c*********e 发帖数: 16335 | 17 能用ssrs做一个website的dashboard界面吗?要求用户log in 這個website,之后,要
求界面里有多个下拉菜单,让用户选,然后出结果在chart里
比如,用户能选,从哪年哪月,到哪年哪月,哪几个部门,哪个project,花费了多少钱
,按钱多少排序,做成一个bar chart,显示在dashboard里。 |
|
s**********o 发帖数: 14359 | 18 SSRS可以接受一些参数,我觉得能做出来,如果菜单太复杂就可能需要C# CUSTOMERIZE
一下或者用SHAREPOINT,注意数据最好是STORED PROCEDURE取出来,然后加一些FILTER
过滤,
否则会很慢 |
|
i****a 发帖数: 36252 | 19 下拉菜单, can be done with SSRS parameters
you can also have a front end as C# as pointed out so you get better control
on the presentation. then you can pass in the parameters in URL to the
report |
|
w****n 发帖数: 266 | 20 数据库里的email和SSN加密了,在SSRS里怎么解密,还原数据?
这个是我在shared dataset里的 SQL 语句, 出来的report里SSN还是显示Error
Use xxxx
GO
OPEN SYMMETRIC KEY Generickey DECRYPTION BY CERTIFICATE EncryptCert
GO
SELECT LName,
FName,
Convert(nvarchar(256),Convert(varbinary(256),DECRYPTBYKEY([SSN]))) as SSN
FROM table |
|
w****n 发帖数: 266 | 21 用SSRS生成report后,client如何才能看到这些报表?reportserver? |
|
|
|
s**********o 发帖数: 14359 | 24 生成了不是还要DEPLOY么,TARGER SERVER,注意DATA SOURCE不要OVERIDE,SSRS
SERVER里设置DATA SOURCE |
|
s**********o 发帖数: 14359 | 25 原来的啥设置,我没搞懂,你不会是把DB和SSRS装在一个SERVER上了吧 |
|
w****n 发帖数: 266 | 26 我们的是2008 R2, 自带的SSRS啊,都在DB server上啊, 我就在database server 上
configure, 结果出问题了 |
|
w****n 发帖数: 266 | 27 我试试, 不行repair一下看看, 那我们这种情况还需要在web server 上装ssrs吗?
ACCOUNT, |
|
s**********o 发帖数: 14359 | 28 SSRS本来就是应该装在WEB上的,装在DB SERVER上占用很多资源,
你不会的话,最好弄个TEST SERVER先装装看 |
|
s**********o 发帖数: 14359 | 29 快被你搞疯了,不要在WEB上装DB ENGINE,只赚个SSRS就可以了 |
|
s**********o 发帖数: 14359 | 30 WEB上装上SSRS以后,去CONFIGURE,把REPORTDB指到你的DB SERVER上就可以了 |
|
s**********o 发帖数: 14359 | 31 那么不想花钱的还在乎山寨不山寨啊,能用就不错了,web上trigger,
CALL WEB SERVICE,这不是要WEB DEVELOPER,一个REPORT就要一个TRIGGER,
每次添加修改都要找WEB DEVELOPER, REPORT DEVELOPER,还
要有人对付SP,三个人的工作了么,装个SSRS,一个人几分钟就搞定了 |
|
w****n 发帖数: 266 | 32 头担心把SQL的东西装在web server上会有安全问题,据说去年SQL injection把整个系
统搞瘫了,他们现在在web server 和DB server之间又装了一个green SQL,我跟他解
释在web server上只装SSRS, 他有点半信半疑,毕竟我是新手, 呵呵。 |
|
s**********o 发帖数: 14359 | 33 其实把你自己的PC搞成SSRS SERVER也行的,先让老板看到成绩,
想全公司或者CLIENT看,那就要搬到WEB上去,如果不是REALTIME的,
可以SCHEDULE JOB,生成了REPORT,然后COPY到WEB SERVER,一天更新
三次也可以了 |
|
|
w****n 发帖数: 266 | 35 前几天把大家的这些建议汇报给头, 他说要想想等他决定,到底装在哪个server上,
结果人家一忙,把这茬给忘了,晾了我好几天。 今天想起来问我demo搞好没有, 我傻
眼了,说准备把ssrs装在web server上,在等他决定,他说很好,你还没装?(人家把
以前的话全忘了)。上午折腾了一下,老头现在满脸黑线啊 |
|
w****n 发帖数: 266 | 36 昨天折腾了一下,终于把SSRS装在web server 上了, IP指向自己的intranet, 却发
现report manager portal被web server的firewall block 了, sys admin让我自己查
查怎么改IP SACK(?) 这个怎么改啊?(我们的web server, db server之间有个green
SQL) |
|
w****n 发帖数: 266 | 37 SSRS 2008 R2 standard edition was installed on the web server (windows
server 2008 R2), clients can deploy reports to the report server, I can
view these reports on the server. While clients cannot access report manager
URL, only shows report manager partial GUI, error msg “unable to connect
to the remote server”. Any idea? |
|
w****n 发帖数: 266 | 38 In SSRS configuration, we use SQL authentication rather than integrated
security for DB credential.
So where should I check the connection string,
more details for newbies, please. |
|
u*********e 发帖数: 9616 | 39 你的SSRS SQL authentication 的login 在 DB里有吗? |
|
w****n 发帖数: 266 | 40 SSRS装完以后,在report server机器的windows firewall里我开了一些常见端口(TCP:
8101, 1433-1434, 135, 443; UDP: 1434, 500, 4500), 我
们用IPsec,block everything else not on the list, 这下悲剧了, report
manager url 打不开, 不知还需要加哪些条件。 window firewall和IPsec 截图如下: |
|
k*z 发帖数: 4704 | 41 最近在学习SSRS. 我有一个过去365天,每天的机器运行的记录,
我想看我选择的一天的还Active的机器的那天之前的记录的平均。
三个SQL命令可以解决这个问题。但是如何能一个SQL就解决呢? 因为涉及到Parameter
,Use Config 都用不起来,怎么才Report里面实现吧?
Use CurrentConfig
Select Date, Asset, Location
from Record
where date=@enddate
order by Asset, Location
Use AssetStats
Select Asset, Location, Avg(Production) as Production, Avg(time) as Time
from Record
where Date between @startdate and @enddate
group by Asset, Location
Use CurrentAssetStats
Select CC.Date, CC.Asset, C.Location, AST.Production, AST.... 阅读全帖 |
|
k*z 发帖数: 4704 | 42 还有一个问题。
有人会用SSRS么?
公司用的是Domain windows directory来控制密码的,我需要怎么做,才能让别人访问
我机器上的ReportManager呢? |
|
p***c 发帖数: 5202 | 43 不懂什么意思,你是要把三个dataset join起来?
backend一个stored procedure就搞定了嘛
实在不行的话,根据我几个月前久远的记忆,ssrs里面有lookup,可以伪装join,就是
根据一个dataset里面的某个column去找另外dataset里面的数据
google下吧 |
|
s**********o 发帖数: 14359 | 44 TEST是个什么ACCOUNT啊,能READ你的SSRS REPORTDB吗? |
|
w****n 发帖数: 266 | 45 在装SSRS的server下, 找到ssms右键,properties->security,加那个list的帐号,
其他的帐号都没权限。 |
|
d**********3 发帖数: 1186 | 46 "ssrs里面有lookup,可以伪装join,就是
"
有吗? |
|
s**********o 发帖数: 14359 | 47 用ORACLE EXADTA作为SSRS的DATA SOURCE可行吗
领导要上,觉得很愚蠢,又不好明说,领导
说技术上可行吗,不行咱用别的,做个调研报告吧,
大牛指点一下 |
|
c*****d 发帖数: 6045 | 48 SSRS database source from Oracle db on exadata? |
|
s**********o 发帖数: 14359 | 49 大头已经拍板一定要上了Exadata,搞的REPORTING小组只能跟进,
原来的都是SQL SERVER SSRS系统,新系统选什么处境尴尬,
用ORACLE REPORTING,现在的人都要丢饭碗 |
|