<div>
Is the report built to run from a dataset?<br />
<br />
Can you change the SQL to do the filtering rather than relying on the report?<br />
<br />
How are you passing the recordset to the report?<br />
<br />
Does the report show the expected data?<br />
<br />
mlmcc
</div>


Is the report built to run from a dataset?

Can you change the SQL to do the filtering rather than relying on the report?

How are you passing the recordset to the report?

Does the report show the expected data?

mlmcc

<div>
<div class="content wysiwyg-content">
I have designed a crystal report and connected to a database. When the report launches a sql statement runs on the calling form and generates a dataset in which to populate the report. See below.<br />
<br />
I need to know how to create 3 fields or parameters within crystal so I can assign them to the dataset fields for population? The fields are called 'name' but the query renames the fields accordingly.<br />
<br />
SELECT c.JobNo,c.Contract_Name,c.<wbr />Address1,c<wbr />.Address2,<wbr />c.Address3<wbr />,c.Town,c.<wbr />County,c.P<wbr />ostCode, <br />
s1.Name AS 'Contract Manager', s2.Name AS 'Surveyor', s3.Name as 'Site Manager',<br />
s1.Mobile, s2.Mobile, s3.Mobile<br />
FROM tbl_ContractDetails c LEFT OUTER JOIN tbl_Staff s1 ON c.ContractManagerID = s1.ID <br />
LEFT OUTER JOIN tbl_Staff s2 ON c.SurveyorID = s2.ID <br />
LEFT OUTER JOIN tbl_Staff s3 ON c.SiteManagerID = s3.ID <br />
ORDER BY c.JobNo ASC<br />
<br />
Thanks
</div>
</div>


I have designed a crystal report and connected to a database. When the report launches a sql statement runs on the calling form and generates a dataset in which to populate the report. See below.

I need to know how to create 3 fields or parameters within crystal so I can assign them to the dataset fields for population? The fields are called 'name' but the query renames the fields accordingly.

SELECT c.JobNo,c.Contract_Name,c.Address1,c.Address2,c.Address3,c.Town,c.County,c.PostCode, 
s1.Name AS 'Contract Manager', s2.Name AS 'Surveyor', s3.Name as 'Site Manager',
s1.Mobile, s2.Mobile, s3.Mobile
FROM tbl_ContractDetails c LEFT OUTER JOIN tbl_Staff s1 ON c.ContractManagerID = s1.ID 
LEFT OUTER JOIN tbl_Staff s2 ON c.SurveyorID = s2.ID 
LEFT OUTER JOIN tbl_Staff s3 ON c.SiteManagerID = s3.ID 
ORDER BY c.JobNo ASC

Thanks

Crystal Report Fields

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.