SQL Server Performance

Calendar picker?

Discussion in 'SQL Server Reporting Services' started by marialua, Feb 15, 2005.

  1. marialua New Member

    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...l47z4AZhN98BFg&&_doneTitle=Back to Search&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

Share This Page