Calendar picker?

Last Post 10 Mar 2005 06:19 AM by xfonhe. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Maria123
New Member
New Member

--
15 Feb 2005 01:16 AM
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...earch&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
Maria

timmcowan
New Member
New Member

--
03 Mar 2005 11:15 PM
Hi there,

In simple terms, you can embed a report into an asp.net page quite simply using the reportviewer component written by microsoft. I'm sure someone will correct me if I'm wrong but afaik, it's a server control that you just drag and drop onto your webform. Once it's there, you can put any number of other controls on the page (date picker, etc) and a submit button and then collect the parameters from the controls on the page and send them via URL access to the report that you want to view.

Here's a blog about it
xfonhe
New Member
New Member

--
10 Mar 2005 06:19 AM
Tim is correct: you will have to deploy your report via a custom page/app, rather than ReportManager. Hopefully they'll include a calendar control in the next SP. Another option is to use multiple parameters - one for year, quarter, month, and day, then apply filters to your data regions (since you're using OLAP/MDX and cannot embed parameters into the data set).
You are not authorized to post a reply.

Acceptable Use Policy