[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

Date ranges in crystal reports

Hi,

  I would like to know if is there any body outside that knows how to insert a VB 5.0 Date variable into a report in crystal report 5.0.

   Example.

   I have a Variable called IniDate defined as date and taking a value from keyboard, how ca i do to insert IniDate into my report.

Thanks
0
Alfredo Luis Torres Serrano
Asked:
Alfredo Luis Torres Serrano
  • 3
  • 2
1 Solution
 
VoodoomanCommented:
I'm not to clear what you are trying to do here as I use newer versions of CR.

In newer versions you can create a parameter field within the developer.

You can then post the value to the parameter using Report.Parameters(0)=mydate.

If Ver 5 does not have a Parameter Field the only thing you can do is replace the report title and append the date to it i.e. Report.Reporttitle=Report.ReportTitle & " " format$(mydate,"mm/dd/yy") or whatever date format you want


Voodooman


0
 
Alfredo Luis Torres SerranoDevelopment Director / DBAAuthor Commented:
My crystal report version does not have report.reporttitle propertie, can i download a newer version?, where?
0
 
AshokKumarCommented:
Create a formula in Report (say datVBDate) and place it whereever u need the date to be displayed. After getting the value for the iniDate in VB just pass this value to the formula.
Pass it like this

Crystalreport1.formulas(0)='" datVBDate= "' & iniDate

Thus, your formula now will contain the value of iniDate abd will be displayed in the report. Take care for the slightest syntax errors. Otherwise, positively this is the solution. We have done this all the time. Get back to me.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Alfredo Luis Torres SerranoDevelopment Director / DBAAuthor Commented:
That's the right answer thanks
0
 
AshokKumarCommented:
Wecome Masterco. Just between pals.
0
 
Alfredo Luis Torres SerranoDevelopment Director / DBAAuthor Commented:
I am gettin a Invalid Formula Name Error What i am doing Wrong?
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now