crystal report in a range of time

how can i display information in a crystal report from a range of time chosen by the user by DTpickers using VB .NET??
memozebaduaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ast2550Commented:
Pass the date/time into crystal using a parameter
0
memozebaduaAuthor Commented:
can u be a little more specific? i'm a newbie...

thanks!
0
ast2550Commented:
Create a parameter field in your report and use it in the Select Expert.  When you refresh your report, it will require the parameter.

Pass the parameter using VB.  I'll be happy to look up a good parameter tutorial when you get your report working.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

memozebaduaAuthor Commented:
how do i create the parameter field??

sorry! i do not know much... i already have my reports running, the only thing i'm missing is that the dat displayed is from the range picked in the dtp
0
ast2550Commented:
Depending on version,
View | Field Explorer
Right click on Parameter Fields
Select New
Name = StartTime
Type = Time

Repeat
Name = EndTime
Type = Time (hh:mm:ss)

***************************************

Then restrict report as per your parameter fields:
Report | Select Expert
{Table.Field} in {@StartDate} to {@EndDate}
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Parameters are named with a ?  @ is for formulas.

{Table.Field} in {?StartDate} to {?EndDate}

Also if your date field is really a date time field you may have to enter the above in the formula editor mode rather than in the report expert.

mlmcc
0
ast2550Commented:
oops.  thanks.

Now, that I look it over.  I suggested that you use a Time parameter and then had you call it StartDate (sloppy).  We should probably clarify this.  Is it a date/time or just a time field as stated in your initial question?
0
memozebaduaAuthor Commented:
OK,

I have

- a form with a button (which shows the form with the crystal report viewer) and two date pickers to select the range of dates fr the report

And a form with a report viewer only...

i understood the part where i have to add the parameters to the selection But i don't know how to get the data from the dtp into those parameters and if i'm supposed to do it in the initial or the report form

in answer to your question... i'm only interested in the date
0
mlmccCommented:
Glad i could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.