473,386 Members | 2,129 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How can I pass Date-Range to crystal reports in vb.net

106 100+
I have created Crystal Report to display data between two dates.
From a vb Form, I need to pass the m_minDate and m_maxDate as the date range to Parameter 'MyDateRange'. I am struggling to know how to do this.

I have tried to search on ParameterRnageValues, but struggling to understand.


For another report, I can pass single values with the code:
Expand|Select|Wrap|Line Numbers
  1. Dim rptViewer As New rptNamazTime
  2.  
  3. rptViewer.DataSourceConnections.Clear()
  4. rptViewer.DataSourceConnections.Item(0).SetConnection("server", "dbname", False)
  5.  
  6. ' Set Database Logon Details 
  7. rptViewer.SetDatabaseLogon("login", "password", "server", "dbname")
  8. rptViewer.SetParameterValue("SelectMonth", m_theMonth)
  9. crvNamazTime.ReportSource = rptViewer
  10.  
May 9 '15 #1
0 1715

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

Similar topics

3
by: oscar | last post by:
is there a way of integrating mysql databases into the .net crystal reports? in the report wizard i have options for sql databases, but nothing for mysql. is there a plugin i'm missing for it? ...
3
by: Gheaci Maschl | last post by:
Hi all! I would like to have your opinion about my problem and my proposal how to solve it: Ingredients: - BTriev database - Crystal Reports - maybe MS Access - Liinos6 (small ERP software)
10
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
4
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,...
17
by: Peter Proost | last post by:
Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're...
2
by: matt | last post by:
hello, i have an .RPT file that i am using to load a report via the ASP.NET CrystalReportViewer control. i dont include my .RPTs as embedded resources...instead i load the absolute path of the...
1
by: dhavalmajmundar | last post by:
Hi, I am passing the value of the Multiline Text Box from VB to Crystal. Everything was ok until the User Pressed the Enter Key to separate the line in the Multiline Textbox, Pressing Enter causes...
4
by: Rodo | last post by:
Hi all, I'm new to this whole thing. I have a bunch of text files that are created by a software at work that keeps info one of our products. Each unit being calibrated gets a "record" (track by...
2
by: Simone | last post by:
Hello I am new to this :) I have created a crystal reports and tried using the Crystal Report Viewer but when I try to preview the report it prompts me for a user name and password. I am using...
1
by: jackmay | last post by:
I have a number of Crystal Reports that I am exporting to text in vb.net. It exports just fine, but all as one page - there are no page breaks or page headings. I can change this by changing...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...

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.