Solved

Problem in Crystal Report

Posted on 2004-04-23
4
224 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

Technology Partners: 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 .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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