473,586 Members | 2,870 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB6 & Crystal Report v10 Coding

2 New Member
I am using VB 6 and Crystal report v10.

I have a field that is the type of training session a student does, i.e. "Beach Training".

I want to retrieve all the sessions from a given date i.e. "Last Grading date" The code, in VB6, is not working any help much appreciated.

Below is the code I am using:

myReport.Record SelectionFormul a = "{qry_ATTENDANC E.SESSION}= '" & frm_CryReports. dbc_FillMembers .Text & "' and " & " > {qry_Attendance .Last Grading Date} & "
Nov 7 '08 #1
2 1613
rpicilli
77 New Member
HI,

I'm not a speciallist in Crystal Report but in your query, looks a like that is missing a simple quote on last parameters.

Expand|Select|Wrap|Line Numbers
  1. myReport.RecordSelectionFormula = "{qry_ATTENDANCE.SESSION}= '" & frm_CryReports.dbc_FillMembers.Text & "' and "' & " > {qry_Attendance.Last Grading Date} & '"
  2.  
Try this and let me know if work out.

RPicilli
Nov 7 '08 #2
mickofgoju
2 New Member
HI,

I'm not a speciallist in Crystal Report but in your query, looks a like that is missing a simple quote on last parameters.

Expand|Select|Wrap|Line Numbers
  1. myReport.RecordSelectionFormula = "{qry_ATTENDANCE.SESSION}= '" & frm_CryReports.dbc_FillMembers.Text & "' and "' & " > {qry_Attendance.Last Grading Date} & '"
  2.  
Try this and let me know if work out.

RPicilli
Hi RPicilli

Thanks for your suggested code. Unfortunately not working but it does not give me the same error so its on the right track.
I may need to look at formatting the date field.
Again thanks for your help

Mick
Nov 13 '08 #3

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

Similar topics

0
3780
by: BATISTA | last post by:
Hi , I am working in c# with crystal report XI. I read an example about dynamic image location .. 1) In that we have a xml xchema file with two fields n amed country--datatype is string, img--datatype is base64Binary. using this as the datasource,i have designed the crytal report. And a parameter is set asking for the name. 2) I have...
3
1868
by: Eric Clapton | last post by:
Hi, How do you put the Crystal Report inside Visual Basic coding?
3
11000
by: route_coder | last post by:
I am using access database to create a crystal report in VB.NET Everything works fine when I run on my machine. But when I am deploying it other windows machines. It is asking for database server name and logon information. The problem which I understood from this is that the path is hardcoded in the crystal report and the database is in my...
0
1217
by: John Kastrinos | last post by:
Yes, I know this is more of a Crystal group question. I posted there about 2 weeks ago, but no one EVER replies over there. So, I thought I would take a shot here. If anyone has heard of this, please let me know: I have a VB.NET NT service that: creates a Crystal report object, loads report, connects report to Informix database, and...
3
1846
by: Trichy | last post by:
Hi Can any one help me. I added crystal report item to my project .net. After connecting to database , i inserted three columns from table. I ran report in ..net is working fine. My problem, I want to add fouth column from DB to my report. My field viewer is disable, I cann't insert columns from table. Can any one help me to enable...
0
2261
by: Chris | last post by:
I have the following situation in a VB.Net App I am working on: 1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003. 2.)The datasource for the report is a Stored Proc in a SQL Server DB (pull method). 3.)The Stored Proc has two input parameters of type date. 4.)The Stored Proc is a rather complex proc that was not...
1
1897
by: riyaz | last post by:
i am new to .net environment, anyone can advise me how to create a crystal report ,how to connect to databse and to display in web page .As i m developing asp.net based web application i want to put the report in web. plz adcise me regards
0
2501
by: YellowFin Announcements | last post by:
Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses is because most of the tools...
0
1011
by: piyumi80 | last post by:
I'm generating some reports using Crystal Report Access Database.Ican give the database path through the Crystal Report.But I need to give a database path to the crystal report through the Vb.Net coding.Can u pl send me some samplel coding to this. Thank you.
0
7911
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
7839
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
8338
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
8215
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
6610
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...
1
5710
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...
0
5390
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...
1
1448
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1179
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...

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.