I have joined the forum specifially because I am having a problem which I hope someone will enable me to overcome!  I have scanned the existing topics but not found one which answers my problem.

 

We am generating a number of reports from a VB Web application, most of which are working fine.

 

We are designing the reports in the CR 2008 environment, using SQL queries to source the database fields.  Then we programmatically load the main report SQL at run time in the VB using the ReportDocument DOM (because there are run-time changes we need to make to the query).  The 'spoof' SQL in the CR document, and the SQL loaded at run-time have exactly the same field names

 

One of the reports, however, needs a sub-report in the Details section which takes a parameter from one of the other fields in that section.  The sub-report SQL is fixed and therefore the query embedded in the CR document can be used.

 

In the CR environment the Preview is working with no problem, but when we generate the report from the VB, the sub-report is not populated.

 

I am guessing that it will be something to do with the sub-report 'Links', but have been unable to determine quite what!  Do I perhaps need to add a "TableLink" object at run-time to link the sub-report parameter to the main report field?  If so how?  If not what?

 

Many thanks in advance.

 

 

 

Not sure whether this is relevant, but if I watch the document after it has finished loading all it's stuff at run-time I have...

 

doc.Subreports.Item(n).Database.Links.Count = 0

 

(where "n" is such as to point at the subreport in question).

 

I would have expected this to contain details of the parameter link?

 

Meanwhile I'll keep looking

 

Argh! As far as I can see all the TableLinks properties are read only!  So if you can't set them at run-time the problem must be somewhere else.

 

Heeeeeeeeellllllllllllllpppppppppp!!