Saturday, February 25, 2012

Calendar picker?

Hi there
I am trying to set up some sort of date picker for my reports in Reporting
Services and found an article which basically uses an asp.net calendar
control as a plug-in to the report (see link below).
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6e8cee511769b6c/1ddce2c2c6523fc0?q=&_done=/groups?enc_author=uFKGehIAAAAdZvNtw6tRAoeBJxgAOEvh8rhlH0Pnl47z4AZhN98BFg&&_doneTitle=Back%20to%20Search&d=&
Unfortunately I am not very experienced in programming, so i don't fully
understand how you would integrate the asp page with the report.
My reports are based on an Analysis Services cube time dimension. i have an
MDX statement in the Data query window in .NET which populates a Matrix
table. The query looks like this:
SELECT { Measures.members } on Columns ,
NON EMPTY {{[Business].[User].[Business Entity Id].[891].Children}
* {[Time].[2004].[Quarter 1].[1].[January]:[Time].[2005].[Quarter
1].[1].[January]}} on Rows
FROM UsageStats_Phase1
I then deploy the report to the Reporting Server manually. How would I
integrate an asp calendar control into this set up? Any help would be most
appreciated!!!
Thanks and regardsRight now, there's not a good way to customize the parameter input process
other than programming. The hyperlink you posted is a very good starting
point.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Neile" <Neile@.discussions.microsoft.com> wrote in message
news:BE9EB249-A29F-47A2-9D17-18632D47A1E6@.microsoft.com...
> Hi there
> I am trying to set up some sort of date picker for my reports in Reporting
> Services and found an article which basically uses an asp.net calendar
> control as a plug-in to the report (see link below).
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/6e8cee511769b6c/1ddce2c2c6523fc0?q=&_done=/groups?enc_author=uFKGehIAAAAdZvNtw6tRAoeBJxgAOEvh8rhlH0Pnl47z4AZhN98BFg&&_doneTitle=Back%20to%20Search&d=&
> Unfortunately I am not very experienced in programming, so i don't fully
> understand how you would integrate the asp page with the report.
> My reports are based on an Analysis Services cube time dimension. i have
> an
> MDX statement in the Data query window in .NET which populates a Matrix
> table. The query looks like this:
> SELECT { Measures.members } on Columns ,
> NON EMPTY {{[Business].[User].[Business Entity Id].[891].Children}
> * {[Time].[2004].[Quarter 1].[1].[January]:[Time].[2005].[Quarter
> 1].[1].[January]}} on Rows
> FROM UsageStats_Phase1
> I then deploy the report to the Reporting Server manually. How would I
> integrate an asp calendar control into this set up? Any help would be most
> appreciated!!!
> Thanks and regards
>

No comments:

Post a Comment