Reporting Services :: Employee Hierarchy Query In SSRS

Sep 18, 2015

I have one view, i written below query to get employee hierarchy based on orgid and employee name..

If i select employeename it shoukd show employee reporties(under employees and below employee reporties like tree structure)

It is running fast in SSMS Level, but it is taking more time in SSRS(Sql Sever Report Services), If i run this query in SSRS,Some times System not responding. 

Declare @OrgId int
Declare @EName varchar(30)
Set @OrgId=56793
Set @EName='ABCD'
Select EmpId

[Code] .....

View 9 Replies


ADVERTISEMENT

Reporting Services :: Employee Hierarchy In SSRS

Sep 15, 2015

I have a requirement,Create employee hierarchy(tree structure) with two parameters 1)OrganizationId 2) EmplyeenameIf i select one employee, it should show only the employees reporting to him. URL....I created one level, if i select one employee , i am not able to see the reporties names.

View 3 Replies View Related

Reporting Services :: Employee Not Showing Under Correct Manager

Jan 8, 2015

I have been using this query inside the package that I created to load data into cube. From this cube I am fetching records for my cascaded parameterized report. The issue here is one of the employee is showing under different team manager and site manager. This team manager has left the company and now the employee is back to its previous team manager. here is the code:

Truncate table CallCenterEmployee.dbo.tblCube_Staff;
GO
Insert Into CallCenterEmployee.dbo.tblCube_Staff
SELECT     dbo.tblStaff.Emp_N
, CONVERT(varchar, dbo.tblStaff.Emp_N) + CONVERT(varchar, tblDate.ID) AS SurrogateKey
, dbo.tblStaff.StaffId
, dbo.tblStaff.First_M
, dbo.tblStaff.Last_M

[code]...

View 5 Replies View Related

Transact SQL :: Employee Hierarchy In Server

Sep 9, 2015

I want to get the employee hierarchy like tree structure and reportes.

View 7 Replies View Related

Reporting Services :: SSRS To Avoid Writing MDX Query?

Sep 21, 2015

When I use an SSAS cube in Excel the command text is just the name of the cube itself and does not require an MDX query.  Is it possible in SSRS to avoid writing an MDX query?

View 3 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 :: How To Call Boolean Parameter In SSRS Query

Sep 7, 2015

How to call Boolean/Text parameter in SSRS Query.

Parameter (Cust )Properties:

My Query:

SELECT   dbo.incident.incident_ref, Customer.cust_n,incident.date_logged FROM
incident INNER JOIN Customer ON incident.incident_id = Customer.cust_id
WHERE   incident.date_logged BETWEEN @date_from AND DATEADD(day, 1, @date_to)

I need to use a condition here to display customer based on my selection in dropdown list (Include ABC )

View 5 Replies View Related

Reporting Services :: Pass A Parameter To LDAP Query In SSRS

Aug 20, 2015

Is it possible to use a parameter in a ldap query using the ADsDSOObject provider?  I keep getting an error "The ICommandWithParameters interface is not supported by the "ADSDSOObject" provider".  Command parameters are unsupported with the current provider.

I don't have a linked server on my DB server to Active Directory so I'm just querying in the SSRS report design.  Here is my query for my dataset.  If I hard code an example it works.  Just doesn't work when I pass a parameter. I've tried making it an expression (= sign), Tried several syntax's, Tried everything I can think of.  Is this possible? or do I just need to push for a linked server?

="SELECT sAMAccountName, displayName, distinguishedName " +
"FROM 'LDAP://DC=xxxx,DC=xx,DC=xx,DC=xx,DC=xx,DC=xx' " +
"WHERE objectCategory = 'Person' " +
"AND objectClass = 'user' " +
"AND memberOf = '" + @GlobalGroup + "'"

View 3 Replies View Related

Hierarchy Problem In Reporting Services.

Jan 30, 2008


I am attempting to create a report in Reporting Services 2005. However, I have a problem with creating a group underneath a hierarchy group. No data displays in the group below the hierarchy group. For example, if I have a top level group called group 1 which is not hierarchical then a group 2 which IS hierarchical then group 3 under group 2 then groups 1 and 2 will not display properly. However, if I remove group 3 then the first two groups display properly. I even tried using a second reporting services table using the same data set but could not get that to work. I'm really running out of ideas. Any help is welcome.
Thanks.

View 8 Replies View Related

Reporting Services :: SSRS Dataset Query Design Error Source

Nov 3, 2015

When  I click on the DataSet Query Desginer there is an Error Source:.NetSqlClient Data Provider. why this error comes and I have executed the SQL query in SSMS succesfully and the result comes. However this is causing the report from the report manager to fail.

View 8 Replies View Related

Reporting Services :: How To Filter MDX Query Using SSRS Report Parameter With Multiple Values

Oct 14, 2009

I am creating a SSRS report using a SSAS cube as it data source.  The user would like to select multiple values from a reporting parameter that is then used as a filter on the MDX statement.  I am bale to have the report work successfully when only one value is selected but not when multiple values are selected; the report uses only the first value from the reporting parameter when it contains multiple values.  How do I filter an MDX query using a SSRS report parameter with multiple values?

View 3 Replies View Related

Reporting Services :: Query To Pull SSRS Parameter Properties (Hidden / Visible / Internal)

May 19, 2015

We have 1000s of SSRS reports hosted on the SQL 2008 R2. All reports are supposed to have all parameters "hidden". Random reports have been reported to expose the parameter when developers accidently deploy to test servers. Is there a way to identify the reports and the parameter property (Hidden, Visible, Internal) from the Report server Database?

I checked executionlog2 but can not find the parameter property.

View 7 Replies View Related

How To Drill Down A Parent Child Hierarchy In Reporting Services 2005 ?

Sep 26, 2007



Hello,

I want to enable a drill down on a parent child hierarchy, just as it is possible in the Analysis Services.


An Example :



Hierarchy in a company : Jack (1) is the boss, Frank (2) and Andy (3) ar the Semi-Bosses , and Julia (4), Jane (5), Henry (6), Michael (7), Will (8) , Dave (9) are normal employees . Timmy(10) is a trainee. Furthermore Frank is responsible for Julia,Jane and Henry and Andy is responsible for Michael WIll and Dave. Dave is responsible for Timmy. So we get the following tree hierarchy structure.

1
2 3
4 5 6 7 8 9
10

My Employee Dimension Attributes : Name, Parent

I want to make a report, where I show the salary of each employee. But at first the user only sees 1, when he drills down he sees 2 and 3, too. When he drills down once more he sees 4 5 6 and 7 8 9, too (The user must be able to recognize which person is responsible for 456 and which for 789). And the last drill down shows 10, for which 9 is responsible ( exactly as it is possible in the analyis Service in the Cubebrowser)



I have read some posts where are MDX examples which are similar to my problem, but they did not solve my problem.


I hope somebody can help me


JF

View 6 Replies View Related

Reporting Services Error When Preview/publish A Report Containing SAP BI Hierarchy

Jan 28, 2008

Hi SSRS Experts

I'm trying to create a report using a SAP BI InfoCube as my datasource.
One of the fields in the InfoCube (GL Account) consist of a 3 level hierarchy, which need to be reported on.
The query that I built using QueryBuilder executes fine and displays the hierarchies correctly, but when I preview the report, i get the following error:

An error occurred during local report processing
An error has occurred during report processing
Query execution failed for data set "SAPBWD"
The "0GL_ACCOUNT 1000IE" Object was not found.


0GL_ACCOUNT is the GL account field to report on
1000IE is the selected GL Account Hierarchy to be displayed

Here's the query that was generated using query builder:

SELECT NON EMPTY { [Measures].[D2A3Y7ANS9YOF2FONXMUS9RAI] } ON COLUMNS, NON EMPTY {[0GL_ACCOUNT 1000IE].[LEVEL03].ALLMEMBERS * [ZF_MC].[LEVEL01].ALLMEMBERS } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [ZFGL_M03/ZREP_BOR001] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING SAP VARIABLES [ZFV_FY] INCLUDING [0FISCYEAR].[Z12007] [ZFV_PC] INCLUDING [0PROFIT_CTR 1000FS].[10000001000033] [ZFV_RM] INCLUDING [0FISCPER3].[005] [ZFV_PV] INCLUDING [0VERSION].[003]



I hope you would be able to assist.

Kind Regards
Utian Goliath

View 1 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 :: 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 :: 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 :: 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

SSRS Report Question To Calculate Overall Percentage For Individual Employee

Feb 22, 2008

Hi All,

I have an SSRS reports that uses a list table to display the name of staff and the name of the department that he supports as well as the number of hours they support the department. Below would be a sample of the report:

Name Department Hours
Staff 1 Dept 1 2
Staff 1 Dept 2 4
Staff 1 Dept 3 1
Staff 2 Dept 1 2
Staff 2 Dept 4 1

Now I would like to add 1 more column to show the percentage (%) of time spent at the department for the employee. Therefore each employee % of time spent will be 100% spread over all the supported departments. So the report will be as below:


Name Department Hours Time(%)
Staff 1 Dept 1 2 28.57
Staff 1 Dept 2 4 57.14
Staff 1 Dept 3 1 14.29
Staff 2 Dept 1 2 66.67
Staff 2 Dept 4 1 33.33

Is this possible to be created in SSRS as this is really required. If not is there any thing I can do on the DB or data set to show the time %.

Thanks & Regards,
Fadzli

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

Reporting Services :: Clause In SSRS Report

Jun 18, 2015

I have below query which is working fine in SQL but if i use same query in SSRS dataset then it is not working at all.If i put only one condition in where clause then it works but if i put multiple conditions then it does not works in SSRS and through error "data is not available".

SELECT id,
DATEDIFF(DAY, Created, BMTRequestReviewDate) AS 'EvaluateDays',

all code goes here

FROM [dbo].[SBWT_Data]
WHERE
upper(Status) not like '%XX%'
AND upper(Status) not like '%DELETED%'
upper(Status) not like '%CLOSED%'
---OR
WHERE Status NOT IN ('90 - Closed','XX - Rejected','XX - Request Rejected','XX - Deleted')

As you can see in code i have tried with both where conditions but it is not working. It seems that SSRS does not supports multiple conditions for same field.

View 5 Replies View Related

Reporting Services :: How To Fix No Of Rows Per Page In SSRS

Dec 10, 2008

I have 400 records in my report , i  want display 20 records per page , how can i do the same in ssrs.

View 18 Replies View Related

Reporting Services :: Totaling HHMMSS In SSRS

Sep 9, 2015

From the image above, I am totaling the column HHMMSS is SSRS with the below expression:

=CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(0)))+sum(CInt(split(Fields!HHMMSS.Value,":")(1)))60)
&":"& CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(1))) mod 60+sum(CInt(split(Fields!HHMMSS.Value,":")(2)))60)
&":"& CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(2))) mod 60)

I equally tried:

=iif(Fields!HHMMSS.Value = "", "", CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(0)))
+sum(CInt(split(Fields!HHMMSS.Value,":")(1)))60)
&":"& CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(1)))
mod 60+sum(CInt(split(Fields!HHMMSS.Value,":")(2)))60)
&":"& CStr(sum(CInt(split(Fields!HHMMSS.Value,":")(2))) mod 60))

and nothing works. What could be wrong with my expression?

View 7 Replies View Related







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