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.
Setup Operations: PartId, OperationNumber
Setup Fixtures: PartId, OperationNumber, FixtureNumber
Setup Photos: PartId...
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.
Above is an example of...
YOU CAN KEEP A RUNNING TOTAL OF YOUR FORMULA FIELD ON THE DETAIL LINE AND JUST SUPPRESS IT.
ADD A FORMULA FIELD... @FormulaFieldSUM
Drop on the detail band - you can suppress it after you see it works...
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"
Example of monthly sales between two dates
Dim MonthlySales As New rptSalesReport
CrystalReportViewer1.ReportSource = MonthlySales...
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
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...
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...
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...
Dim dv As DataView
dv = New DataView
.Table = DataSet1.Tables(0)
.AllowDelete = True
.AllowEdit = True
.AllowNew = True
.RowFilter = "YourColumnName LIKE '%" & TextBox1.Text & "%'"