I'm working on reports and I'm finding most of the resources on the net are basic using the wizard or using one or two databases and I'd like something more indepth for my reports. I'm using a relational database on MS SQL Server 2008 and BIDS to develop and the users will access the reports through our Sharepoint site. There is also a lot of information on new cube databases and warehousing but the system we have is tied to an accounting program so its not likely we'd upgrade to newer technology or correct any database design issues.
I'm finding that some relationships set up in the database are incorrect. I'll have two primary keys linked (ie. client (ID) tied to invoice (ID) and then down a few fields will be a ClientID). When designing the query I'll correct these but will my data still be incorrect?