Search results

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

    Graphs in Crystal Report

    Report Wizard Many different types of graphs are included as a tab in the report wizard. You can experiment with them by going through the report wizard and generating a report that contains one of the graphs available. Try changing the styles, it is pretty easy. The key to effectively using...
  17. DavidT_macktool

    crystal report error

    Merge Modules In the Solution Explorer, right-click the Setup Project, point to AddMerge Module. In the Add Modules dialog box, select the following merge modules to add to your Setup project and click Open: Crystal Reports for Visual Studio .NET 2005 Merge Modules for Crystal Reports for...
  18. DavidT_macktool

    Crystal Reports XI Help

    It's a grouping issue Here is my 2 cents... If you use the PrintLog table to drive the report - Letters in the letter table that have no PrintLog records will not be included in the report. Sort the PrintLog table by LetterID and link it to the Letters table by LetterID. Group the report by...
  19. DavidT_macktool

    filtering a datagrid

    Post Your Solution So Others Searching This Thread Can Find Help... Thank You.
  20. DavidT_macktool

    filtering a datagrid

    Try this: Dim dv As DataView dv = New DataView With dv .Table = DataSet1.Tables(0) .AllowDelete = True .AllowEdit = True .AllowNew = True .RowFilter = "YourColumnName LIKE '%" & TextBox1.Text & "%'" End...
Top Bottom