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!

Register Log in
  • Congratulations derfloh 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. IdoMillet

    Compare a field from main report against a field from a subreport on CRYSTAL REPORT

    You can return info from the subreport to the main report via a shared variable. Or you can pass information from the main report into the subreport using a subreport link. view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  2. IdoMillet

    How to get consistent field width in Note field

    I'd like to test a possible solution. Please provide a sample report with saved data available for download. view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  3. IdoMillet

    Crystal report export to CSV

    Also, at least one of the 3rd-party Crystal report automation tools listed here allows you to use the "good" header file and simply append the csv export to the existing header (while removing the header from the export). view, export, burst, email, and schedule Crystal Reports...
  4. IdoMillet

    Crystal report export to CSV

    Still sounds like a BOM issue to me. If it is, at least one of the 3rd-party UFLs listed here provides control over the emitting of BOM in writing the report data to a a text (.csv) file. view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  5. IdoMillet

    Crystal report export to CSV

    If this is due to BOM issue, there are several ways to get around that. Are you addressing an interactive use case (user running report inside Crystal Designer or a Crystal Viewer) or an automated scenario (scheduled, command line, desktop shortcut)? view, export, burst, email, and schedule...
  6. IdoMillet

    Creative ways to get a 2nd subreport capability from a subreport.

    One way of solving this is to use 3rd-party Crystal Reports tools. See list of 3rd-party Crystal Reports Viewers here. My DataLink viewer allows a double-click on a Crystal report formula (specifying the report to launch, parameter values...) to launch another report. This would be one way to...
  7. IdoMillet

    Best Practices for linking two data sets into one

    One option is to create a database VIEW or a Crystal Command as the data source for the report and use a UNION ALL in the SQL: Select * From mortgage UNION ALL Select * From SecondMortgage view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  8. IdoMillet

    Export to PDF with Embedded Hyperlinks from Crystal Reports 2016

    Since you are using Visual CUT, you can generate hyperlinks in pdf exports. See: https://milletsoftware.com/Visual_CUT_User_Manual/#Adding%20Links%20to%20Files%2FURL%2FeMail%2FPages%20Using%20Formulas%20as%20Tags view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  9. IdoMillet

    conditioning Parameters in Crystal XI

    If the report doesn't contain subreports, you can create a main report with 2 on-demand subreports. Each subreport would have a variation on the parameter logic. If your called subreport contains a subreport, the approach above won't work (a subreport cannot contain a subreport). But at least...
  10. IdoMillet

    I am using cr2016 I have a param

    If you don't want to filter the main report using that parameter, you can do the filtering of the crosstab by passing that parameter as a link to a subreport. And place the CrossTab in the subreport. hth, - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  11. IdoMillet

    Retrieve Current Machine IP Address

    You can create or use a 3rd-party UFL (User Function Library) to handle this. For a list of 3rd-party UFLs, see this link. Here's a link to the GetMachineIPAddress()function in my own CUT Light UFL. hth, - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  12. IdoMillet

    Discontinuous data for chart

    Add a calendar table to the database (one record for each date). Outer join from that table to your daily balances table. view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  13. IdoMillet

    Hiding a parameter in Crystal, while still populating it from the User ID in 3rd Party front end.

    At least one of the 3rd-party Crystal Reports viewers listed here already provides such functionality. A parameter named in a certain way doesn't prompt the user; instead its value gets set to the Windows User Id of the person running the report. view, export, burst, email, and schedule Crystal...
  14. IdoMillet

    Export to excel without excel creating blank rows

    One of the 3rd-party tools listed on Ken Hamady's web site automatically removes blank rows from the Excel (Data Only) exports. view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  15. IdoMillet

    Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

    It sounds like you are trying to use Crystal Reports as a way to generate a form that the user can then complete. Instead of expecting the user to respond to so many parameters, consider generating a PDF form directly from the Crystal report. At least one of the 3rd-party Crystal Reports...
  16. IdoMillet

    Crystal 2013 and .Net distribution

    There are free/inexpensive 3rd-party Crystal Reports viewers. See list here: http://kenhamady.com/productlinks/default.html#viewers - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  17. IdoMillet

    Sorting a Crystal Report by field which is not a group field.

    No need to create another group. Just use the Group Sort Expert to sort the Customer ID group by the Max or Min of Customer Last Name. hth, - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  18. IdoMillet

    crystal reports: Label 1 of 10

    See my FAQ about this: faq149-3226 view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  19. IdoMillet

    2 Sided Mailers through Crystal

    You can suppress a Detail b section for all but record numbers that divide cleanly by 4. In the Suppress attribute for Detail b, set an expression such as Remainder(RecordsNumber, 4) = 0 hth, - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com
  20. IdoMillet

    Drill-down Report

    This can be done using at least one of the 3rd-party viewers listed at: http://kenhamady.com/bookmarks.html That viewer allows a click on one formula to set the value of another formula. hth, - Ido view, export, burst, email, and schedule Crystal Reports. www.MilletSoftware.com

Part and Inventory Search

Back
Top