hi,
i am using crystalreports in my project(asp.net and c#.net) .i am able to display complete data from the data base on to the report .but i want to filter the data depending on particular criteria what is the procedure i have to follow.
My report contains 10 fields Id,location,mes sage,date,time, ..so on now i am able to display the complete data i.e what ever the data exist in the database irespective of date or id .now i want to filter my data depending on date or id.
for that i want to add two text boxes on my webform and two check boxes corresponding ,when ever i check the checktbox related to date text box and i enter the date then i should get data fields related to that particular date only similarly if enter id in the other text box then ishould get the data related to that particular id on all dates on the report, this should be done at the run time .
plz help any one
thanks ®ards
nmsreddi
3 13168
Hi,
Refer this Title:"Database programming using vb.net and sql server 2000". this book covers the development of the reports using crystal reports.
Regards
bhar
hi,
i am using crystalreports in my project(asp.net and c#.net) .i am able to display complete data from the data base on to the report .but i want to filter the data depending on particular criteria what is the procedure i have to follow.
My report contains 10 fields Id,location,mes sage,date,time, ..so on now i am able to display the complete data i.e what ever the data exist in the database irespective of date or id .now i want to filter my data depending on date or id.
for that i want to add two text boxes on my webform and two check boxes corresponding ,when ever i check the checktbox related to date text box and i enter the date then i should get data fields related to that particular date only similarly if enter id in the other text box then ishould get the data related to that particular id on all dates on the report, this should be done at the run time .
plz help any one
thanks ®ards
nmsreddi
Hi Reddi,
Can you please let me know how u are able to view the report on the webform. I am new into the .NET development.
Please conatct me on pjohnignatius@g mail.com
hi,
i am using crystalreports in my project(asp.net and c#.net) .i am able to display complete data from the data base on to the report .but i want to filter the data depending on particular criteria what is the procedure i have to follow.
My report contains 10 fields Id,location,mes sage,date,time, ..so on now i am able to display the complete data i.e what ever the data exist in the database irespective of date or id .now i want to filter my data depending on date or id.
for that i want to add two text boxes on my webform and two check boxes corresponding ,when ever i check the checktbox related to date text box and i enter the date then i should get data fields related to that particular date only similarly if enter id in the other text box then ishould get the data related to that particular id on all dates on the report, this should be done at the run time .
plz help any one
thanks ®ards
nmsreddi
Reddi,
Create a dataset depending on your criteria (.xsd files) and give it as the datasource of your crystal report.
Ambika Praveen.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Stephan |
last post by:
Hi,
I'm using Visual Studio 2003 (C#) with the integrated
Crystal Report software and have the following question:
How can I assign a value (string) to an unbound (string)
field in Crystal Report at runtime?
Example:
private void button1_Click(object sender,
|
by: Chris Neal |
last post by:
I recenetly purchased VB.net standard and in the box was
a card saying that it included crystal reports (as it
always used to) but I cannot find CR in the templates or
in the toolbox. Can anyone tell me where I can download
it, or how I might install it if it is already there.
Thanks
|
by: Phin |
last post by:
I need your HELP!
I've seen all the posts on using Crystal Reports within vs.net (vb.net)
and changing a SQL query at runtime. When I tried to pass in a dataset
into the crystal report at runtime, the report still showed the results
from the default query (from within the Crystal Report).
Then I tried the XSD solution where you define a dataset (that mataches
the database and the Crystal Report) and have the Crystal Report use
this....
|
by: rdshultz |
last post by:
My company is going to a new software were I have to learn Crystal
Reports. Had my first class and I'm a little confused. The
instructor said everytime you run a Crystal report you have to do a
"Refresh" if you want the most current data from the tables and that
the data stays on your computer. I want the most current data
everytime the user runs a report without having to do a "Refresh" and
I would think that all that data residing on...
|
by: Karun Karunakaran |
last post by:
Hi,
I am using the Crystal Enterprise .NET assemblies to generate and
display a crystal report in a webform. This report connects to an SQL
server (running locally) using a specific username and password. I use
the InfoStore object to query for the report from the CE server (also
running locally) and bind it to the CrystalReportViewer control in the
webform.
I am getting an "SQL Server logon failed" when I try to generate this
| |
by: LP |
last post by:
I am using (trying to) CR version XI, cascading parameters feature works it
asks user to enter params. But if page is resubmitted. It prompts for params
again. I did set ReuseParameterValuesOnRefresh="True" in a viewer, but it
still doesn't work. Did anyone run into this problem. What's the solution?
Please help.
Thank you
|
by: Ray |
last post by:
Dear all,
I have some questions about the Crystal Report and vb.net 2003.
1. I have installed the crystal report 10 and vs.net 2003. Should I
update the crystal report within the vb.net so as to use crystal report 10?
Which is better for using the program crystal report 10 or the crystal
report within the vb.net to construct the report?
2. Is there any difference for deploying the window application for
using crystal report 10 or the...
|
by: FeveZ |
last post by:
I've been stuck on a problem now for ages and i'm about ready to pack my
project in because of it lol.
OK here is my scenario.
I have an existing Crystal Report, which I have added to my solution and
published it as a webservice. This report takes it data from an SQL server on
another machine.
The user will have a windows form in a little app i'm writing where it has a
|
by: Altman |
last post by:
I am currently using ASP.Net 2003 and will be upgrading to 2005
sometime in the near future. I have been having issues with using
Crystal Reports that were included with .Net to handle my reporting
needs. I was wondering if anybody has an opinion on how the new
reportViewer control works in comparison to Crystal. One of the main
problems I have been having with Crystal Reports is that they seem to
load very slow no matter how small the...
|
by: Miro |
last post by:
Hi,
Just wondering what a good book is on visual studios 2008 ( or 2005 if no
2008 ) that teaches you how to properly use crystal reports with it.
Or im assuming that as long as I can create a dataset and link it to a
reportviewer than any Crystal Report book will do.
I use vb.net but im assuming most books would show you vb and c
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |