Recent content by DavidT_macktool

  1. DavidT_macktool 2003 Pro reinstall

    Bump...Any ideas...
  2. DavidT_macktool 2003 Pro reinstall

    I reinstalled 2003 Pro after a hard drive crash. Now it appears the Data Adapter Configuration Wizard is using double quotes instead of brackets for field names with spaces...example. ""Field Name"" instead of [Field Name] This appears to be stopping the wizard from regenerating...
  3. DavidT_macktool

    Database Diagram - Cascade relationship

    Makes complete sense. I was hoping to not have to create new tables to replace the inherited ones, but I think that is the best fix. Might as well correct it now and avoid issues later. Thanks for the information/reply.
  4. DavidT_macktool

    Database Diagram - Cascade relationship

    I cant get the second tier of a relationship to work. Here is the structure: Setup Operations -> one to many -> Setup Fixtures -> one to many -> Setup Photos. Keys: Setup Operations: PartId, OperationNumber Setup Fixtures: PartId, OperationNumber, FixtureNumber Setup Photos: PartId...
  5. DavidT_macktool

    Variable length text

    Thanks again MattP!
  6. DavidT_macktool

    Variable length text

    Ok, one more wrinkle in the equation. There can be a instance where the "S" can be followed by a "-". The dash will not always be there, but when it is, it means something. So on some records I would want "S4" and on others I would want the "S-4". Can that be done? Thanks in advance.
  7. DavidT_macktool

    Variable length text

    Thank you Awesome! Thanks MattP, I was not dealing with the decimal point correctly. Your expression gets the job done. Thank you to all who replied.
  8. DavidT_macktool

    Variable length text

    G10L41T20P0C15D1.2S1I0E1.2H4.7262K0.J0Q1450N00000001 G10L41T21P0C19D0.87S1I0E0.875H5.9386K0.J0Q884N00000001 G10L41T22P0C2D0.53S1I0H7.3233K0.159B0J0Q236N00000001A0. G10L41T23P0C15D0.25S1I0E0.25H7.2087K0.J0Q0N00000001 G10L41T24P0C15D0.75S1I0E0.75H7.4646K0.J0Q5253N00000001 Above is an example of...
  9. DavidT_macktool

    calculate time

    8:00 p.m. should be converted to 20:00 - military time.
  10. DavidT_macktool

    passing 2 parameters from a textbox to a crystal report

    YOU CAN KEEP A RUNNING TOTAL OF YOUR FORMULA FIELD ON THE DETAIL LINE AND JUST SUPPRESS IT. SOMETHING LIKE: ADD A FORMULA FIELD... @FormulaFieldSUM Drop on the detail band - you can suppress it after you see it works... CRYSTAL SYNTAX Formula = WhilePrintingRecords; currencyvar SUMTotal...
  11. DavidT_macktool

    End user printouts

    Dim testReport As As New YourReportName Dim testText As CrystalDecisions.CrystalReports.Engine.TextObject testText = CType(Traveler.ReportDefinition.ReportObjects.Item("Text1"), CrystalDecisions.CrystalReports.Engine.TextObject) testText.Text = "this is it" Sorry, the...
  12. DavidT_macktool

    passing startdate and enddate parameters in crystal reports

    Example of monthly sales between two dates Dim MonthlySales As New rptSalesReport MonthlySales.SetParameterValue("StartDate", dStartdate) MonthlySales.SetParameterValue("EndDate", dEndDate) CrystalReportViewer1.ReportSource = MonthlySales...
  13. DavidT_macktool

    End user printouts

    Use Parameters You can pass text as strings by using parameters in the report. also, you can assign text to textboxes on the report directly. Set textbox text from viewer: Dim testReport As CrystalDecisions.CrystalReports.Engine.TextObject Dim testText As...
  14. DavidT_macktool

    Automatically select default printer paper

    Here Is Some Code Used To Print Crystal Reports myRpt.PrintOptions.PrinterName = "\\COMPUTERNAME\PRINTER NAME" myRpt.PrintOptions.PaperOrientation = CrystalDecisions.[Shared].PaperOrientation.Portrait myRpt.PrintOptions.PaperSize =...
  15. DavidT_macktool

    dynamically assigning a dataset to a crystal report

    For your design time issue, open the 'Project Data' folder in the data tab of the database expert. You should be able to use the datatable(s) you created at design time to design the report and then assign the table to the report at run time. Hope that helps...
Top Bottom