473,402 Members | 2,055 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,402 software developers and data experts.

Help in crystal report

284 100+
i am using vb6 and crystal report 10

i want to ask solution of one proble which i am facing in making report.

first , in my programe i ask the user to give paramerter (range) of the data
(dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

now when user gives paramerter it show the result . the result are perfect
the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

now , how can i get data (dates ) from the form and put it on crystal report page header section

as bytes does not support much pictures to explian our question clearly
i had also make a post on
http://www.dreamincode.net/forums/in...howtopic=50853

see this where i uploaded pictues to expliain my question more clearly.

can any body help me to solve this/
May 2 '08 #1
3 1847
Dököll
2,364 Expert 2GB
i am using vb6 and crystal report 10

i want to ask solution of one proble which i am facing in making report.

first , in my programe i ask the user to give paramerter (range) of the data
(dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

now when user gives paramerter it show the result . the result are perfect
the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

now , how can i get data (dates ) from the form and put it on crystal report page header section

as bytes does not support much pictures to explian our question clearly
i had also make a post on
http://www.dreamincode.net/forums/in...howtopic=50853

see this where i uploaded pictues to expliain my question more clearly.

can any body help me to solve this/
Hello muddasirmunir!

Sorry for your troubles! Might do us a lot of good though if you could simply copy what you posted to the other forum to ours just in case one of us is passing through and has an idea.

Please copy at least the portion you are having issues with, rest assured you can keep asing questions, all in all to get added hits on your question.

Thank you, muddasirmunir! In a bit;-)
May 3 '08 #2
Report.repDate.setText formName.txtDate
May 3 '08 #3
Jyo72
3
Hi,

Why don't you create 2 parameters in crystal report as FromDate & Todate.
you cna pass the values from VB to crystal report these parameters.
ex:
'Global Variable Crystal Report Application
Public CRApp As CRAXDRT.Application

Set CRApp = New CRAXDRT.Application
CRApp.LogOnServer "P2SODBC.DLL", "Servername", "DBname", LoginName, Password


Dim Rpt As CRAXDRT.Report
Dim m_Rptname as string
m_rptname = "C:\test1.rpt"

Screen.MousePointer = vbHourglass

Set Rpt = CRApp.OpenReport(m_RptName, CRNOTEXCLUSIVE)
If Rpt.HasSavedData Then Rpt.DiscardSavedData

If Rpt.ParameterFields(1).IsCurrentValueSet Then Rpt.ParameterFields(1).ClearCurrentValueAndRange
Rpt.ParameterFields(1).AddCurrentValue DateFrom
If Rpt.ParameterFields(2).IsCurrentValueSet Then Rpt.ParameterFields(2).ClearCurrentValueAndRange
Rpt.ParameterFields(2).AddCurrentValue DateTo


...... in crystal report create a header in Page header section using of this parameters from the report.

... Please try this and let me know if any issue is there.

All the best.





i am using vb6 and crystal report 10

i want to ask solution of one proble which i am facing in making report.

first , in my programe i ask the user to give paramerter (range) of the data
(dates for e-g 01-apr-2008 to 03-apr-2008) for which i uses a form.

now when user gives paramerter it show the result . the result are perfect
the only thing i nedd is to display the parameter (dates for e-g 01-apr-2008 to 03-apr-2008) at the page header of the each page of report.

now , how can i get data (dates ) from the form and put it on crystal report page header section

as bytes does not support much pictures to explian our question clearly
i had also make a post on
http://www.dreamincode.net/forums/in...howtopic=50853

see this where i uploaded pictues to expliain my question more clearly.

can any body help me to solve this/
May 5 '08 #4

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

Similar topics

4
by: Mike | last post by:
Hello All, I'm trying to deploy my windows-based application using crystal report. i package the setup by including the crystal report file, the exe file, and two merge modules for the crystal...
2
by: Shelly | last post by:
Hi all The Problem which i am facing with CrystalReport 8.0 is, this reports are connected to the server thru ODBC. and whenever if i am changing the ODBC Name and Server name . Next time if i...
7
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...
3
by: Deasun | last post by:
I need some help please! Crystal is driving me nuts. Heres my code so far, see below. Problem: On the .export() line it comes back with error #5 Login failed! I know the login info is good so...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
1
by: RJN | last post by:
Hi I'm new to VS.Net Crystal Report. I'm using data sets as the source for crystal report. I've a dataset which has 2 data tables. The first table's schema is like this Ptid String Prid...
3
by: Adriano | last post by:
Hello, when I try to print something, either DataGrid or from Crystal Report viever the folowing error message appears and cancels printing: Object reference not set to an instance of an...
1
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...
3
by: ranesmitas | last post by:
hello, i using vb 6 and i did report seagate crystal report . i want to know how it use in vb . i did some code but it not display anything code is Public strReportPath As String Public...
3
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...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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...
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...
0
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...
0
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,...

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.