schedulingfinishdate error + how to add calendar to date parameter?

Hi Kardi,

A few questions:

Is your parameter (from Layout tab, Menu item Report -> Report Parameters) of type "DateTime"?

Does this error appear when you deploy your report or when you view your report? After you see this error is your report deployed?

Are you using VS project type "Report Server Project" to develop your reports?

Are your data sources for the report deployed? You can reuse the out-of-box data sources in your custom report. To do this create data sources with the same name, properties, and deploy location as the out-of-box DSs and set OverwriteDataSources to false.

On the Data tab (for a Report Server Project) can you execute the query for the data set MicrosoftVSTSSchedulingFinishDateDate?

If this error appears when you are viewing your report you could try to get a more detailed error message by executing the report from the Report Server. Browse to the report from http://localhost/reports. Also check the eventvwr on the Report Server for errors.

NickEricson-MSFT at 2007-10-8 >

I am not a Reporting Services pro - so there may be an easier way of doing this. Anyway:

I believe you are using a query parameter. The date control will appear when you have a report parameter.

Report Parameters:
Accessed from the Data or Layout tab. Click the Report -> Report Parameters.
On the Report Parameters dialog add a new Parameters by clicking "Add"
Set its Data Type: to DateTime
Save
Go to Preview - you should see the date control at the top of the page.

Query parameters
From the Data tab click the button that looks like a report with an @ symbol over it (next to refresh). These are used in the queries.

So the next question is "So how do I get my Report Parameter into a report?"

The Date Report Parameter will return a datetime - in the query you would like a string like [Date].[...].[<Some Date>]. One way to do this is to create a second Report Parameter where you will do the conversion (you could convert it elsewhere if that is more convenient). The steps from to convert in a second Report Parameter are:

Create a DateTime Report Parameter is called DateReportParam.
From the Layout tab click Report -> Report Parameters
Add the DateReportParam of type DateTime. Set default value to, say, =Today()

Create a second Report Parameter called DateReportParamStr.
On the Report Parameters dialog add this new param.
Data Type: String
Internal checked
Default Value: Non-queried, Value: ="[Date].[Date].&[" + CDate(Parameters!DateReportParam.Value).ToString("s") + "]"

Now in the query where you want to include the parameter create a Query Parameter
On the Data tab select the Dataset you would like to include the parameter in
Click the button that looks like a report with an @ sign over it (between refresh and delete directly above the query)
Add a Parameter called DateQueryParam
Dimension: Date
Hierarchy: Date.Date
Default: <Select any value> (this doesn't matter - it is used when executing the query in the editor)
OK

Map the Query parameter to the Report parameter
On the Data tab click the "..." button directly next to the dropdown containing the Datasets.
On the Parameters tab Find the parameter Named: DateQueryParam
For its Value select =Parameters!DateReportParamStr.Value

Now you should be able to use the parameter in your query as @DateQueryParam and its value will come from the Date control (called DateReportParam).

NickEricson-MSFT at 2007-10-8 >

The example is for SQL Server Business Intelligence Development Studio - a "Report Server Project" project.

When you open the report (RDL) to edit it (by double clicking it in the Solution Explorer) you should see three tabs in the editor region - "Data", "Layout", and "Preview". These are the tabs I refer to.

NickEricson-MSFT at 2007-10-8 >

I am not sure what you mean by not being connected to tfs warehouse. Are your out-of-box reports working?

Here are the steps to create a new report that, when deployed, will use the built-in data sources. These data sources are "connected" to the reporting warehouse and cube (one to each).

Open Visual Studio Editor:
Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Business Intelligence Development Studio
** This also may be under Microsoft Visual Studio 2005 if you have that installed.

Create a new project:
File -> New -> Project
On "New Project" dialog
Select "Business Intelligence Projects" under Project types.
Select "Report Server Project" under Templates.
Enter Name, Locations, Solution Name, ...
OK

Create the data sources:
In the Solution Explorer pane:
Right click on "Shared Data Sources" -> "Add New Data Source"
On the "Shared Data Source" dialog
On the General Tab:
Name: TfsOlapReportDS
Type: "Microsoft SQL Server Analysis Services"
Next to Connection String text region click "Edit..."
On the "Connection Prpperties" dialog:
Server name: <Report Server Name>
Click the Down arrow under "Connect to a database" - this can take a little bit to populate, wait until the dropdown appears
Select "TFSWarehouse"
Click "Test Connection"
This pops up a dialog indicating the connection is good.
OK
OK

Repeat these steps to create the TfsReportDS (Microsoft SQL Server) data source. Select the TFSWarehouse for the database as well (they have the same name).

Edit the deployment properties for the project
In the Solution Explorer pane:
Right click the project (above Shared Data Sources) and select Properties
On the <Project Name> Property Pages dialog:
In the left pane select Configuration Properties -> General
In the right pane, under Deployment set:
OverwriteDataSources: False
TargetDataSourceFolder: /
TargetReportFolder: /<TFS Project Name>/
** This is not your Report Project - this is the name of the TFS project this report is for.
TargetServerURL: http://<Report Server Name>/ReportServer
OK

Add a Report:
In the Solution Explorer pane:
Right click on "Reports" -> Add -> New Item
On the "Add New Item - <Project Name>" dialog
Select "Report Project" in the Categories pane and "Report" in the Templates pane.
Enter a name for the report
Add

Now you will need to configure the Datasets, build the queries, and design the layout for the report.

NickEricson-MSFT at 2007-10-8 >

"when you are editing your connection process. i'd plug in my server and when i go to my database its not there any more.. "

Are you referring to the "Create the data sources:" step above? After entering the Server Name & you click the down arrow under "Connect to a database" the dropdown that appears does not include TFSWarehouse. Is this correct?

Is your cube up and running? You could view an out-of-box report to see if data comes back from the cube.

You could also use Sql Server Management Studio to view the cube.

NickEricson-MSFT at 2007-10-8 >