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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by IdoMillet

  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...

Part and Inventory Search

Back
Top