Reporting Services
Reporting Services, One of my major strong points ( Sql/Olap )
For those still looking how to client print a Report
just add to the URL the following in the end
&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
worked for me
I've been neglecting my BLOG so here's a more productive post:
Installing reporting services side by side with Sharepoint 2003 ( or WSS_V2 )
Which has more then one IP , and has trouble connecting to the DNS .
Ok here goes:
First you boil the egg …. , ehh wrong recipe , I'll get to that latter J
Ok my mistake , ….
1. do exactly what it written in
Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp
but … the web version ( the above ) is an old documentation so use the CHM file which is located in the root directory of the Install CD .
2. due to the fact that in my case the localhost was pointing to the 'wrong' IP
( the SPS was on the other IP ) , and 'we need' the RS on the same IP as the SPS ..
Part 2 of the instructions was done again with a minor change
STSADM.EXE -o addpath -url http://10.1.100.17/ReportServer -type exclusion
STSADM.EXE -o addpath -url http://10.1.100.17/Reports -type exclusion
3. The web.config should be with read option on to the "IIS Worker Process Group"
4. In the directory
c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
there's a file named "RSWebApplication.config"
you have to check that the URL in it is working
meaning : <ReportServerUrl>http://MESHXP/ReportServer</ReportServerUrl>
is working correctly , in our case there was no connection to the DNS so it was changed to :
<ReportServerUrl>http://10.1.100.17/ReportServer</ReportServerUrl>
5. last but not least , don’t forget to build two groups in the local machine
"ReportingServices Admin" and "ReportingServices Browsers" which will be assigned the roles of "Content Managers" and "Browsers" accordingly in the RS HOME ( root ) dir security ( that for SysAdmin use )
That should do it
Adlai
So you want to Color each group in the table in alternating colors ,
but each group 'instance' has different amount of items
well ... the solution is :
=iif(RunningValue(<table1_Group1 grouping expression>,CountDistinct,Nothing) Mod
2, "LightBlue", "Orange")
e.g. : =iif( RunningValue( Fields!InsuredID.Value , CountDistinct,Nothing) Mod 2 , "#F1F9FF", "#DFEBF5")
As time goes by, I'm beginning to be more and more disappointed from the DUNDAS graphs. It seems that if you "Insert" a tool tip which "points" to "Field" for the same ( or other DataSet ) , COMPILE will throw an Error which specifies that a reference to a non existing Filed is in the report , strange don’t you think ?
It took me a whole day to figure it out ( I didn’t compile right away after the change )
What can I say ….
As you all well know the graphs in the RS are from www.dundas.com , but parhaps due to the fact that this V1 of the RS , and the fact that this is an out side source component , a few flows were encounted.
here's the solution to a few of them :
1. you want to create a percentage graph and the percent value ( due formating “P” is in thousands )
solution : change the format to the follwing : ##0.##,"%"
2. the X Axis title is too long ( width problem ) and you want to “insert an enter“
solution : use VBA - & vbCrLf & - in between strings, for example :
= “My “ & vbCrLf & “ Total “ & vbCrLf & “ Customers “ & vbCrLf & “ Are “ & vbCrLf & Format( Fields!Measures_Total_Cust.Value ,"###,###,###")
3. create a pop up from the graph/report for drill options
solution :
a) create an ASP.NET project with an ASPX file RdrctWebForm1.aspx
b) goto into the HTML Source of the ASPX page and add the following
<form id="Form1" method="post" runat="server">
<script>
window.open("Drill_Report.aspx?<%= Request.QueryString.ToString() %>",'','left=250,top=200,width=600,height=400,menubar=no,toolbar=no,resizable=yes,scrollbars=yes');
self.history.go(-1);
</script>
</form>
c) Choose the wanted place for link/pop up goto “Action” properties
and add the link
e.g. : =”http://localhost/MyRSAddon/RdrctWebForm1.aspx?val1=1&val2=” & Fields!Measures_Total_Cust.Value