Reporting Services :: Dynamically Add / Remove Columns - SSRS 2012

May 16, 2015

I have SSRS report that has around 80+ columns. I have requirement where in dynamically hideshow columns in report based on user selection. I could able to do it by setting expression for "Visiblity" property and having report parameter thro' which columns to display can be choosen.

My problem is 2 points

1. fox example if columns 2 and 4 to be hidden, then there is an empty column between 1 and 3 and 5 columns. How to avoid this

2. When i export to PDF / Excel these spaces prevail.

View 3 Replies


ADVERTISEMENT

Reporting Services :: Unable To Pass Parameters Dynamically In SSRS 2012

Oct 1, 2015

I am creating simple report in ssrs and pass one parameter only. It will work perfectly (here user enter the parameter value). but i need that i should select the value in drop down box. i had tried many time and did different ways but I am unable to do it.

First i gave the parameter in my sql query in Data set (like WHERE COUNTRY = @COUNTRY) and i checked the Parameters tab in the data set. Here by default comes the Parameter Name: COUNTRY and Parameter value: [@COUNTRY].

Next i select COUNTRY Parameter in the Report Data Pane. and go to properties Here in General Tab: Name COUNTRY Prompt: COUNTRY, Select Get values from query in available values Tab (and also i tried with Select Get values from query in Default Value Tab) and Select Data set: Data Set1, Value field: COUNTRY and Label Field COUNTRY. And Click Ok

And tried to preview the report, it throwing below error

"An error Occured during local report processing.  The definition of the report is invalid. The Report Parameter 'COUNTRY' has a DefaultValue or a ValidValue that depends on the report parameter "COUNTRY". Forward dependencies are not valid.

How can I achieve dropdown list.What i missed? Even i unable to do it Multi valued parameters and Cascading parameters.

Actually i am working on SQL Express 2012 version.

View 5 Replies View Related

Integration Services :: SSIS Add / Remove Columns Dynamically Into Unpivot Object

Jul 9, 2015

I've created a SSIS package which takes a matrix from Excel file and insert into SQL table. It works perfectly! However, if I would add a new column into that matrix in Excel. Unpivot tool should take into process dynamically. Is there a way to provide this automatically? 

View 4 Replies View Related

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 :: How To Generate Column Name Dynamically In SSRS Report

Oct 5, 2015

I have to display three months name as column name in ssrs reports. These month column will be dynamically. So i have to display the column dynamically.

View 3 Replies View Related

Reporting Services :: Set Financial Year Value Dynamically In SSRS Report

Jun 28, 2015

I have a requirement to display the count of project data by their status (On Hold,  In Progress, Pre-concept and Closed) for the current FY and Last FY based on column 'Financial Year' and 'Project Status'. 

Financial Year column has a value in the following format (FY2011-12, FY2012-13, FY2013-14,FY2014-15, FY2015-16,FY2019-20 ,FY2020-21,FY2021-22)
 
I need to set the financial year value dynamically in above format for the last and current year (FY2013-14, FY2014-15) based on today's date and  Financial Year is from July to Jun. For example,

When today's  date is 28-06-2015 then it should set the current FY as FY2014-15 and Last Financial Year as FY2013-14When today's  date is 28-06-2021 then it should set current FY as FY2020-21 and Last Financial Year as FY2019-20

View 3 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 Report - Need To Remove A Default Literal

Nov 9, 2015

I am working on SSRS report deployed on the sharepoint.

By default, it is displaying " Microsoft SQL Server Reporting Services " on the report

How can that be removed?

Secondly as I don't have the requirement to default the report parameters so I am getting

"Specify parameter values ............... button "

Any way to replace it with some other text etc...

View 2 Replies View Related

Reporting Services :: How To Adjust Column Length Dynamically In SSRS Report

Nov 11, 2015

I developed a SSRS report, the problem is i dont have data in DEV server. So i dont know how to adjust the column lengths in ssrs report. is there any property so that the column length can be adjusted dynamically based on the data length whenever data is available in production.

View 3 Replies View Related

Reporting Services :: Remove Username And Password When Start  SSRS Website

Aug 18, 2015

I need to remove username and password when start  SSRS website.

View 4 Replies View Related

Reporting Services :: How To Arrange Dynamically Column Based On Parameter In SSRS 2008 R2

Apr 19, 2013

i have below table in DB

DB Table
ID
Column
Row data
1
Supplier CODE
1001
2
Supplier Name
ACB
3
Product
7K7
4
Price
1000

now I create  one report parameter order1 IF I will   give order1.value=1,2,3 then Report will come like this :--

Suppliercode

Supplier Name

Product

1001

ACB

7K7

IF I will   give order1.value=3,2,1 then Report will come like this :--

Product

Supplier Name

Suppliercode

7K7

ACB

1001

IF I will   give order1.value=1,3 then Report will come like this :--

Suppliercode

Product

1001

7K7

View 35 Replies View Related

Reporting Services :: 2012 SSRS Reporting Configuration (SCCM 2012)

May 26, 2015

We have SCCM 2012 primary site and Remote SQL 2012 server. Due to hardening and password reset we are facing reporting issue.

while we Open the SRS report in SQL server and try to edit the Report (Report Builder) we are getting following error due to which we are unable to configure Reporting Service point in the SCCM 2012 server. We created the New Reporting server database still we are getting the below error.

View 14 Replies View Related

Reporting Services :: Increase Range Bar Chart Size Dynamically Inside A Table In SSRS

Oct 21, 2015

 I have a range bar chart Inside a table of row group and the chart is repeatedly generate according to category ,i want to increase chart height dynamically based on category.

suppose for if category =A THEN CHART HEIGHT=10CM
category =B THEN CHART HEIGHT=7CM

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 :: Dynamic Columns In SSRS

Apr 22, 2015

I am using sql 2012 SSRS.

My requirement  : I have Database which has got 100 tables.I need to create SSRS report which display top 10 records from the table within that database.

User will select The table name as parameter in the report. the number of column in each table will vary .

I am using the below statement in stored proc, and calling same from ssrs report

exec(
'select top 10 * from ['+@datbasename+'] .[app].'+@tablename+'')

View 6 Replies View Related

Reporting Services :: Show / Hide Multiple Columns In SSRS

Nov 3, 2015

I have a parameter "time frame" which contains two value- 6 months ,12 months an 18 months which shows data of 6 months , 12 months and 18 months.

In my ssrs report i have 18 columns :

jan|feb|mar|apr|may|jun|july|aug|sep|oct|nov|dec|jan|feb|mar|apr|my|jun

The first six months will be displayed in each case.

But when i choose 6 months i just want to display first six months only.when i choose 12 months  i want to be displayed first 12 months columns only and for 18 months all the columns,.

View 8 Replies View Related

Reporting Services :: SSL Redirect For SSRS 2012?

Jun 4, 2015

how to implement a redirect in SSRS? If a user goes to [URL] I want it to redirect to [URL]

View 3 Replies View Related

Reporting Services :: SSRS - Display Dataset Fixed Row As Report Columns

Jun 18, 2015

We are planning to develop weekly report in SSRS.For this we wants each day as column & some expenses[Numeric figure in row]we have dataset like 

day 
exp1
exp2
exp3
17/05/2015
120
150
650

[code]....

There are some other filters are there that i have applied in my report tablix property.

View 2 Replies View Related

Reporting Services :: SSRS - How To Hide Columns Based On Drill Down Level

Sep 10, 2015

I thought the built in expression Level() would show me be drill down level. I can't see to get that to work. I'd like to determine my drill down level so I can hide columns based on that.

View 2 Replies View Related

Reporting Services :: Develop SSRS Report Based On Grouping Of Certain Columns

Sep 1, 2015

I want to develop a ssrs report which is grouped by month?

View 4 Replies View Related

Reporting Services :: How To Limit Columns Per Page In SSRS Matrix Report

Oct 7, 2015

I have created the matrix report which has dynamic column, it grow columns(18) based on the 'MCU' field in PRD.MI table. I have added the 'MCU'(A,B,C,D,E,F,G,H,...Q) on 'Columns' in matrix table, to create matrix report and I have added 'mcst' on 'Data' in matrix table and I have added the 'msp2' on 'Rows' in matrix table. I have created new column after row and I added USP2DS.Final output is as given below.I need the split the matrix column per page.

I have added the 'MCU' on "Column group and 'msp2' on Row group.

Query:
select mi.*, SUBSTR(SM.USP2DS,6,9)AS DESC from 
(SELECT a.mcu , a.msp2, SUM(a.mcst) AS Cost    
FROM PRD.MI as A                                    
WHERE a.myr=2015 and a.mpr=7                   
GROUP BY a.MCU, a.msp2                             
order by a.mcu, a.msp2 ) mi,                     
(SELECT  DISTINCT U_SP2, USP2DS FROM UM.SM) SM
WHERE A.MSP2=SM.USP2  
ORDER BY MCU,msp2

I have tried the below post, but I am not able achieve my output. [URL] ....

View 6 Replies View Related

Reporting Services :: SSRS 2012 Setup Parameter Value

Apr 22, 2015

In an existing ssrs 2012 report, I want to basically add the following logic to a new dataset that will be used by a new parameter called 'Inventory'.

SELECT  DISTINCT Inv_number as value,  Inv_name as label
FROM s.dbo.fnUser( @endYear, 0, 0, 0)
WHERE (@report is not null)
order by  label,value

In this ssrs report, there are 15 reports that can automatically be generated. I basically want this new parameter called 'Inventory' to only be active when the 4th report is selected to be generated. Thus in the query I listed above, how can I change the query to only be active when the 4th report is selected?

I tried to change the where clause to (@report(4) is not null), but that did not work.

View 5 Replies View Related

Reporting Services :: User Folder In SSRS 2012

Jul 13, 2015

There's a new SSRS 2012 environment which was setup with My Reports folder to each user enabled. I know I'm supposed to see a Users Folder in the Report Manager root, I'm setup as a system administrator (under Site Settings) and also have content manager rights in the root directory and I still don't see the "Users Folders" ...the only way I can see that is if they give me admin rights in the server SSRS is installed. What am I missing here, is this supposed to be like that?

View 5 Replies View Related

Reporting Services :: Exporting Fixed Columns From SSRS For Use In Mainframe Data File

Jun 3, 2015

I need to be able to export a data file as flat file (.txt) with fixed columns for use by Mainframe.

I will be uploaded this file using the Windows File Share Option

Render Format does not have .txt, but does have a data feed option. So I will try that.

But, I do not see an option for fixed column width.

View 7 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 :: SSRS 2012 Report For Non Domain Users

Nov 6, 2015

I created a SSRS Reports in SQL Server 2012 and deployed in server, I want this report to be accessed by one particular User created in that hosted server and any time if user hits the Report URL it asked for login Prompt.Suppose if I create a Windows User "ReportUser" in report server , I want when user hits the URL he should be able to access the report by providing the 'ReportUser" credentials.

View 7 Replies View Related

Reporting Services :: SSRS 2012 / Put A Title For A Radial Gauge?

Nov 26, 2013

I need to put a title for a radial gauge. I've tried to add a label, but it remains in the panel area.

Is it possible to add a title by using a gauge property without creating a text box outside this object?

View 7 Replies View Related

Reporting Services :: Merging Of Two Cells Vertically In SSRS 2012

Oct 5, 2015

I am new in SSRS 2012.I have created a rdl,in this rdl, am having a row group.In this report, other two columns has multiple rows and some rows having data and some other rows doesn't have data.So I want to create rows when the row of that particular column has any data or need to merge vertically with the  row having data and row don't have data of particular column along with the Common Row Group Data

View 5 Replies View Related

Reporting Services :: Cannot Re-add Deleted Header Row To Tablix In SSRS 2012?

Apr 26, 2012

I am using SSRS 2012 RC0 in Visual Studio 2010 sp1 to build this tabular report. I had inadvertently removed the initial header row from my tablix before adding numerous nested groupings to move the column headers to the header section so they would show up on each page.

I would like to reverse that decision, but I seem to be unable to now re-add that header row back to my tablix. In older versions of SSRS, I was able to right click on the table and then click on insert row-->Header row but that does not seem to be possible in ssrs 2012.. I tried adding a outer row to my top most grouping, but that option was grayed out.

How I can add my header row back to my table.

View 7 Replies View Related

Reporting Services :: Powershell Script To Configure SSRS 2012?

Jun 12, 2015

We have 15-20 report server environments including Dev/SIT/UAT/PROD/DR etc. so instead of configuring it on each servers, we would like a script to use with parameters.

After installing the SSRS 2012 package on each server with given instance and service account, I would like to configure the SSRS through script instead on running the Configuration manager RSConfigTool.exe manually.

we already have created the database beforehand using the scripts provided by WMI. do we need db_owner permission on msdb and master database to configure SSRS?

View 2 Replies View Related

Reporting Services :: Can't See Drop Down List For A Report On SSRS 2012

Oct 20, 2015

Here's my setup:

1) SSRS in native mode
2) 2012
3) I have "Browser, Content Manager, My Reports, Publisher, Report Builder" permissions on the folder that has the report

I can't see the drop down list associated with the report that's hosted inside the folder. Here's what I mean by drop down list -- the one that lists things like: properties, subscribe, etc. In other words If i click on that dropdown arrow, I don't see the list.

View 2 Replies View Related

Reporting Services :: Ssrs 2012 Change Parameter Values

Apr 22, 2015

In an existing SSRS 2012 report, I have a requirement for a user to be able to select by multiple school(s) and/or multiple grade(s). This is fine except certain schools like elementary have grade levels of KG to 06, Middle school has grades of 06 to 09 and high school has grades of 10 to 12. Thus for example, if a user has initially selected grades 11 and 12 and then they select an elementary school that has grades KG through 06, the 'grade level' selection would need to change.In other words,  I am thinking of initially having the available and default values for the parameter called 'Grade' set to KG through 12. However if a school is selected that only has specific grade levels like elementary school, how can I override the original grade level and only allow the user to select grades that the particular school contains?

View 3 Replies View Related

Reporting Services :: Can Change Encoding From UTF8 To SJIS In SSRS 2012?

Jul 14, 2015

How to change encoding in SSRS from UTF8 to SJIS for export to CSV. Is it possible or not.

View 3 Replies View Related







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