473,581 Members | 2,789 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Make Reports that can pass parameters at Run-time? :: ASP.NET + CR.NET

Hi There!

I've posted a few days back about this issue but no solutions has been found
and that's why I'm re-posting this.

I'm using built-in CrystalReport that comes with VS.NET 2003 to create
reports for use it ASP.NET.

How do I configure a graph in the Report (*.rpt file) so that I can pass the
SQL Query as an argument from ASP.NET Application? I know that I can define
parameters in Crystal Report .NET but I don't know how. I also know that
from ASP.NET you can pass values to the parameters defined in Crystal Report
..NET at run-time but again I don't know how.

Please advice!

Many Thanks,
Don

Nov 18 '05 #1
3 2245
"Don Wash" <do*@wash.com > wrote in
news:#M******** ******@tk2msftn gp13.phx.gbl:
How do I configure a graph in the Report (*.rpt file) so that I can
pass the SQL Query as an argument from ASP.NET Application? I know
that I can define parameters in Crystal Report .NET but I don't know
how. I also know that from ASP.NET you can pass values to the
parameters defined in Crystal Report .NET at run-time but again I
don't know how.


Easiest way would be to pass a dataset to Crystal.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 18 '05 #2
Hi Lucas,

Thanks for the reply! How do I pass the DataSet to Crystal Reports?

Many Thanks,
Don

"Lucas Tam" <RE********@rog ers.com> wrote in message
news:Xn******** *************** ****@140.99.99. 130...
"Don Wash" <do*@wash.com > wrote in
news:#M******** ******@tk2msftn gp13.phx.gbl:
How do I configure a graph in the Report (*.rpt file) so that I can
pass the SQL Query as an argument from ASP.NET Application? I know
that I can define parameters in Crystal Report .NET but I don't know
how. I also know that from ASP.NET you can pass values to the
parameters defined in Crystal Report .NET at run-time but again I
don't know how.


Easiest way would be to pass a dataset to Crystal.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

Nov 18 '05 #3
"Don Wash" <do*@wash.com > wrote in news:O$AtLCadEH A.3616
@TK2MSFTNGP10.p hx.gbl:
Hi Lucas,

Thanks for the reply! How do I pass the DataSet to Crystal Reports?


http://support.businessobjects.com/c...s/rtm_reportin
goffadonetdatas ets.pdf.asp

This way you can pass parameters into a .NET dataset and change the .NET
query output before passing the formatting dataset to Crystal.
--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

42
4922
by: WindAndWaves | last post by:
Dear All Can you tell me why you use a class module??? Thank you Nicolaas ---
10
17522
by: Joriz | last post by:
Obviously im new with ms access..so my basic question is how do i run crystal reports in my ADP. I also pass parameters to cyrstal reports. Please help! thanks in advance
7
21604
by: Zlatko Matić | last post by:
Let's assume that we have a database on some SQL server (let it be MS SQL Server) and that we want to execute some parameterized query as a pass.through query. How can we pass parameters to the server ? Is it possible to use parameters in pass-through queries ? An additional question: Is it possible to connect to a database on MySQL or...
4
2480
by: touf | last post by:
hi, I'm using Crystal reports to generate a simple report in a VB.net windows application, I've defined all my stuffs (accessMDB,query, 2 parameters) in the report design, and it's working fine, when a report is opened it prompts me to input the parameters values . But, in order to incorporate this report to my application, I have 3...
4
4431
by: Brian Henry | last post by:
I have a bunch of reports in crystal reports.net, i need to basicly run them on differnt databases depending on which one the user logged into at the vb.net application start (dev, live, testing)... now the reports are created at the development level.. so i figured just change the database like you pass parameters to the report viewer......
4
1849
by: PraveenKadkol | last post by:
Hi, My Development is in almost final stages, now i am facing problem with the reports. I am generating MsAccess Reports based on the selected Parameters, while generating Report I am opening reports forms in desgin mode and then i am passing Parameters and Sql String to Record Source This is working ifne for single user, but if multi...
3
9910
by: LataChavan | last post by:
I have tried to look for a solution to the problem of sending parameters to stored procedures through crystal report. Following is the code: Now what happens is that if i do not apply the logon information the crystal reports works fine by accepting the parameter values and giving the Database Logon prompt when we run the report. But I would...
2
7891
by: nguyenmiket | last post by:
I have created a crystal report in XI that uses a stored procedure with two date parameters. When i run it in Crystal reports it prompts me for the dates. When i put it in a view in a .aspx page, it fails with this message: Method 'IPromptingHTMLRenderOption_reserve10' on type...
1
1964
by: sreedivya | last post by:
Hi All I am trying to create crystal reports. In this concern i have created a command which execute a stored procedure. This stored procedure takes three parameters which in turn i want to pass it from .aspx page. when i click on button parameters should pass to that stored procedure. for example exec sp_example @date='{?selecteddate}' ...
1
4840
by: =?Utf-8?B?dmlzaHJ1dGg=?= | last post by:
Hi, I have 2 applications running, one Windows application project and the other windows services project. I want to call my Windows application in my windows services. I want to run them as seperate process. If my windows application starts running,only if it completes fully, then my windows services should continue its execution. My...
0
7882
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7808
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8312
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
8181
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6564
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5366
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3809
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3835
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1410
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.