Drill-Through Reports cannot accept Dates from the Parent Report

[Cng2005]

Hello Everyone !


I am having a very frustrating time handling drill-thru reports in Cognos ReportNet.
I have my Main Report which has DateFrom and DateTo as the User Input parameters, however I need to pass these dates to one of the drill-thru Reports.

What happens is when the user tries to click the link in the Parent Report, the drill thru report opens up, however it prompts the dates again. There are other parameters like Strings, which does get passed, except the dates .....I did make sure that I have linked the paramters quite correctly in the drill-thru wizard.


Anyone has any idea regarding the problm ??????????????????

THANKS A LOT !!!!!!!!!!!!!!!!
8)

[MFGF]

An obvious cause that's sometimes overlooked is that the child report has the same parameter date filter(s) defined twice.  Did you test the child report stand-alone to make sure that all it's prompts appear as you expect (ie no repetitions of the date prompt)?

If all this is OK, can you duplicate the problem using the GO Sales and Retailers package and post the XML of the two reports - that will help us to see what's going on.

Best regards,

MF.

[Cng2005]

hi mfgf,

Thanks for the quick response !

I have tried running the child report separately, and there is only one set of Date-parametersÃ,  asked.

However I would like to mention one point here. The Child report is generated from a Stored Procedure (written in SQL Server) and deployed earlier in Framework Mgr, and it has 2 INPUT date parameters.Ã,  And thus in the Child report, I never had to create any separate Parameters. Those parameters from SP are automatically called when the Report is run.

So that is the case .......

It might be I am expecting something very strange, but in theory, this SHOULD have worked.

[cognosfreelancer]

Hello Cng2005

Your drill through report displays data from a SQL server while your main report gets dates from user entry.

It could be that your date data types do not match with those of the main report.

Just a thought..
NKT

[Cng2005]

hi there,

You may just be right !

Can anyone say me how to do the date formatting for the dates entered via User Entry ?

[zenith]

Hi

You can use the data format option to format the dates wrt to date style, operator etc
Hope this helps

Cheers

Zenith

[bdybldr]

Cng2005,
You have to make sure that the passed parameters are facts in your main report query.  You also need to make sure that you have a parameter in your child report for every parameter passed.  When you define your drill-through make the parameters in your child report equal to the query items in your parent report.  Hope this helps.