Itzik B

Hi all,

I pass to the subreport one paramter, the ID of the parent node, and in the sub report i do :

SELECT non empty {[Measures].[Current Work Item Count]} ON COLUMNS,

NON EMPTY { [Work Item].[System_Id].[System_Id]*

[Work Item].[System_Title].[System_Title]*

[Work Item].[System_Reason].[System_Reason]*

[Work Item].[System_State].[System_State]*

[Assigned To].[Person].[Person]*

[Work Item].[Microsoft_VSTS_Common_Discipline].&[LD]*

[Work Item].[System_WorkItemType].&[Task]} ON ROWS

FROM [Team System]

WHERE STRTOSET(@ID)

When i try to open a subreport and the ID that is passed wont get me any result (there is no child nodes) I get "Error: Subreport could not be shown".

my objectives are :

  1. If there is no data under that node I would like not to diplay the '+' near the parent node.
  2. If 1 is not possible, i would like not to show the error that is described above and show something like : 'No data is avalable' or just show an empty table...

Hope you can help me....

Thanks !!!

Itzik




Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Matthew Mitrik MSFT

HI Itzik,

Are you still looking for help with this report

Matt






Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Ameya Bhatawdekar MSFT

Itzik,

I think you are running into a type mismatch issue. The parent report is passing an INT value to the sub report, but the sub report is expecting an MDX string. If you look at the parameter details for the sub report, you check if the default value is an MDX expression. If it is an MDX expression, then you will have to add another parameter to the sub report of type INT and modify the original parameter to get it's default value from a VB.NET expression. The expression will have to construct the MDX string from the value of the second parameter.

Net net, parent reports passes and INT value, an INT param in the sub reports accepts this value, then the second paramenter (which drives the actual queries in the sub report) transforms this into an MDX expression.

Let me know if you need more details.

Ameya





Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Jack Shuae

Hi Ameya,

I bumped into the Same Subreport parameter (using MDX off a Cube) problem today.

"If it is an MDX expression, then you will have to add another parameter to the sub report of type INT and modify the original parameter to get it's default value from a VB.NET expression. The expression will have to construct the MDX string from the value of the second parameter."

Can you explain in detail (or show an example) of how to setup the 2nd parameter to get the valued passed from the top-level report.

Thanks.

-Jack




Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Othmane Rahmouni-MSFT

Hi Jack,

I would suggest checking out the Out-of-the-box reports: 'Scenario Details' or 'Requirement Details' as they both contain subreports. If you open one the reports in BIDS, you can see how they are hooked up.

Thanks,

Othmane





Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Jack Shuae

Othmane,

Thanks for the reply.

I am checking the "AdventureWorks" Reporting Samples and did not find the samples ('Scenario Details') you mentioned.

Can you provide me with a link to download them

Thanks.

-Jack





Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Othmane Rahmouni-MSFT

These are reports that ship as part of the TFS methodologies process template. Use steps 1-16 from the following link to download and open the reports: http://msdn2.microsoft.com/en-us/library/ms181640(VS.80).aspx (and customize them.)

Thanks,

Othmane





Re: Team Foundation Server - Reporting & Warehouse Error: Subreport could not be shown

Ameya Bhatawdekar MSFT

Jack -

Here's a screen cast that demonstrates building a ¡°traceability report¡± that uses a subreport control to embed one report in another. It also demonstrates how to address the ¡°Subreport could not be shown¡± error.

The video quality is not the greatest but if you view it in the full screen/large more ¨C you should be able to follow what I do.


Creating a sub report

Hope this helps.

Ameya