I’m running a query in BO 6.5, and have a situation where, depending on the values entered at the prompts, one of the 2 data providers I’m using may be empty. Basically, each DP returns data for a financial half year. If the query is concerned entirely with the first half, then the second will return no data, and vice versa. As a result, I don’t want to see the ‘No data to fetch’ message (well, I don’t mind it but it confuses users)
I’ve checked the Reporter FAQs, and there is a programatic solution in there, but unfortunately it suppresses all of the prompt windows as well. Does anyone know if there any way of suppressing one and not the other?
Any help gratefully appreciated
If possible you could use a union query if the same data fields are used.
But I assume that you use 2 DPs due to the fact that the data is disparate. In that case would it be possible to create a dummy table (or more than one) that retrieves a neutral record?
In that case you can use union queries that are bound to retrieve at least one row while retaining the option for prompts.
If you keep on reading in the FAQ about no data to fetch you’ll see instructions for using union queries or for using contexts and dummy records to suppress the message. I have definitely used the contexts and dummy records alternative and it works. I have a multiple prompt, multiple data provider report that often doesn’t have data returned from every DP and the messages do not appear. Did this for the same reason you gave in that it was annoying and confusing for the users.
(BOB member since 2002-06-25)
(BOB member since 2004-02-11)
(BOB member since 2005-02-24)