HI,

Reporting Newbie...

I wanted to do what i thought was a simple thing...just add an extra field to an existing report...

I setup a new Reporting Project, added the Datasources and downloaded the Builds.RDL file from the Report configuration page.

I then added a field:

<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Build].[Build_Type].[Build_Type]" />

called Build_Type.

I added a column to the designer & assigned the above field.

When I upload and run the report through the Reporting Services Web page, I get an empty value for that field.

At design time, I don't get any data back at all when previewing the report.

If I look at the Data Tab, I can see the data is there.

Any ideas?

Am I at least going down the right track?

Thanks

Hmmm...No responses yet...

Buck (or anyone...), would it be possible to get an updated .RDL file with that extra field included in the report?

Reason is that I've changed the Build Number to be just the version etc. as in a Typical Build Number, but in the report, it'd be nice to see the actual build type as well.

I would have thought that this would have been the default functionality.

I can't seem to get a working report though.

(Worst case is I'll append the BuildType to my Build number but that's a cr*ppy solution...)

Thanks

You can add the additional field from the Reporting Project that you created. Here is what I did:

Create a new Reporting Project
Add TfsReportDS and TfsOlapReportDS (these will not be deployed because they already exist)

Change the project properties (Right click Project and select properties)
OverwriteDataSource = false
TargetDataSourceFolder = /
TargetReportFolder = /Your_Project_Name/
TargetServerURL = http://Your_Report_Server/ReportServer

Download your Builds report and add it to your project using "Add existing item". I suggest renaming the report or backing up the original in case anything goes horribly wrong. For example renamed mine from Build to Build2.

Add Build Type to the query:
Double click the report to open it with the designer and select the Data Tab
Select the Dataset: dsBuilds from the dataset dropdown
In the inner NONEMPTYCROSSJOIN add [Build].[Build Type].[Build Type] and change the 3 to a 4. This should result in an inner section looking like:

NONEMPTYCROSSJOIN
(
GENERATE(STRTOSET(@BuildParam) AS s, DESCENDANTS(s.CURRENTMEMBER,[Build].[Build].[Build])),
[Build].[Build Type].[Build Type],
GENERATE(STRTOSET(@PlatformParam) AS s, DESCENDANTS(s.CURRENTMEMBER,[Platform].[Platform].[Platform])),
GENERATE(STRTOSET(@FlavorParam) AS s, DESCENDANTS(s.CURRENTMEMBER,[Flavor].[Build Flavor].[Build Flavor])),
[Measures].[Build Project Count],4
),