I am trying to create a dynamic report. I tried using a template dataset (to generate and xml file). I tried using formula fields. But none of them work.

Can someone give me a step-by-step, how to prepare a report template, and how to programatically code to retrieve the database information? I am nearing the end of my probationary period on my new job. My boss has told me that I need to get this right...

Stored procedure: spSearchBySupervisorID
Parameters:
1. @SupervisorID (nchar)
2. @SelectionType (nvarchar)
3. @StartDate (smalldatetime)
4. @EndDate (smalldatetime)
Fields:
1. LastName
2. FirstName
3. RequestSubmissionDate
4. StartDate
5. EndDate

The program allows employees to submit on-line request for time off, i.e. vacation or sick leave. The supervisor replies back by filing out an on-line form. But the supervisor needs to access the records to fill out forms and see various reports.

Thank you in advance.

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Post your code like this:

Thanks

Check This link , It is a step by step help for creating dynamic crystal report.

http://vb.net-informations.com/crystal-rep...uery_string.htm

thanks.