Apr 21, 2008 #1 manmaria Technical User Aug 8, 2003 286 US Can I create an adhoc report model using the Report Builder for a data base which does not have a RI? I mean no forced FK relationship between tables? TIA
Can I create an adhoc report model using the Report Builder for a data base which does not have a RI? I mean no forced FK relationship between tables? TIA
Apr 22, 2008 1 #2 pwomack Technical User Apr 16, 2005 121 US Yes you can. Open your data source view in the model. You can then drag/drop logical keys between tables. Upvote 0 Downvote
Yes you can. Open your data source view in the model. You can then drag/drop logical keys between tables.