Solved

Problem in Crystal Report

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

762 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now