Report by Category?

amacfanNew Member

I am trying to create a report showing the number of companies in each of the categories. I can't seem to find this field in Crystal Reports or find a way to create the table. Ideally the report would show a table such as this:

Category 1 #of companies
Category 2 #of companies
etc.....

Any ideas?

7/30/074:39 PM

❤️ 0

Original Post

gordNew Member

If you are running under MS_SQL:

Look for a view called A_CATEGORY. If it does not exist then launch the SQL Query Analyzer, log in as MASTER, and execute the following command against the database in question:

Exec ADMN_sp_CreateTableDetailView A_CATEGORY,60030,7

If you are running under Pervasive.SQL:

Ask Maximizer for assistance.

.

7/30/076:09 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...