hi everyone

i am trying to add date parameters for a start/end day (like most reports.. but how do those have calenders and mine dont?) anyways thats another question.. when i tryed to upload my report i got this error..

• An error has occurred during report processing. (rsProcessingAborted)
  • Query execution failed for data set 'MicrosoftVSTSSchedulingFinishDateDate'. (rsErrorExecutingCommand)
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

how do i fix this? and how can i get the little calendar to show up for my date parameter?

Thanks

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.

i would get the error after i uploaded the rdl file and went to see if it worked or not.. and yes i made a report server project

and for the calendar thing. no my parameter is schedulestartdate or something like that (also got schedulefinishdate). i went through every option for dates in the query builder and no luck to find something with the calendar and would show the dates that actually have a bug or whatever i was searching for

edit: i also removed that report now im just interested about the calendar thing

Thanks

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).

this looks like its all very helpfull information but i dont know what program you are using. Im using SQL Server Business Intelligence Development Studio to build my reports. (was told thats the best and easiest way  to make reports)

Thanks

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.

ok, i tryed to do your steps but i am no longer connected to my tfs warehouse when my 'type' is Microsoft SQL analysis services so i just went to Microsoft sql server type instead.. it looks totally different from the analysis mode, am i still able to do what you described from here?

Thanks

ps, is there a way to get my tfs warehouse back(or to show) when creating a new report.. since monday it just disapeared

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.

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

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.. it was there last week but it just disappeared :\

"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.

Nick,

Your explanation was very helpfull for my first attempt at a calendar feature as well. I did get lost at one point:

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

I keep generating an error at this part. Obviously my lack of familiarity is the problem. Could you type out the actual SQL Query for creating this Parameter (instead of the requirements that any intelligent person would easily understand).

This is in fact my first attempt at SQL, using Microsoft Visual Studio w/SQL 2005 on an XP-Pro system.

The calendar feature appears in preview, but won't link to the rest of my query, which is just this:

select * from InputData

where tagname like 'F%'

Thanks again for taking the time to post.