No announcements
Found 1976646 threads
-
0 VotesDynamic Columns Based on Parameters
c.name FROM sys.columns c INNER JOIN sys.tables t ON c.object_id = t.object_id AND t.name = 'myTableName' Now, create a parameter called ...Answered | 2 Replies | 1345 Views | Created by GKFey88 - Friday, August 21, 2015 12:26 PM | Last reply by Patrick Hurst - Friday, August 21, 2015 3:45 PM
-
0 Votes
Dynamic columns(Columns are increase or decrease based on parameter of procedure)
Hi Ramesh, Based on my understanding, you want to display dynamic columns in a report which could be increased or decreased based ...Answered | 1 Replies | 528 Views | Created by Ramesh Rathod - Wednesday, July 1, 2015 7:56 AM | Last reply by Qiuyun Yu - Thursday, July 2, 2015 7:03 AM -
0 Votes
Need dynamic t-sql with group by based on tablename and column names
be executed when a @TableName and @ColNames are passed as input parameters and based on input values it should return the following output scenarios.The values to the ...Answered | 1 Replies | 633 Views | Created by sql9 - Wednesday, September 2, 2020 2:10 AM | Last reply by Dave Patrick - Wednesday, September 2, 2020 2:54 AM -
0 Votes
Visual Studio 2005 - Report Template - Issues with Stored Procedures
Hi All, I have a stored procedure which returns 10 static columns and 5 to 10 dynamic columns which is based on the ...Answered | 2 Replies | 3676 Views | Created by OswalSapna - Friday, February 27, 2009 11:47 AM | Last reply by Paul Turley - Monday, March 9, 2009 6:41 AM -
0 Votes
Reporting Services Column Title
dataset with many columns most of which are pulled into a table in the report, so each column in the table is a field column in the dataset. I identify columns ...Answered | 1 Replies | 2666 Views | Created by Antonia Berry - Thursday, August 11, 2011 9:34 AM | Last reply by Zilong Lu - Saturday, August 13, 2011 5:14 AM -
0 Votes
Using a custom column from one list to filter another list in web parts
allow custom columns as dynamic parameters using the curly brackets {} in the URL. ProjectID and ProjectLookup are different formats and contain different ...Answered | 4 Replies | 539 Views | Created by Mary Theis - Tuesday, November 3, 2015 8:11 PM | Last reply by Linda ZL - Thursday, November 5, 2015 1:34 AM -
0 Votes
dynamic row generation using parameters??
have 3 parameters : StartAmount EndAmount and IntervalAmount. Based on this 3 amount my measures should come. e.g. StartAMount = 1000 End Amount = ...Answered | 3 Replies | 2684 Views | Created by Chaitali Prabhu - Sunday, October 23, 2011 9:54 AM | Last reply by Rob Kerr - Ann Arbor - Monday, October 24, 2011 1:32 AM -
1 Votes
Dynamic Fields based on Parameters?
One option that may help solve your requirements is to the ability of RDL expressions to dynamically determine the field name. For example: ...Answered | 1 Replies | 3930 Views | Created by Cedartie - Thursday, October 23, 2008 3:02 PM | Last reply by Robert Bruckner - Thursday, October 23, 2008 4:42 PM -
1 Votes
Dynamic Columns based on the Data Set
Sure thing. You can hide/visibility columns based on sproc result. based on sproc result it will unhide or hide the ...Answered | 2 Replies | 654 Views | Created by Priya Bange - Wednesday, April 30, 2014 3:16 PM | Last reply by Murali dhar - Wednesday, April 30, 2014 3:28 PM -
0 Votes
Dynamic or Expression-based Report Page Properties
of the report body, either the pagesize property and/or the interactivesize property, can be manipulated at run time? This way if a user, based on their ...Answered | 1 Replies | 4407 Views | Created by RptRep - Tuesday, September 7, 2010 7:56 PM | Last reply by Mohamed Irshad - Wednesday, September 8, 2010 3:25 AM -
0 Votes
other than linked server... what are the options
This is an end user app... actually a website. We have a stored procedure in the data engine that builds up MDX based on the parameters passed which ...Answered | 4 Replies | 4531 Views | Created by William Lowers - Monday, October 13, 2008 6:40 PM | Last reply by William Lowers - Tuesday, October 14, 2008 5:34 PM -
0 Votes
Displaying Dynamic Columns based on select columns from dropdownlist
How can display dynamic columns based on select columns from dropdownlist like belowAnswered | 1 Replies | 1223 Views | Created by Ramakant Singh - Friday, December 5, 2014 3:04 PM | Last reply by SathyanarrayananS - Saturday, December 6, 2014 7:05 AM -
0 Votes
Dynamic sorting based on the parameters selected
Hi All, I need to sort my fields in a table report of the detail section based on the parameter that is slected. Say I have a parameter called ...Answered | 2 Replies | 3787 Views | Created by Ramakrishnan.lh - Tuesday, August 17, 2010 6:20 PM | Last reply by Challen Fu - Wednesday, August 25, 2010 3:25 AM -
2 Votes
How To Create Dynamic Insert Store Proc
possibility that some of the columns needs default/constant value to be inserted based on conditions You may need to query system tables for identifying the number ...Answered | 4 Replies | 4415 Views | Created by Sumanfbc - Monday, September 20, 2010 10:34 AM | Last reply by SunilJena - Monday, September 20, 2010 2:51 PM -
0 Votes
Generating Reports using SQL Reporting depending on dynamic column
Sandeep.Handa From your scenario, you would like to create a dynamic report which is generate based on twoAnswered | 4 Replies | 5262 Views | Created by Sandeep.Handa - Wednesday, April 6, 2011 8:23 AM | Last reply by Pritam_Shetty - Monday, April 11, 2011 11:17 AM -
1 Votes
Conditional Formatting based on Dynamic Columns
Hello I would like to setup a conditional formatting rule for column in my tables based on the other columns in the tables but the columns are ...Answered | 2 Replies | 1146 Views | Created by Pamela84 - Thursday, November 7, 2013 5:29 PM | Last reply by Pamela84 - Friday, November 8, 2013 3:12 PM -
0 Votes
Slow dynamic parameters based on Cube SSRS 2005
].[Region].[All]' AS ParameterValue ORDER BY Region I am looking at solutions where I can remove the dynamic behaviour of cube based parameters ...Answered | 15 Replies | 4775 Views | Created by SQL-BI-MCTS - Monday, September 14, 2009 5:08 PM | Last reply by SQL-BI-MCTS - Friday, October 2, 2009 8:10 PM -
1 Votes
MDX Dynamic Code on execute
COLUMNS, " & "[Date].[Activation Date].&[20120101] ON ROWS " & "FROM [Adventure ...Answered | 3 Replies | 1371 Views | Created by Carlo L - Tuesday, May 14, 2013 12:31 PM | Last reply by Carlo L - Tuesday, May 14, 2013 3:34 PM -
1 Votes
Dynamic columns based on resultset from stored procedure
have eight scenarios like above which give different result sets. The Report in the final should have 2 tables one that col1,col2,col3 data and other table has dynamic columns ...Answered | 2 Replies | 12647 Views | Created by Satch24 - Thursday, April 5, 2012 8:06 PM | Last reply by Lola Wang - Monday, April 9, 2012 3:10 AM -
0 Votes
Adding dynamic dummy columns based on value stored in table
I want to create four dummy columns in a table based on three conditions, if 1st condition is satisfied, then 1st dynamic column must store '1', then if 2nd ...Answered | 5 Replies | 4956 Views | Created by Abdul Muqeet Ahmed - Sunday, November 27, 2011 3:07 AM | Last reply by Erland Sommarskog - Sunday, November 27, 2011 1:07 PM - Items 1 to 20 of 1976646 Next ›
No announcements
