Search results for query: *

Bump...Any ideas...

I reinstalled VS.net 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...

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.

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

Thanks again MattP!

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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