Post New Web Links

SSRS 2008. collapsible rows and row visibility

Posted By: Posted Date: October 19, 2010 Points: 0 Category :Sql Server

I have a report that contains 10 group levels, I have made all 10 expand or collapse. When I get to the 10 group and expand it I have 2 or more depending on my result set of details records that appear. So far so good

Now my issues is that the groups do not all have values so I set the row visibility to false for the rows that have no data. This works except when I expand the last row only one row of the detail data shows up. How can I get it so that both details rows show up?

View Complete Post

More Related Resource Links

SSRS 2008 Toggling visibility changes the totals

SSRS 2008 When I toggle row (detail) visibility off, my subtotals are zero. My subtotals are correct when I toggle visibility on. I am using custom aggredate functions to producte the subtotals. It appears my custom functions are not called when visibilty is off How can I work around this? Thanks in advance for your help

SSRS 2008 Conditional Column Visibility Whitespace Issue

Hi Everyone,I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns.If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its place.I have used this functionality very frequently in SSRS 2005 without the whitespace issue. The 2005 report automagically closed this whitespace up by moving the column to the right of the hidden one to now be adjacent to the column to the left of the hidden one at rendering. This is what i need to happen now in 2008.Has anyone else experienced this? If so, would you please share your solution? I am getting extremely frustrated by this...Thanks!!

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control

MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.

Thanks.

Report Definition:

MainReport.rdl:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

SSRS 2008 R2 - Line chart labels - visibility based on expression?

I would like to control the visibility of a data label in a line chart using an expression. For example, I have a requirement to show the data label for two compariable data points in a line chart where the horizontal axis is time (Q1, Q2, Q3, etc...) and the data points are determined based on a selected parameter. The basic idea is that a user can select to view Q3 as the end point of reporting and the chart will graph a complete time line (e.g. FY 2001 thru FYXX Q3) but only show the label for Q3 and prior year Q3.

I have tried to build an expression in the visibility property of 'Chart Series Labels' but this does not appear to work.

In SSRS 2008, after export to Excel report loses nested visibility groups

IÃÂ have a reportÃÂ created in SSRS 2005 which is running on our new SSRS 2008 box.ÃÂ It has 3 nested levels of visibility so the recipient canÃÂ click the twist tie toÃÂ viewÃÂ different levelsÃÂ of detail.ÃÂ Each Zone has many Districts and each District has many Stores.ÃÂ The report renders displaying the summary of the Zones.ÃÂ If you click onÃÂ the twist tie on the Zone it opens up a list of Districts.ÃÂ If you click on the twist tie on a district, it opens up a list of stores.ÃÂ If you click on the twist tie on one of the stores, you get the actual details of all repair orders submitted for that store.

The report renders fine in report manager.ÃÂ The report has a subscription set up to run monthly that exports the results to Excel and emails them to our client.ÃÂ The problem is when the report exports to Excel the twist tie exists on the Zone, but it missing on each of the Districts andÃÂ Stores.ÃÂ The client is not happy about this.ÃÂ This report contains large amounts of data and is very combersome without the visibility grouping working properly in Excel.

I tried converting the report to SSRS 2008, but that did not solve my problem.ÃÂ

Is there anyway to fix the export process to Excel?ÃÂ

Thanks
Carol

P.S. I tried to upload the code, but it caused my question to be too many characters

Centering Images in dynamic rows - SSRS 2008 R2

Hi,

I'm using SSRS 2008 R2. I have a tablix in which one of the column has textbox grows dynamically based on the dynamic content and the other column is an image control. In the image control, i have a very small image and I want this to be centered in that cell. It always renders at the top left corner. Since the tablix row grows dynamically, I couldn't set the Top padding.

Any help would be appreciated.

Thanks,

Anitha

SSRS 2008 R2 and sharepoint 2007 report builder problems

I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend. Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint. The upgrade went fine, no errors that i could find. The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work? did i install the wrong version of the report builder add in? The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

SQL 2008 servers and MOSS 2007 with SSRS

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS. Here is the run down:

I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server. In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server. The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)? Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

SSRS 2008 Graph Type?

Greetings -

I am required to plot the following graph in an SSRS report.

Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.

(Sorry for the diagram below, i tried to paste an image but it didn't work)

SSRS 2008 date validation

Hello, Perhaps somone can shed some light on this. I want to make sure the user doesn't set a Startdate > EndDate in a report. I've done some thing like this: Go to the Report Properties under the Report menu and place this code to the Code Tab. Public Function CheckDate(SDate as Date, EDate as Date) as Integer Dim msg as String msg = "" If (SDate > EDate) Then msg="Start Date should not be later than End Date" End If If msg <> "" Then MsgBox(msg, 16, "Parameter Validation Error") Err.Raise(6,Report) 'Raise an overflow End If End Function Then go to the Report Parameters and Add named it XXX with the datatype is string. Checked the Hidden and Allow blank value ckeckboxes. In Available Values choose Non-Queried and from Default Values choose Non-Queried in right side of textbox then press the FX button then paste this code. =CODE.CheckDate( .Value) But I'm having problems with the =CODE.CheckDate( .Value) syntax. SSRS errors out. Any suggestions/insights? --joe

Dual values in Column chart Y axis in SSRS 2008

Hi, Any one pls tell me how to show dual values in Column chart Y axis. Example: Im showing Total Number of clients in the Y axis of column chart My Requirement is In that Y axis column chart also i want to show differently of Inactive clients from total number of clients. how to do this pls help me. Thanks in advance. TotalnumberOf clients : 1000 InActive Clients : 200 among TotalnumberofClients

Line Divider i n Column chart in SSRS 2008

Hi, Any one pls tel me how to do the single line divider in Column chart in SSRS 2008 example: --------- | | | 20 | ---------- | 100 | | | ------------------------------- i want to show the above example. Thanks in advance Regards, Abdul2010

Help Passing Multiple Parameters Via a URL in SSRS 2008

Hello Everyone, I'm totally and completely confused as to how to pass multiple paramters through a URL. Book Online is absolutely no help because they do not offer any examples of passing multiple paramters within a URL. Instead, I get confused over RENDER and COMMAND and what should be repeated where with each paramter and on and on and on. Here's my URL: javascript:void(window.open('http://sereporting01.wdig.com/ReportServer?%2fDOL%2fTEST%2fDisney+Sell-Through&rs:Command=Render&SiteName=Disney,InsertionType=300 x 250,Context=ROS','_blank','resizable=yes,toolbar=0,menubar=0')) What happens is that JavaScript opens a new window but I get a "Reporting Services Error". I'm assuming it's because my URL parameters are not correct. Can someone please just give me the correct syntax so that I can get on with my work? I'm editing this post to add - I'm also confused as to how paramters are supposed to be passed through to a report when default paramters are set up in the report which i'm trying to open with the URL. Should I remove the default paramaters from the report or...what? Again, BOL offers no help on this issue and it just seems to generate more questions. Thanks!!

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2. As soon as I put a 'default' value on the report param, everything is fine. However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello, I am able to login Web Service URL and report manager using computer name and report builder is also working fine. http://RPTSRV/reportserver (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver (web service url working fine. all accessible) http://rs.test.abc.com/reports (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....) when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL - all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SSRS 2008 Help?

I am Newbee i want to know is there a centralized and faster way to manage subscriptions in SSRS 2008. My question is can i manage Users to view certain reports based on their security level? My boss does not wan to use Report Manager...Any suggestions ???????FM

SSRS 2008 R2 - OnPostBack from ReportParameter - if no default set, throws Value can not be null

SSRS 2008 R2 - OnPostBack from Parameter selection - if no default set, throws Value can not be null java script error. This does not happen with SSRS 2008, only with R2. and only with report parameters that do not have a 'default' set. Any suggestions would be greatly appreciated.


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All