Showing posts with label picker. Show all posts
Showing posts with label picker. Show all posts

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
>

Friday, February 24, 2012

Calendar Control in Reporting Services 2000

Hi All

Is it possible to add datetime picker (Calendar Control)

in 2000 reporting services

Cheers

The calendar control came out with Reporting Services 2005. It can't be used in 2000 as far as I know.|||I can second that.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Calendar Control in Reporting Services 2000

Hi All

Is it possible to add datetime picker (Calendar Control)

in 2000 reporting services

Cheers

The calendar control came out with Reporting Services 2005. It can't be used in 2000 as far as I know.|||I can second that.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de