473,761 Members | 4,407 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Display data problem in Crystal Report

123 New Member
Hi,

I have passed ID from VB to crystal report 8. Value is getting passed correctly. Now I want to display records of that ID only. But I am getting all the records in Crystal Report.

What code do i need to write in Crystal Report so that it display records of passed ID only.

Kindly let me know.
Apr 18 '07 #1
2 1685
cmrhema
375 Contributor
Hi,

I have passed ID from VB to crystal report 8. Value is getting passed correctly. Now I want to display records of that ID only. But I am getting all the records in Crystal Report.

What code do i need to write in Crystal Report so that it display records of passed ID only.

Kindly let me know.
I have worked on a very old version and this was the code. Of course it may not be relevant now. But all i hope is you atleast will have a idea and you may change it to the new format
[HTML]CrystalReport1. ReportFileName = "c:\emp.rpt "
'This will open your report and emp.rpt is the name of the report
CrystalReport1. SelectionFormul a = "{employee.pin} ='" & txtEMPID.Text & "'"
'Here {employee.pin} is the field
CrystalReport1. Action = 1
'This of course will print your report
[/HTML]

Regards
cmrhema
Apr 19 '07 #2
cmrhema
375 Contributor
Look out for this link for any help in crystal reports

http://support.busines sobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf
Apr 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2624
by: mary | last post by:
I need to display 10 fields (columns) to display in a crystal Report. When I am trying to print the report some of the columns are cutting off from the report. Is there any way to display the report horizontally. I am using Crystal Report 9. Please some body help me Thanks mary
1
2783
by: JK | last post by:
In my win form, I'm trying to display a Crystal report with the data in my dataset only but, if I follow the steps in this msdn page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crtsksettingupanado.netreportinaviewer.asp it always displays all the data regardless of the Select statement I run. Here's my code: InitializeComponent(); //my code
2
3147
by: Delali Dzirasa | last post by:
I am a newbie and am creating my first asp.net in crystal reports. I have created the report (.rpt file) and have dropped the CrystalReportViewer on the web form. From the databinding properties I have set the ReportSource to the path of the report file......this cause the report viewer to display the data. Problem is on the form at (design time "and" run time) none of the standard
3
5244
by: Diggler | last post by:
I was working on a report that is populated with three different tables in a strongly-typed dataset. The tables are populated from custom objects rather than directly from SQL Server. I loop through the objects and add the rows one at a time. I then push the dataset to the Crystal Report. The report worked fine, until this morning. I added another field or two to the dataset, and rearranged the report fields to organize the report...
0
7451
by: Jeff | last post by:
Help!!! The bitmap I am trying to display in a sample Crystal Report is coming up with much less quality than the original bitmap. I have a 300x300 dpi bitmap file that I want to insert at run time into a Crystal Report. The path to the file is stored in a varchar(100) field in a table in SQL Server. The Crystal Report displays the bitmap in the IBlobField object but it
8
10506
by: rzaleski | last post by:
I am trying to display a Crystal Report in an application I developed. I used the following tools: Microsoft Visual Studio.NET 2005 Standard Crystal Reports 10 Professional I am using the Crystal ActiveX Report Viewer Control 10.0 to display the report. It displays fine on my computer, but does not work on the client computer. I have copied the following dlls to the client computer:
1
2195
by: mike11d11 | last post by:
For some reason I'm getting no data populating in my crystal report. I built my crystal report off my dataset in my project, and I fill the dataset when opening the main form, and count the records just to make sure there is data in the dataset, and then open the form containing my reportviewer control with the crystal report added to it and it still shows no data when it opens. I built my crystal report off the wizard when right...
1
2426
by: Gurunadh | last post by:
Hi friends, we have developed a windows desktop application in vb.net 2005 with MS-Access as backend ,our problem is we have to display data from a datagridview to a crystal report,we have written the code to display in crystal reports it is working in the system in which we developed but when the setup is installed in another computer it is displaying database login screen asking for login id and password,can any one know what is the...
2
2216
by: weird0 | last post by:
I am trying to display a crystal report in .aspx page. I created a dataset for that but i wrote the query: SELECT atm_amount,atm_branch,atm_date,balance FROM ATM_Transactions WHERE user_id=Session.ToCharArray() But this query does not work.... I dont have much knowledge how to maintain sessions.
0
9345
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10115
Oralloy
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...
1
9905
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,...
0
9775
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8780
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7332
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6609
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();...
3
3456
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2752
bsmnconsultancy
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...

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.