Hi there, I am trying to create a report manually (i.e. without the wizard - dont ask [:)]) and I have managed to set up pretty much everything correctly, except for the data sources in the query. When adding a table as a new data source, all fields in the table are automatically added to the query. I would like to limit that to certain fields, however there seems to be no way to remove the automatically added fields. Is this possible? Thanks.
Are you sure you are working with navision? [:p] yes? then choose > and not >> to go from left to right (first you have to select the right field(s).[}:)] Best Regards, john
As I mentioned, I am not using the wizard, which is where one would use > and >> (doubleclicking there is easier anyway). I am creating the report manually. I have noticed, however, that even if you DO use the wizard to generate a report, it still selects all table fields in the query, no matter which fields were selected but it only displays the selected fields. What I want is a more selective query that will not haul an extra twenty fields from the DB when I only need two. Thanks.
Navision by itself does not have queries, it will always retrieve all fields into a record variable when a record is retrieved from the server. There is no way to change this behavior. Are you talking about the SQL server option and the SQL queries that are generated “in the background”?
mbenic, Are you really talking about MBS-Navision (formerly known as Financials/Attain)? I’m only asking because I see you have posted before in the Axapta forum. Could it be that you’re working with Axapta and just posted in the wrong forum? Sorry if my guess is wrong. Your question is completely baffling us… [:D][;)]
Umm, how do I put this… DOH!!! [:0] I mustv selected this forum by mistake… I’ve linked back to the topic directly so I have never picked up on my mistake. Sorry about that… sigh I need more sleep.
Hey, at least you’re making us think hard, and that’s got to be a good think [:D] Good luck solving your problem!