[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • 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 SerranoAuthor 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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