I am struggling to get publications working with dynamic recipients. I know there was a bug that was fixed in 2.6, which we have installed and I am testing, but I still have the same problem. I am not emailing the documents but rather putting them on a file server. Perhaps I am mistaken, but I thought the following should work:
The main report contains a parameter prompt of Country. I have defined the source of the dynamic recipients as a query that returns all the countries in the system. I have mapped the Country name to both the Recipient Identifier and the Full Name.
Then in the Personalization screen I have related the Country name in the recipients query to the Country parameter in the main report. What I find strange here is that the Report Field on the Personalization screen is a free text entry, whereas everything else in the setup is a drop down list of actual data driven options. Nevertheless I am quite sure there is no typo here; I have done it and checked it many times with no change in result.
I have defined the file name to include the user name parameter. The report runs and generates a separate file for each country just fine, but each report is blank. There are actually two tabs in the main deski report, and the second one is not dependent on Country, yet it is blank also. The reports retrieve data just fine when I run them manually.
Can anyone give me any advice?