Classic ASP calling Crystal Reports

I have a simple form with 3 selections that user must complete (Start Date (textbox), End Date (textbox), Report Name (dropdownlist))  When the user clicks the submit button I want the form to post back to itself and call a stored procudure (usp_report).  The stored procedure needs all 3 parameters to run.  I then need to open crystal reports 10 with the results. How do I accomplish this?  My crystal reports are on the same developement server and the data is on sql server 2000.  I have spent hours looking at articles relating to the subject, but I still have not been able to grasp the concept.  I need the answer in plain simple english.  Thanks in advance for any help you can provide.
<html>
<head>
 <title>Reporting</title>
</head>
 
<body>
<center>
 
<form name="Form_Main" ID="Form_Main" action="default.asp" method="POST">
 
<table border="0" align="center" cellpadding="0" cellspacing="0" ID="Table1">
	<tr>
		<td align="center"><img src=""></td>
	</tr>
	<tr>
		<td align="center" class="header">REPORTING</td>
	</tr>
	<tr>
	<td>
 
	   <table border="1" cellpadding="0" cellspacing="0" ID="Table2">
	      <tr bgcolor="red">
	         <td align="center" class="td">Begin Date</td>	
		 <td align="center" class="td">End Date</td>	
		 <td align="center" class="td">Report</td>
	      </tr>
	      <tr bgcolor="silver">
		 <td>
			<input type="text" name="tbLdStart" ID="tbLdStart" size="10" value="<%=trim(ldStart)%>">
		</td>
	   	 <td>
	   		<input type="text" name="tbLdEnd" ID="tbLdEnd" size="10" value="<%=trim(ldEnd)%>">
	   	</td>
		 <td>	
			<select name="ddLdReport" ID="Select1" class="tdSelections" onchange="Selections();" <%=lsDisabled%>>
		           <option value="0" <%IF trim(ldReport) = "0" then response.write "Selected" %>>Select Report</option>
		           <option value="1" <%IF trim(ldReport) = "1" then response.write "Selected" %> >Employee Summary</option>
		           <option value="2" <%IF trim(ldReport) = "2" then response.write "Selected" %> >Employee Summary - Dept</option>
		           <option value="3" <%IF trim(ldReport) = "3" then response.write "Selected" %> >Employee Summary - Dept Charges</option>
			</select>
		 </td>
	     </tr>
	   </table>
	</td>
    </tr>
</table>
 
<br><input type="Reset" value="Clear" id="button2" name="button2">
 &nbsp;&nbsp;&nbsp;
<input type="Submit" value="Open Report" id="btnSubmit" name="btnSubmit">
&nbsp;&nbsp;&nbsp;
<input type="button" value="Close Window" onclick="javascript:window.close();" id="btnClose" name="btnClose">
 
</form>
 
</body>
</html>

Open in new window

gmjames13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are you wanting to push the data to the report?

If you pass the parameters to Crystal, Crystal will pass them to the stored procedure, run it, then display the report.

Here is a link to several example ASP programs that call CR10
http://support.businessobjects.com/communityCS/FilesAndUpdates/aspxmps10.exe.asp

mlmcc
0
gmjames13Author Commented:
How do I know which one of the ASP examples to use with what I am trying to accomplish.  I do not know the first thing about crystal reports.  How do I pass the variables to crystal so that crystal can pass the variables to the stored procedure.
0
mlmccCommented:
THere should be one that has PARAMETER in the file name.

mlmcc
0
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

gmjames13Author Commented:
How do I pass the parameters to crystal reports?   I have finally got crystal reports to open, I can see my stored procedure, but I do not understand how to pass my start and end dates from crystal to my stored procedure.
0
mlmccCommented:
Crystal will prompt for them then pass them for you.  You don't need to worry about executing the syored procedure.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gmjames13Author Commented:
Thanks for yor help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.