Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mehlsl

    ACCESS reports - convert them to Crystal Reports

    Hello -- Should this be posted in a Crystal Reports forum instead? Can anyone recommend a utility to convert MS ACCESS report objects to Crystal Reports? Thanks for any suggestions. Larry Mehl
  2. mehlsl

    Crystal Reports - add "ALL" to Parameter Dynamic List of Values

    hilfy -- Thank you. Your instructions were very clear. This method will eliminate an administrative headache. Do you know if any later versions of CR allow simply naming a field (contained in the source view for the report) as the dynamic parameter, and, hopefully, being able to append " ALL"...
  3. mehlsl

    CR - Parameter values generated dynamically from a source view column do not include all values

    Using CR XI Hello -- The list does not show values from the source view ... only the parameter values selected in the last run of the report. Can the dynamic list be generated from another view in the datasource? If so, can you point me to instructions on how to do this? The values for the...
  4. mehlsl

    Crystal Reports - add "ALL" to Parameter Dynamic List of Values

    Using CR XI Hello -- How can I add "ALL" to the list of selectable parameter values generated dynamically from a field? OR Can I set the source for the "Allow Multiple value" parameter list to something like this SQL, or a view containing it? SELECT DISTINCT(PgmStatus) FROM <table> UNION...
  5. mehlsl

    for views: get Current connection parameters &gt; User and Description &gt; Schema from 2005 system

    George and philhege -- Thank you. I think George's second suggestion is what I need if my assumption that Description > Schema is the user that created the view. Am I correct? If this is not correct, do you or does anyone know where to find the creator and modifier of the view, even if...
  6. mehlsl

    for views: get Current connection parameters &gt; User and Description &gt; Schema from 2005 system

    Hello -- Using 2005 Object Explorer, when I right-click on a view > Properties the right frame shows the 3 sub-frames: Current connection parameters, Description, and Options I want to query the system tables to get information on the database's views, including the following two values from 2...
  7. mehlsl

    Utilities for Crystal Reports - 1) document a report; 2) inventory reports

    Ido -- Thank you for posting this response here and in SAP Community Network. It will help my team in a significant way. Larry
  8. mehlsl

    Utilities for Crystal Reports - 1) document a report; 2) inventory reports

    Hello -- Can anyone recommend utilities to do the following two tasks for our Crystal Reports: 1) Document a report We need complete detail, far in excess of what we get from File > Export > Export Report > Report Definition (to a text file) 2) Inventory reports We want to list report...
  9. mehlsl

    Bar chart - bars for every n-th day

    Thank you both for responding. Madawc -- This looks like a method to cumulate the count over the days in the interval, rather than "sampling" the count for each n-th day. Am I right? We are using CR 10. Sorry for the omission. lbass -- Sorry for the fuzziness. We want to show a bar...
  10. mehlsl

    Bar chart - bars for every n-th day

    Hello -- A bar chart will show counts of comments made by customers (Y-axis) by day during a period of time (X-axis). Instead of showing bars for each day in the period, is there a way to show the bar for every n-th day? Thanks for any help. Larry Mehl
  11. mehlsl

    Crosstab - sorting columns non-alphabetically

    Katy -- Thanks. I was hoping for a solution that worked with the data, and did not require hard-coding values in the report. However, since there are only a few values for Region it will work fine. Larry
  12. mehlsl

    Crosstab - sorting columns non-alphabetically

    Hello -- I could not find postings on this subject; please pardon the duplication if they exist. How do I print crosstab column headings in a specific (non-alphabetic order)? Our crosstab columns are sales regions to be printed in this order: Asia, Japan, EMEA, US+Canada, and Other...
  13. mehlsl

    TopN

    Thank you.
  14. mehlsl

    TopN

    Hello -- IdoMillet Oct 28, 2003 posted "Select the CrossTab by clicking on the empty top-left cell. Then, use the Report, TopN/Sort Group Expert " I can't find Report, "TopN/Sort Group Expert" in Crystal Reports 10. Can someone tell me where it is? Thanks for any help. Larry Mehl
  15. mehlsl

    Crystal from MS ACCESS

    Hi Ken -- I have Seagate Crystal Reports Version 8 Developer Edition English Part No. 14-50001-085 Thanks for responding. Larry
  16. mehlsl

    Crystal from MS ACCESS

    Ken -- Thanks. Is the ActiveX control the one named &quot;Crystal ActiveX Query Viewer 1.0&quot;? Can you tell me 1 - how to &quot;point the control&quot; to the rpt? The only property which looks close to what I need is &quot;Other | QueryFileName&quot;. 2 - Where does the...
  17. mehlsl

    Crystal from MSACCESS

    I am writing my reports for an ACCESS application in Crystal. Can someone tell me the basics of using Crystal instead of the ACCESS report writer? In other words, instead of DoCmd.OpenReport &quot;rptTrnsact&quot;, acNormal, &quot;&quot;, &quot;&quot; , I need to learn the code to open a...

Part and Inventory Search

Back
Top