anyone know how to Filter Reports by...

[fantasy2ville]

a certain period of time or date? I have a database of trainings conducted and I want to show a report depending on the dates given from the date and time picker control of vb.net... for example I want to view all the trainings conducted from this date up to this date

can anyone help me please? im not really a pro in crystal reports, this would be the last module in my project. thanks in advance to those who will help.

[sayyedar]

yes just add a parameter as ReportDate and set the default value to the column from the database
You will have to make the parameter filed ReportDate as RangeValue since it will take twoo dates


and then add it in the record selection
the formula
would look like :
{?ReportDate} = {DatabseName.ColumnName}


If your are using a query to make the report then add the parameter
{?ReportDate} in place of FromDate(the date value) and ToDate(the date Value)

Hope this solves ur problem

[fantasy2ville]

uhhh..... i think that would be helpful... i just dont know where to add that parameter... can you discuss it more on a beginner's perspective? because im just a self study on this stuff... please? thanks again

[sayyedar]

About adding parameter..
Just click on the ReportExplorer available in the toolbar.
On clicking you will get various options int eh report explorer like..
Formula fileds,SqlExpression etc.
Here u will also find a Parameter option just right click on it and add a new parameter .
When u add a parameter it will ask u the kind of parameter to be added
like Date, DateTime,Number,string,Time etc. Choose the appropriate type
Thats all....
hope this helps

[fantasy2ville]

ehehehe... thanks i already know that... what i wanna know is how am i gonna use this code:

and then add it in the record selection
the formula
would look like :
{?ReportDate} = {DatabseName.ColumnName}


If your are using a query to make the report then add the parameter
{?ReportDate} in place of FromDate(the date value) and ToDate(the date Value)

Hope this solves ur problem

like where am i gonna put this? im currently using a group selection formula in vb 2005 express but parameters doesnt seem to work in this matter, please excuse me if I'm being annoying or something but... you know beginners

but its ok if you dont wanna answer it anymore... i understand... but i'd really appreciate it if you'd give me some more briefing about this matter... thanks again...

[sayyedar]

i dont get u ?
do u want to add teh parameter in winforms or crystal report
What i wrote was for crystal Reports DEsigner....

[fantasy2ville]

uuuhhh... i wanted to put the code on visual basic forms...
ok how about this... how can i filter reports that will display weekly stuff? can i use the group selection formula instead?

[sayyedar]

yes u can group by date and in the options available for the group u can set it daily, weekly ,etc... but this u can do in crystal report designer.
i mean u have to group in Crystal Report..