My goal: I no longer want my report to reference this MS Access table because it prevents me from loading this report into Lawson Business Intelligence (LBI) because MS Access is not an aproved Data Source, unlike our ODBC connection. Is there a way to take this Access table, and incorporate the data into my existing report (in some simple way) so that I can stop this connection to MS Access? I've been exploring the CR Respository feature but it looks like we need an ODBC connection to that as well and some behind the scenes server set up for that option to work.

 

Any suggestions would be appreciated, thanks!