[RESOLVED] Display selected data on crystal report

Hi everybody,
First problem, I like to display start date and end date selected on the crystal report. How would I do that, declare what type of field, and how would I transfer the value from code to the crystal report?
Second problem, supplying to display selected company and address, address is coming from another table of another database and another server.
Third problem first part, using subreport to display the details of the summary mentioned in first and second problem. The sql statement would look like this, "Select a.Client, b.DateCreated, c.Data2, c.Data3, c.Data4, c.Data5, b.Amount From table1 a inner join table2 b on a.DocId = b.DocId inner join table3 c on a.DocID = c.DocID where a.CoGuid = ?"

a.CoGuid column would be supplied from datavalue of selected company dropdroplist control.

Is there anyone can help me? Thanks.


******* Problem RESOLVED ******

den2005

you can create a temporary table will all the required fields and use that table for crystal report, or else you can create formula fields in crystal and pass the values from code to the formulas in crystal.

Thanks for the reply.

I think creating temporary table is not an option. I am looking a way that can do that in crystal reports and if not possible in sql.

den2005

Quote:

---

Originally Posted by den2005

Hi everybody,
First problem, I like to display start date and end date selected on the crystal report. How would I do that, declare what type of field, and how would I transfer the value from code to the crystal report?
Second problem, supplying to display selected company and address, address is coming from another table of another database and another server.
Third problem first part, using subreport to display the details of the summary mentioned in first and second problem. The sql statement would look like this, "Select a.Client, b.DateCreated, c.Data2, c.Data3, c.Data4, c.Data5, b.Amount From table1 a inner join table2 b on a.DocId = b.DocId inner join table3 c on a.DocID = c.DocID where a.CoGuid = ?"

a.CoGuid column would be supplied from datavalue of selected company dropdroplist control.

Is there anyone can help me? Thanks.

den2005

---

First Problem:

Simply create a string parameter field on the report and send the date data to that parameter. Format the data before you send it to the parameter like take your dates and format it so it looks like "From <date1> to <date2>".

Second:
Sorry not sure of that.

Third: Create a subreport, put it on the master report and use a common link field to get the data.

HTH