Hello,
I'm new to using Crystal Reports and have run into a problem.
I'm currently designing a new database for a company. The front end
application is being coded in C# using Visual Studio.Net 2003 with
Crystal Reports. The back end is Microsoft SQL Server. I would really
like to use my report and have it pull information from the strongly
typed dataset in the project, this however results in the user being
prompted to log in to tables and regardless of the information given,
eventually fails. I switched it to using the back end database itself
and set the login information. It still prompts for 3 of the many
tables, but it will accept the information and show the report. The
report does not contain any data however as soon as I set a filter.
For example: I have a table of orders. I'm trying to print a specific
order. selectFormula is a private string in the form and shipment is a
public report, both are initialized when the form loads. When I set:
selectFormula = "{Quotes.QuoteID} = " + QuoteNoBox.Text;
//QuoteNoBox.Text is the order number
shipment.RecordSelectionFormula = selectFormula;
shipment.Refresh();
at the time of printing, I get a blank report.
Does anyone have any suggestions? Let me know if you need any more
information.
Thanks,
Elisabeth
|
Similar Threads
