Crystal Reports 10 wont recognize SQL Tables

andykandersonNew Member

I can see the Pervasive tables and Views fine and I can see the SQL tables in my DataExpert.

But if I try to build a report with the sql tables I get and error "Not Supported"

My big problem with this is to get company name into reports that combine companies / individuals /and contacts

any suggestions??

12/8/049:59 AM

❤️ 0

Original Post

gordNew Member

Hi, Andy.

There is currently a compatibility problem between the Maximizer ODBC driver and Crystal Reports versions 9 and up. MSI is aware of the issue. The workaround for now is to use the Pervasive ODBC driver (MAP_AddressBook DSN).

As for your reporting question, you may have to use a self-join (i.e., include the same table or view more than once).

You also might be interested in my CreateUdfViews utility.

12/8/041:54 PM

❤️ 0

Add Reply

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>

Skip to main content

Add Reply

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...