Reporting Services :: SSRS 2008 R2 - Create A Single Vertical Stripline At Specific Date Value Along X-axis?

Jun 5, 2012

I'm struggling with trying to display a single vertical stripline at a date value along my x-axis. 

I'm using the following non-default settings within the stripline editor:

bordercolor = tomato
borderstyle = solid
borderwidth  = 1pt
intervaloffset = Fields!uidate.Value.ToOADate()

where uidate is a calculated field in my dataset that always has the value of 05/29/2012  (using formatdatetime("05/29/2012",dateformat.ShortDate))

Everything else is set to Auto, with stripwidth=0

I'm trying to display a single vertical line at the x-axis value of 05/29/2012

I have previously tried setting the interval offset to "05/29/2012" but that didn't work. I've also tried setting the value of a hidden text box on the report to "05/29/2012" and setting the interval offset to the value of that text box, but that gave me a "text box not declared" error.

How I can simply display a vertical stripline on my line graph at the x-axis value of 05/29/2012 ?

View 2 Replies


Reporting Services :: Need To Remove 0 From Vertical Axis In SSRS

Oct 30, 2015

I'm putting Interval 50 and Maximum 100 in Vertical Axis Property but by default 0 is coming. I unchecked mark of Always include Zero Box and Minimum is Auto. But still I'm getting 0 in Vertical Axis Chart in SSRS.

View 7 Replies View Related

Reporting Services :: SSRS - X Axis Date Interval Of 5 Days

Nov 20, 2015

I have line chart and want to see the xaxis date on interval of 5 days and it should start from first date and end at last date.

If my range starts from 11 Nov to 1 Dec 
11 Nov 16 Nov.....1Dec

My date column have null fields . Though I have tried putting dummy values it still does not work so its not the problem of NULL.

I am getting Below results:

If I keep Interval one it starts form 11th and ends at 01 dec but it shows all dates.

View 3 Replies View Related

Reporting Services :: Date Labels On X Axis In SSRS Line Chart

Jul 27, 2015

What is the best optimised options to display the date labels with bi-weekly intervals starting date Date from one month to three months future from the current date?

As per above requirements, I have built the below line graph query and graph, currently it only displays the date labels as per data but I need to display date labels with bi-weekly intervals starting date from one month to three months future from the current date. Also another issue found, if there are few more date labels then does not show all labels on horizontal axis.

/* Set Week End date as Sunday */
DATEADD(DAY, 7 - DATEPART(WEEKDAY, t.TaskBaseline0FinishDate), CAST(t.TaskBaseline0FinishDate
+1 AS DATE)) as[WeekEnd]
,count(t.TaskBaseline0FinishDate) as Baseline
,count(t.TaskFinishDate) as Finish

[Code] .....

View 3 Replies View Related

Reporting Services :: Vertical Axis Data Labels Repetition / Duplication

Sep 15, 2015

When I tried to create a bar chart using SSRS 2012, the vertical axis values are repeating for smaller data sets values. It's only happening when the data labels are below 5, when the data is above 5 this chart represents data fine.

I tried specifying the custom intervals and this option all together eliminated the  bar for value 1, instead it only showed the value 1 as text on the chart.

I tried changing the data interval type as number and the data type is of Integer, these are counts which I am showing in the chart.

View 3 Replies View Related

Reporting Services :: Create 32 Tile Heatmap In SSRS 2008 R2?

Dec 23, 2011

i need to create a 32 tile Heatmap in SSRS 2008 R2,I am not too concerned with adjusting colours by values, I just need to get the 32 tiles in place in the report initially, then extend it with more functionality later on.

View 4 Replies View Related

Reporting Services :: Create Dashboard With SSRS 2008 R2 Native Mode?

Jul 22, 2015

We want to create interactive dashboards using SSRS 2008 R2. We currently has Report Server installed in Native mode. I see that we can build some good dashboards using SSRS, SharePoint 2010 and PerformancePoint. But I wanted to find out if we can build that level of dashboard using just SSRS. We are still convincing the management for getting SharePoint license. In case if they don't agree for the Sharepoint license, can we build some good dashboards just using SSRS?

View 5 Replies View Related

Reporting Services :: Start And End Date Parameters Report In SSRS 2008 Is Not Running On Runtime?

Aug 27, 2015

I made one report in SSRS 2008 in which getting data from one SharePoint List.

three parameters in report :


I am using query which I created with CAML.

query is running well and data is coming correctly if I run this on Query designer.and date format must be YYYY-MM-DD.but when I try to run through on run time then the date control is showing format dd/mm/yyyy.

I change the regional settings of windows and SharePoint site to English(United States). and when I select date control it is also putting date in format like "YYYY-MM-DD'. and in that format report is working well in Query designer view.But on run time still it is not working.

View 3 Replies View Related

Reporting Services :: How To Show The Chart Data In Y Axis In SSRS 2008R2

May 22, 2015

I have requirement where i want to show my chart report data in Y is possible in SSRS 2008R2? or it is possible only in SSRS 2012 only?

View 7 Replies View Related

Reporting Services :: SSRS - Display Static Time Range On Y-axis?

Oct 6, 2015

displaying time interval on y -axis for an ssrs report.

the values are static... it should start from 00:00 - 23:59 with 00:30 interval....

interval of 30 mins...

I tried several functions that are available but didnt work.

View 6 Replies View Related

Reporting Services :: SSRS Group Total To Contain Values Of Specific Groups Only

May 25, 2015

I have a requirement to display the total of a Group after subtracting a specific value from the same Group.

Example: Say the below data is grouped on a particular column 

Group Values Month

Jan-15 Feb-15 Mar-15

A 10 20 30
B 5 10 25
C 1 2 3
D 5 10 15

Total 11 22 33

Formula is :  Sum(A+C+D)- Sum(B)

What is the best way to Group the above scenario from SSRS level and display the result as shown above. I am able to display all the values except the last total row where am displaying the complete total i.e. 21  42  73.

How do I dynamically subtract the values for row B which is one of the group values.

View 4 Replies View Related

Reporting Services :: SSRS 2008 R2 - HTTP Error 503 - The Services Is Unavailable

Jul 23, 2010

We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2.  It works nicely.  Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production).  After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable."  I can't connect via http, or SSMS.

We have tried:

* Running SSRS config tool (several times)

* Running with/without the IIS Server Role

* Dropping & recreating the SSRS keys

* Recreating the ReportServer database, etc

* Checking all of the accounts, permissions, etc

* Running SQL Repair

* Going through the registry to fix any references to the machine's old name

* Uninstalling, reinstalling SSRS

* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.

None of this has worked.  SSRS [R2] is still 503 on our test box.

the SSRS [NT] service seems to run, without error.  The Event Viewer doesn't seem to be recording any errors.  The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine.  The other SQL Logs say something about not being able to contact the service.  However, as I said, the [NT] service seems to be working fine.

View 4 Replies View Related

Reporting Services :: Searching By Single Date Or Date Range

Apr 22, 2015

I would like to be able to search by a single date, @StartDate, or by a date range , between @StartDate and @EndDate. I am having a hard time with the logic on this for a report in SSRS.

View 5 Replies View Related

Reporting Services :: Migrate Single SSRS Report Folder

Jul 30, 2015

I have old sql server 2008 with reporting service and new one 2012 version and I need to move single report folder from old server to new server. Is there any tool or script can make that possible.

View 5 Replies View Related

Multi Value For Single Parameter (reporting Services SSRS 2005)

May 1, 2008


I'm using SSRS 2005 which connects to SQL Server 2005. I need to pass Multi valus for single parameter...

E.g. Command type : Text
SELECT * FROM COUNTRY where CountryId IN ( @CountryID)

If i tried to preview using single parameter, it shows the record without any problem. However when i tried to put multi values, it gives error message?? I read somewhere which says, need to set to multivalue. But, i could not find the place to set the multi value option...

How to solve it?? Your suggestion/recommendations greatly appreciated.


View 5 Replies View Related

Reporting Services :: How To Create Multi-valued Parameter For Only One Specific Condition

Jul 21, 2015

I have report where i should create a report which is multivalued parametr report,but here my condition is i want to see only one county name  in my output that is Ex: Asia Specific (CountryName),I dnt want to see the other Country names,So how should we create for this condition .

View 5 Replies View Related

Reporting Services :: Row Percentage Calculation In SSRS 2008 R2

May 11, 2015

I have a matrix in one of my SSRS report data is like below

Row as Branch
Column as Tasks (Progress, Completed , cancelled, In Complete)

Branch   Progress  Completed  cancelled  In Complete    Total    %(Complete/Total)
Aus           1             2               3                 4                    9                      22.2%
NZ            1             2               3                5                    11                      18.88%
US           0              0               3                 3               6                          0.00%

How can do in the SSRS matrix %(Completed/Total) percentage calculation ?

View 4 Replies View Related

Reporting Services :: SSRS 2008 Legend Sorting?

Jun 10, 2009

Is there anyway in SSRS 2008 to sort the Legend on a chart?  Right now I am unsure as to how it is currently sorting.  I see a property to Reverse the order, but I don't see anything to alphabetize it.

View 8 Replies View Related

Reporting Services :: SSRS 2008 - Trying To Sum Lookup Values

Feb 13, 2012

I have 2 datasets, dataseta is a list of tickets and their relevant owner and databsetb is a list of owners and a days worked first against them.I have a table with a detail grouping on ticketid and a normal grouping on owner which works well... all straight forward to this point. In this table on the owner grouping level I also have a lookup to datasetb which pulls back the days worked per owner which works fine as well. But what I now need to do is total the days worked over all owners, which sounds simple but doesn't work. This is the expression on the days worked for each owner -

=lookup (Fields!owner. Value, Fields!owner.Value, Fields!Days_worked.Value,"datasetb")

If I add a sum around this then it uses the figure above but multiplies it by the amount of tickets in the detail grouping.

View 6 Replies View Related

Reporting Services :: Open URL In New Tab Rather Than New Window In SSRS 2008 R2

Dec 18, 2012

Below is my navigation URL link ..I want the drill through to open in new tab rather than new window..I believe i need to change the newwin.

="javascript:void('"+ Globals!ReportServerUrl + "?" +  Globals!ReportFolder + "%2fReportName&rs:Command=Render" +"&YQM='+escape('"+Parameters!YQM.Value.ToString() +"') +'&Status='+escape('"+Parameters!Status.Value.ToString()
+"') +  '',  'newwin', 'screenX=0,left=0,screenY=0,top=0,status=1,menubar=1,resizable=1,scrollbars=1,toolbar=1,location=1'))"

View 12 Replies View Related

Reporting Services :: SSRS 2008 R2 Not Processing Subscriptions?

Apr 29, 2015

I have a RS 2008 R2 SP3 Service in SharePoint Integrated Mode.

Since 5 days my Subscriptions were not sent anymore. I did no changes to these machines. There were some data driven subscriptions in pending state. I delete these entries via SharePoint.

When I look at Report server  Execution Logs, there is no error, that i can associate to subscriptions. New Subscription are created and deleted in the Log, but they will never been processed.

I have done a Reboot to the RS Box but, that was not the solution.

View 4 Replies View Related

Reporting Services :: SSRS 2008 Conditional SubTotal

Apr 23, 2010

I've got an SSRS 2008 report with 4 nested groups on rows.  Report requirements are that each new group at each level have a subtotal.  I've gotten this to work just fine.  After the users saw the report, they had a new request - if the SubTotal has only 1 row to Subtotal, do not display the Subtotal.  If there are 2 or more rows, display the Subtotal line.I know I can go to the Grouping Properties, and on the Visibility properties select the "Show or hide based on the expression" - I am struggling with the experssion.  How  can I check to see if there are more than one row at this group level? The query is SQL with 2 sub selects, and 7 tables in various join clauses. 

View 15 Replies View Related

Reporting Services :: Excel Formulas In SSRS 2008

Jul 20, 2010

I need to have a report that will have formulas in excel. I understand that the limited support for exporting excel formulas has been dropped in SSRS 2008. Is there any way to work around this and still output formulas?obvioulsy the way to do it in previous versions of SSRS are not working (using report items). I tried to add my formulas in my dataset (I can know which excel cells I need in the formulas) but they end up being displayed as text. I then have to get in the excel file and enter and exit each cell so that it "becomes" a formula.

View 11 Replies View Related

Reporting Services :: How To Enable ADFS For SSRS 2008

Aug 3, 2009

How to enable ADFS for SSRS 2008?

View 4 Replies View Related

Reporting Services :: SSRS 2008 R2 Toggle Display?

Sep 25, 2015

Is it possible to hide the entire toggle line and the symbol but still shows the children? I must keep the children in this container.



View 5 Replies View Related

Reporting Services :: SSRS 2008 - Print Preview In IE 11

Nov 16, 2015

I'm using SQL Server 2008 SP3 with Reporting Services 2008 SP3.

By opening my web application in IE9 and running report, i can print and show then print preview by clicking the "Print preview" button in printing dialog.

By opening my web application in IE11 and running report, i can print the report but if I click on the print preview on the print dialog nothing appears... Why?

View 3 Replies View Related

Reporting Services :: PivotTable Report In SSRS 2008 R2

Jun 17, 2015

What is the best approach for turning the report below into a PivotTable report in SSRS 2008 R2?The PivotTable has the following characsteristics:

Filters:     None
Columns: Mat_Month
Rows:      Level1, Level2
Values:    MaturingBalances

We have an SSAS Cube with the same data (in a dimensional schema).The report (currently sourced via SQL from our data warehouse):The Pivot Table - currently in Excel but needs to be ported to SSRS

View 3 Replies View Related

Reporting Services :: SSRS - Summing Up Positive And Negative Values Alone From Single Column?

Sep 18, 2015

MS SQL Server 2008 R2

I have both positive and negative values in a single column, where I want sum total of positive values & negative values. Is there any Expression for this to sort out.

View 8 Replies View Related

Reporting Services :: How To Export 2 Datasets To 2 Excel Sheets In Single Report SSRS

Jun 21, 2015

I have two different dataset in one Report, Each Dataset result is binded to a different Table component.

When I export as Excel ,I am getting all this in One Excel sheet.

I need this in separate excel, as dataset1 in excel1 and dataset2 in excel2.

View 3 Replies View Related

Reporting Services :: Displaying RTF Text In SSRS 2008 Report

Nov 8, 2009

I have database fields that contain RTF text. If I use the default Textbox in SSRS 2008 Report Designer, I get all the RTF formating characters, which makes for a VERY ugly report.Is there another control I can place on my report that will take the RTF formated text and display it properly? I can do this in Crystal Reports, but I'm converting to SSRS 2008 so I need to be able to handle RTF formated text.

View 4 Replies View Related

Reporting Services :: How To Remove Duplicate Rows In SSRS 2008

Dec 21, 2011

I have a dataset in my report that pulls 10 fields. One of the tablixes on report should display only 8 of the 10 fields and this is causing the duplicate records to show up on the tablix.I tried hide duplicates option for the entire details row and have set the scope to "Details". It did not work. I am getting the data from a stored procedure and cannot do much on that.

View 7 Replies View Related

Reporting Services :: SSRS 2008 - Row Visibility Is Not Working Correctly

Mar 2, 2012

VS 2008. I have the following set up. Group1, Group2, Group3 header, Group 3 detail rows..When I set the row visibility (hide based on Group2) on the Detail row, it still shows up when the report is originally rendered.

It should be: Group1 expanded, Group2 collapsed, Group3 header hidden and detail rows hidden
It is showing: Group1 expanded, Group2 collapsed, Group3 header hidden, Group3 detail row visible.

I never had this trouble in 2005. Is there something different about row visibility in 2008?

View 3 Replies View Related

Reporting Services :: Using Join Function For Fields In SSRS 2008

Jun 30, 2009

we need the list suppliers in a text box,if it were a parameter, we can do it by =join(parameters!Supplier_ID.Value,",")but if the Supplier Id is a field , join (Fields!Supplier_ID.Value,",") doesnt work!how to achieve this.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved