I wrote a dynamic SQL. How to run it in the SSRS?
View Complete Post
well how can i generate a Table of content dynamically or TOC as a link so that while clicking in the TOC section it goes to the same page in pdf report output.
so can any one help me how to make TOC in .rdl design in SSRS ...plz help me out soon.
I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some
of the field name have look up values that values should be displayed as dropdown when we export to excel.
Can any one have any idea how to proceed with this report?
dynamic layout or zone for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.
I am using SSRS 2008. I am trying to use the Dynamic width and Dynamic height property of SSRS 2008. My SSRS chart has to display around 100 items on the x-axis. I am using the following formula depending on a report parameter
=(Parameters!ReportParameter1.Value) & " in" to derive the width of the chart. The chart width is not modified but I can see the the expression returning an valid value (ex: 10 in) and also the scroll bar size also changes but the
chart's width(x-axis) is not increasing. Its still the old width.
Any help is highly appreciated.
I have problem with my work now. i have SSAS and SSRS created on SQL BIDS. I want to integrated SSRS with Dynamic AX 2009. All of the SSRS report must be called from Dynamic AX 2009 menu items.
Can everyone guide me how to solve this problem? what the first step must doing?
Thanks for your helping..
I'm running SSRS 2008, and I'm wondering if it is possible to change a report parameter property based on user input in another report parameter. What I need to do is to make report parameter #2 a required parameter if a specific value is selected
in parameter #1. Parameter #2 should be optional under all other scenario.
Thanks in advance.
I am tring to pass comma split multi values in for a paramater in to ssrs. The Sproc that is points to uses dynamic sql and the paramater is nested in a an oracle query
in visual studio I have multi values selected but it does not seem to work.. below is the stored procedure
alter PROCEDURE dbo.[USP_SALES_LAUNCH_XX]
, @TIMEFRAME CHAR(30)
--SET @EM_ITEM_NUM = '1100015'
--SET @TIMEFRAME = '18 Months'
declare @sqlQuery VARCHAR(8000)
declare @finalQuery VARCHAR(8000)
SET @sqlQuery = 'select
sum(oss.SLS_QTY) as QTY
,sum(oss.SLS_AMT) as AMT
,TO_CHAR(oss.INVC_DT, ''''MON, YYYY'''') AS MYDATE
I'm using SSRS 2008 R2. I have a tablix in which one of the column has textbox grows dynamically based on the dynamic content and the other column is an image control. In the image control, i have a very small image and I want this to be centered in that
cell. It always renders at the top left corner. Since the tablix row grows dynamically, I couldn't set the Top padding.
Any help would be appreciated.
I am attempting to build a report that allows the user to select the value of 4 different parameters. The final parameter allows the user to select multiple values. My question is as follows. Based on the users selections, is there a way to generate the
required number of tables dynamically?
For instance, if the input for the final parameter is A, B, & C can the appriopriate number of tables be generated for the same dataset (Sales) without having to build a table for SalesA, SalesB, and SalesC? Or do I have to build the maximum number of
tables and use an expression to determine visibility based on the parameters. Note: max number of possible tables is more than 100.
I need to give my report viewers the option to filter if they like. the filtering criteria is also to be selected by the user. The report is about all products sold at all branches by all employees. therefore I have the 2 following user selected parameters:
when 'Branch' then Sales.branchID
when 'Product' then Sales.ProductID
when 'Employee' then Sales.EMPID
when 'all' then 'all'
end as 'filtervalue'
order by filtervalue
=IIF(Parameters!filterby.Value like "all", Parameters!filtervalue.Value, fields(Parameters!filterby.Value).Value)=Parameters!filtervalue.Value
I had to use the IIF statment to implement the conditional filtering. (e.g. I do not want the report filtered by anything if the user selects "all" for parameter "Filterby" )...now my report works for any filtering criteria selected
other than "All". I get the error: Failed to evaluate the filterExpression when I select "all".
This is driving me nuts!