The ReportViewer control has a ShowParameterPrompts property that can be set to False if you do not want to show the parameter prompts in your custom app. There is also a ShowToolBar property which you could use to hide the rest of the toolbar, so that all the user sees is the actual report.
If you need to leave some parameters visible and hide others, I am not sure, someone else will have to answer that.
Good luck,
Dave
I have a user how wants to be able to see the YTD numbers based on the month they select in an attribute hierarchy with in the Time Dimension.
I would like to create a calculated member called YTD that they can use to get this information based on the Month they select in the Month attribute
The Time Dimensions are as follows: Fiscal time(Year, Qtr, Month) Month(Month)
Measure = Net Sales
View Format should be
Years
2000 2001 2002 2003 2004 2005
Customer $ $ $ $ $ $
YTD should work if the user drills down to Qtr or Month, if they selected a member in the Month attribute or not.
The Time dimension is only loaded with the years that are in the cube so if the user selects Dec but no data is in the cube for Dec 2005. 2005 should still show up on the report.
One of the issues I have run into is determining if the user is looking(selected) something from the Fiscal Hierarchy of from the Month Attirbute. If I use [Time].[Month].currentmember.name I get the name of the month the user selected in Month Attribute but if the user selects "All" months in the Month attribute but selects the Months from the Fiscal hierarchy I still get the month name and not the value "All".
Please Help.
Here is an example of a calculated member that I added to the "AdventureWorks" cube that will return the "Calendar" YTD internet sales amount based on what has been selected as the current member of the Date.Calendar hierarchy. The MDX will also work in AS2K.
Create Member CurrentCube.[Measures].[CYTD Internet Sales Amount]
AS
Aggregate(
PeriodsToDate(
[Date].[Calendar].[Calendar Year],
[Date].[Calendar].CurrentMember),
Measures.[Internet Sales Amount]),
Format_String = "Currency",
Non_Empty_Behavior = { Measures.[Internet Sales Amount] };
HTH,
- Steve
I have a requirement of having to change the Sql View depending on the user selection criteria.
Is it possible?
No but you can create a stored procedure with dynamic sql kludge
If you would change the view (with an alter view statement) what would happen when 2 users would hit the view at the same time (problem)
sp with dynamic sql is your best bet (probably including a temp table, I don't know your requirements so that's tough to answer)
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||Thanks.I cannot use stored procedure, any other option to programattically alter the view?|||What is your requirement that means that you have to "dynamically change the view"?|||
Krutika wrote:
Thanks. I cannot use stored procedure, any other option to programattically alter the view?
No. Well, you can use CASE statements in your view if that helps.|||No, A "view" is always the same list of fields.
Also, if you create a view which says:
CREATE VIEW V_TABLEA AS
SELECT * FROM TABLEA
When you create the view, it caches the list of fields it is going to display. This means if you add or delete a field from TABLEA, these changes will not show in the view. You need to recreate or alter the view to get a new field list.
Your only option is a stored procedure.
