Solved

Problem in Crystal Report

Posted on 2004-04-23
4
225 Views
Last Modified: 2010-04-07
I've using ASP.NET with Crystal Report 8.5 which is included in the ASP.NET.
the report is working ok with the connection of SQL Server 2000. here we write the query in the Crystal Report (.RPT) for executing when we establishing the connection.

can i send a command query from the ASP.NET Page ????
and one more thing how we pass the parameters in the Crystal Report  and how to use for the same.
Please tell me step by step
0
Comment
Question by:amitverma12679
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 1

Accepted Solution

by:
warmach earned 100 total points
ID: 10902066
I would recommend putting your query inside a stored procedure.  It will be faster and easier to work with.  In Crystal, when ever you build your report, instead of connection to a table, use the stored procedure.  Crystal will then automatically ask the user for the parameters.

Hope it works out.
0
 

Expert Comment

by:kaleem01_pk
ID: 10905954
Hi,
I have not used Crystal Reports with ASP. But can give you an idea. U should use Crystal reports Viewer control. It as an active X control. Just embed it on the page and use RDC model  for this. i do this in VB like this
dim myApp as new craxdrt.Application
dim myRpt as new craxdrt.Report

myApp.logonserver(....)
Set myRpt=myApp.Openreport(App.path & "\r.rpt")
myRpt.ParameterFields(1).Addcurrentvale 123    ' for number
myRpt.ParameterFields(2).Addcurrentvale "123" ' for string
myRpt.ParameterFields(3).Addcurrentvale cdate(format(dtpFrom,"yyyy/MM/dd")) ' for date

myRpt.sqlquery = "select * from mytable"
' u can use recordeselection formula as well like
myRpt.recordselectionformula = "{mytable.dated}=?date"

crViewer1.reportsource= myrpt
crviewer1.showreport


you can convert it into ASP syntax
i think you have to use
myApp = server.CreateObjcet(craxdrt.Application)
myrprt=server.CreateObjcet(craxdrt.Report)

..........


regards
kaleem
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question