Joined: 04 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 70
Topic: Reporting on Access 'Procedures' Posted: 20 May 2009 at 9:06am
Being asked to improve on a report designed using MS Access, I tried a number of ways, but pleased to see that I can import a set of 'queries' to Crystal, which look like stored procedures, using date parameters and simple outputs. Nothing to link on but shouldn't matter - each entity works for itself, depending on date parameters, set nicely in Crystal automatically. Simple problem is:
where each query has a fine browsable output from the Field Explorer, but when I put it into the details section, all these fields show blank on the report. How can this be? I may have seen this before, but can't quite remember... Whenever I check and change parameters, the values all change appropriately in Field Explorer, but why won't they show as I drag these into Details?
Thanks
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum