Reporting Services :: How To Use IIF Statement And Time Function Together SSRS

Oct 22, 2015

I am using the following function to set the time format, however I now need to to add an IF statement into this equation.This is the current expression I am using:

=Floor(Fields!ACD_Calls.Value / 3600) &":"& Format(DateAdd("s", Fields!ACD_Calls.Value, "00:00"), "mm:ss")

Now I need to use the following expression with this:

=IIF(Parameters!ReportType.Value="Average", Sum(Fields!ACD_Calls.Value)/CountRows(), Sum(Fields!ACD_Calls.Value))

How do I join the two together?

View 4 Replies


ADVERTISEMENT

Reporting Services :: SSRS Loses Ability To Delegate User Credentials To Database Time To Time?

Apr 30, 2015

we have problems with our SQL Reporting Service 2012 (SSRS) server . We have setup Kerberos delegation between SSRS and the database server (SQL Server Always-on cluster) so users are authenticated down to the database. The issue occurs from time to time that SSRS loses the ability to delegate the user credentials to the database. At this point in time the Report Server logs contain rejected database connections because of ANONYMOUS logon. After restarting SSRS the problem is gone.

View 2 Replies View Related

Reporting Services :: Real Time Reporting In SSRS?

Jun 19, 2015

We've got a requirement to build the real time report. user can browse report at any point of time and need to see the latest data(stock market) in the report.

I've few options down...

1. Directly point to OLTP database as source and write stored procedure to show result set.

2. Replicate the database and write the SP's to reports. To avoid pointing directly to OLTP db.

3. To build the datawarehouse with dim & facts to show it in reports. I prefer this as a standard method, but this would have some latency depending on trasaction load which will differ from the requirement.

View 3 Replies View Related

Reporting Services :: How To Call JavaScript Function In SSRS

Oct 8, 2015

how to call javascript function in SSRS Reports?

View 3 Replies View Related

Reporting Services :: How To Call Table Value Function In SSRS

Sep 23, 2015

How to call a table valued functions from SSRS reports ? 

Is there a way to call by selecting Dataset properties> Query >Stored Procedure radio button, If not then why our object type function is visible under this list.

MS SQL Server 2008 R2

View 5 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

Reporting Services :: SSRS 2012 Login Prompt During Run Time?

Oct 7, 2015

SSRS 2012 Login prompt during runtime?I've already did some work arounds that we're posted here but still doesn't solve the login prompt.

View 5 Replies View Related

Reporting Services :: How To Convert Int Datatype To Time Format In SSRS

Aug 20, 2015

How do we convert int datatype to "time format" like hh:mm:ss

ex:    123092   ( this 12  + 30 min + 92 sec)
       131137   ( 13 + 11 min + 37 sec)
       111747 ( 11 + 17 min + 47 sec)

View 5 Replies View Related

Reporting Services :: SSRS - Calendar Control With Time Picker

Oct 21, 2015

I defined my input parameter as date/time but it doesn't have a time picker where we can accept user input.

The calendar is great but time picker is missing.

Is there any add-in or tweaks I can use to get that feature ?

The alternative solution which uses drop down with some preset values are not feasible for me. All I need is just the time picker similar to adjust time in Windows.

View 4 Replies View Related

Reporting Services :: SSRS Multi-Value Parameter Feed To Table Value Function

Jul 24, 2015

I have an SSRS report with several variables, some of which are multi-valued.  The main query that feeds the report uses some table value functions.  For example, the query looks something like this:

select tv1.a, tv1.b, tv2.x, tv2.y, tbl.m, tbl.n
from tableValueFunction1(@MultiValueParam) as tv1
inner join tableValueFunction2(@MultiValueParam) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx

where tbl.abc in (@MultiValueParam).When I try to run this, I get an error saying that I'm feeding the wrong number of parameters into the table value functions.  I've fed multi-valued parameters to stored procedures before and used a splitter function to split out the comma separated values, so I was planning to do the same thing in this scenario.  However, this is different.  When I look at the query in SQL Profiler, it shows discrete values for the multi value parameter.  For example, the same query above looks like this when viewed through the profiler (using 1,2,3 as my multi-value selection):

select tv1.a, tv1.b, tv2.x, tv3.y, tbl.m, tbl.n
from tableValueFunction1(1,2,3) as tv1
inner join tableValueFunction2(1,2,3) as tv2 on tv1.xxx = tv2.xxx
inner join regularTable as tbl on tv1.xxx = tbl.xxx
where tbl.abc in (1,2,3)

In other words, SSRS isn't converting the multi-value parameter to a comma separated string, like it normally does.

View 2 Replies View Related

Reporting Services :: SSRS Datetimepicker And Textboxes Values Different When Using Weekday Function?

May 7, 2015

In my SSRS report i have a date parameter and i want to set to it a default value with a complicated logic. I arrived at this strange behaviour:

Today is May 6th, wednesday. If i use the following expression:

DateAdd("d",Weekday(Today(),DayOfWeek.Sunday),Today())

for the default time picker I get May 9th. If I use exactly the same expression in a textbox in the same report

DateAdd("d",Weekday(Today(),DayOfWeek.Sunday),Today()).ToLongDateString()

I get May 10th! The only thing that changes is the toString. Why are the two values different? I tried with different expressions and the difference arises when i start using Weekday(Today(), somevalue).

The result of Weekday should be independent from regional settings as I am forcing Sunday to be the first day of the week, right?

View 2 Replies View Related

Reporting Services :: SSRS Using Case Statement With Parameters - Can It Be Done?

Jul 13, 2015

I need to run a different select statement based on the value of a parameter. Visual studio is not liking how I am formatting it.  

SELECT mc.CtrlID,  mc.PrtfID, mc.PrtfTyp, mc.City, mc.STATE, mc.U_O_AND_M, mc.CHBBal,  mc.IRG_Number, mc.PrtfName, mc.LnID,  mc.UPB, mc.UPB_Master_Loan, aa.Prtf_FNMA_FHLMC_Other , aa.ReportingSummar
FROM             vw_XXX_GIAC mc
INNER JOIN vw_XXX_InvestorMatrix aa on mc.CtrlID = aa.CtrlID
WHERE
case when
@PortfolioID=1 THEN aa.Prtf_FNMA_FHLMC_Other ='FNMA'
@PortfolioID=2 THEN aa.Prtf_FNMA_FHLMC_Other ='FHLMC'
@PortfolioID=3 THEN aa.Reporting Summar ='FLOW'
END

View 2 Replies View Related

Reporting Services :: IN Statement In Where Clause In SSRS Query

Oct 12, 2015

I want to write a conditional where clause in SSRS query, such as

WHERE CASE WHEN @para = 1 Then Column1 Like '%%'
                    WHEN @para = 2 Then Column1 IN (@NameList) END;

What's the correct syntax to write the conditional where clause?

View 12 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 Errors - Procedure Or Function Expects Parameter Which Was Not Supplied

Nov 23, 2015

I have a report that uses a stored procedure as a dataset.The stored procedure accepts four parameters, which I have defined in the report. works fine in query builder and SSMS.

When I run the report I get an error stating a parameter is missing. I tried deleting parameters and recreating not luck.

View 4 Replies View Related

Reporting Services :: SSRS- How To Generate Sample Subscription Report Before Scheduling Time

Sep 24, 2015

How to achieve by using SSRS. How we can "quick run" report within the subscription menu to ensure report was set up correctly during creation.  Is there any way to generate sample subscriped report without waiting for scheduled time.

I mean whether we can verify the report parameters & data in generated the report. I have verified SSRS report manager .i cant see any button or option to test run the report in subscription feature.

View 6 Replies View Related

Reporting Services :: Merge IF Statement And Time Format

Oct 22, 2015

I am trying to do an IF statement based on the parameter (Average or Total). However I am struggling with how to put the two together.

=Floor(Sum(Fields!Avg_ACD_Time.Value)/ 3600) &":"& Format(DateAdd("s",Sum(Fields!Avg_ACD_Time.Value), "00:00"), "mm:ss")
=IIF(Parameters!ReportType.Value="Average", Sum(Fields!ACD_Calls.Value)/CountRows(), Sum(Fields!ACD_Calls.Value))

View 5 Replies View Related

How To Convert UTC Time (retrieved From SQL) To Local Time In Reporting Services Based On Time Zone

Aug 7, 2007



Hi all,

I have created a report in SSRS 2005 which is being viewed by users from different Time Zones.

I have a dataset which has a field of type datetime (UTC). Now I would like to display this Date according to the User Time Zone.

For example if the date is August 07, 2007 10:00 AM UTC,

then I would like to display it as August 07, 2007 03:30 PM IST if the user Time Zone is IST.


Similarly for other Time Zones it should display the time accordingly.

Is this possible in SSRS 2005?

Any pointers will be usefull...

Thanks in advance
sudheer racha.

View 5 Replies View Related

Reporting Services :: Interface Code Compatibility Between Custom Delivery Extension Of SSRS 2008R2 And SSRS 2012?

Sep 3, 2015

Currently we are using Custom Delivery Extension for SSRS 2008R2 We are planning to move it SSRS2012

My Question is: Whether we can use the same Code used for SSRS2008R2 to SSRS2012?

if not what code changes we should do?

View 3 Replies View Related

Reporting Services :: Parameter Filters - Start Time And End Time

Sep 14, 2015

At the moment I already added the DataSet I'm gonna be using. I have 2 date parameters Start Time and End Time.

What I would like to do  for the report is to only pull results greater than 48 hours to the report

How can I accomplish this?

View 4 Replies View Related

Reporting Services :: Get Report Toolbar Using SOAP API In SSRS Reporting?

Nov 3, 2015

Is there any way to get the report toolbar using SOAP Api  in SSRS reporting.

View 6 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 (SSRS)

Sep 29, 2006

Hey everyone...I'm completely new to SQL Server and I'm trying to learn the Reporting Services tool. I just installed SQL Server 2005 and selected to install all the options, atleast I'm 99.99% sure I did.

When I go to launch Report Services Configuration, I get "No report servers were found on the specified machine. Details: Invalid namespace". Do I need IIS for this to work?

Also, I do not think the AdventureWorks database was installed, I cannot seem to find it anywhere. I have tried to go back through and reinstall it, but it says that it is already installed.

Also, is there a certain order that you are supposed to install things? i.e. SQL Server before Visual Studios?

Thanks in advance.

*Edit*  BTW, I'm using Windows XP, SQL Server Enterprise Edition, and VS.NET 2005.

View 5 Replies View Related

Reporting Services :: SSRS Pop Up Box

Aug 5, 2015

Is it possible to have my pop up SSRS box size according to the size of the returned value? Issue is, i have a text box that returns a note field and depending on the number of notes, it can and will vary in size. I am currently using this code

="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"
&Globals!ReportFolder &"/Patient%20Eligibility&rc:Parameters=False&rc:Toolbar=False
&VPATIENTPROFILEID="& Fields!PatientProfileID.Value
&"
','DetailsWindow','left=300,top=180,width=920,height=455,status=no,menubar=no,scrollbars=yes,location=no'" &
")"

View 2 Replies View Related

Reporting Services - Crystal To SSRS

Sep 5, 2005

I have a requirement to convert reports from Crystal Reports to SQLServer Reports. Is there any tool to do this? or Do I need to redesignevery report in SQL Server Reports?Madhivanan

View 2 Replies View Related

Reporting Services :: SSRS Only Display One Row

Sep 13, 2010

I am using VS 2010 and the SSRS that came with it. I am sure its SSRS 2008. Anyway, I added a report file to the project, added an ObjectDataSource and connected this to SQLServer 2008, and display the dataset on the report. The report is using ScriptManager, ReportViewer1, and Report1.rdlc file. I preview the dataset and I have multiple row returned. The problem is I only have one row displayed on the report. Maybe I did a quick and dirty report? What setting of properties did I missed?

View 8 Replies View Related

Reporting Services :: While Do Loop In SSRS

Aug 13, 2015

I have to convert 'While Do' loop logic in Crystal to SSRS. How to use loops in SSRS.

View 12 Replies View Related

Reporting Services :: SSRS Report To Run URL?

May 29, 2015

We are trying to use reporting services to execute a url when the SSRS report is executed. For example when I execute a SSRS report I would like the report to automatically access [URL] (as an example). The reason we are doing this is we want to access another reporting application but record the number and times of access via the reporting services execution tables/views. Is this achievable by putting some code in the Report properties. Can you open - execute url and then close report via some code.

View 3 Replies View Related

Reporting Services :: KPI In SSRS Reports

Apr 29, 2015

I have a Manager dashbord  report.In this report 1st page contains some tables and 2nd,3rd page contains line charts with tables.Actually what we need is in 1st page tables are pretty simple,we need to add kpi's and shown these tables in kpi. kpi in ssrs and how to add kpi in ssrs reports?

View 2 Replies View Related

Reporting Services :: 5 Day Calendar In SSRS

Feb 9, 2015

I have tried different techniques to design the report but no luck,

1) design staff 5 days schedule as a calendar between two dates and 
2)each staff can have more than one schedule on the same day.
3)Only one staff per page.
4) week will start based on date  ex: for staff 2 calendar will start based on date.

Wednesday   Friday       Tuesday     Wednesday    Thursday 
01/01/14     3/01/14    7/01/14    8/01/14          9/01/14

Sample data:

expected format:

Staff1 (page 1)
Monday      Wednesday     Friday    Monday
13/10/14   15/10/14   17/10/14   20/10/14

Staff 2 (page 2)
Wednesday   Friday       Tuesday     Wednesday    Thursday 
01/01/14     3/01/14    7/01/14    8/01/14          9/01/14

(page 3)
Saturday      Wednesday   Thursday     Friday         Wednesday
11/01/14     15/01/14    16/01/14    17/01/14       22/01/14
and so on....

View 9 Replies View Related

Reporting Services :: Mdx Multi Value In SSRS?

May 30, 2015

I was trying to have multivalue options in a ssrs report, and I used this query  

SELECT {[Measures].[Sales Amount],[Measures].[Tax Amount]} on columns,non empty([Product].[Color].[Color],[Product].[Product Name].[Product Name]) on rows

from
( select 
(STRTOSET(@color))
 on columns
 from [Analysis Services Tutorial])

But the report only showed the default value as an option(in this format [Product].[Color].&[Multi] whic is not presentable),and what I also noticed in the parameter option is that, the available values option is set to none , also when I try to use get from query , it does not give me the vales for the parameters,and when I right click the designer pane it does not have the show hidden dataset option.I have created the parameter with multivalue option. what can I do to get the multivalue option to work.

View 2 Replies View Related

Reporting Services :: SSRS Rendering In CSV

Jun 11, 2015

My system environment: win2008 R2 SP1 64bit + SQL 2005 SP4 32bit

I amended the configuration file of rsreportserver.config with the below:

<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" >
  <Configuration>
  <DeviceInfo>
   <Encoding>UTF-8</Encoding>
  </DeviceInfo>
  </Configuration>
   </Extension>

If I run the report and then click export by selecting the csv format, it looks ok with the encoding of UTF-8.

However, the same report , when I created a subscription and saved it in the hard driver. Its encoding became USC-2 Little Endian.

View 2 Replies View Related

Reporting Services :: SSRS - Export To CSV

Jan 7, 2010

When the SSRS report exported to CSV file,  all the column headers are added in the first row. The issue here is, I have hidden( thru Visibility property) some of the columns in the report but those columns are also displayed in the header row(first row)CSV file and the blank values for their corresponding data.for example, I have displayed only below 3 columns out of 6 columns in the report.col1, col2, col3but the CSV generated as below:

format..col1,col2,col3,col4,col5,col6a1,a2,a3,,,b1,b2,b3,,,c1,c2,c3,,,

I don't want the highlighted items.The TableColumn Visibility property has been setup as below..

=IIF(Fields!col4.IsMissing, TRUE, FALSE)

When the report is exported to other formats(like Excel,XML..) this works fine.. i.e., no hidden columns are displayed.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved