Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Parameter values (date) displayed in report detail Post Reply Post New Topic
<< Prev Page  of 2
Author Message
Despina
Newbie
Newbie


Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote Despina Replybullet Posted: 21 Apr 2010 at 1:40pm

Is it possible that it relates to the data type:

 
in the db the date is set to VARCHAR2 where in CR it is set to string?
If so how can I match the datatype in CR?
 
Regards,
Despina
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Apr 2010 at 3:32pm

I am at a loss as to what you really want to acccomplish here. If you were starting from scratch can you explain what you want your report to do (ignoring all the problems you have had).



Edited by DBlank - 21 Apr 2010 at 4:05pm
IP IP Logged
Despina
Newbie
Newbie


Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote Despina Replybullet Posted: 21 Apr 2010 at 4:29pm

Hello,

 
I just want to create a parameter that shows all the values in the database. 
 
 
For whatever reason some of the date values drop off when I try to create a parameter for the date in CR.
 
Regards,
Despina
 
 
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Apr 2010 at 3:44am
how many total rows of data are in your source?
If you create a dynamic param on a differnt field do all the values appear?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 22 Apr 2010 at 3:55am
I'm sorry, but I am confused.  If all you want is all the data in the database between 2 dates, why not ask for the dates.  Filling in the missing dates is the issue, but there isn't easy way to do that....Perhaps a subreport where you pass it the current record's date and the next record's date and have the subreport loop and print an empty row message of some sort.
 
in my mind, a parameter is something that you use to query a database for results...you don't need every date to that...if you do, use a calendar, same basic idea.  Now displaying all the dates in a given date range is a different requirement, but it is not a parameter of the report, it is business rule/requiremnt.
 
so, I think that DBlank's last question was the most apt.  What is the report to display and what are the questions that you asking the DB to get the data to be displayed.  (yeah, I paraphrased)
 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 20 May 2010 at 12:10am
hi,
 
you can check your regional setting in control-panel.(mm/dd/yyyy or dd/mm/yyyy).
 
 
hope it help.
Emir W
IP IP Logged
Despina
Newbie
Newbie


Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote Despina Replybullet Posted: 20 May 2010 at 11:46am

Hello

Firstly thank you to all who tried to assist, 

There was an issue with the incompatibility of the datatypes between the db and CR.   I was able to fix this by calling the db value as a string (through SQL) and then converting it back to a suitable format that appears as a date in CR

Regards,

Despina

 

 

IP IP Logged
oks911
Newbie
Newbie


Joined: 01 Jul 2010
Online Status: Offline
Posts: 7
Quote oks911 Replybullet Posted: 23 Aug 2010 at 10:32pm
I manage to solve this with Cdate.

{Table.DATE} in  CDate(Year({@StartDate}), Month({@StartDate}), day({@StartDate}))
to
CDate(Year({@EndDate}), Month({@EndDate}), day({@EndDate}))

Hope this help.
IP IP Logged
godwing
Newbie
Newbie


Joined: 13 Sep 2010
Online Status: Offline
Posts: 3
Quote godwing Replybullet Posted: 13 Sep 2010 at 4:48pm
Hi Despina,

This maybe a little bit late but you may try this..

First, try to clear the select expert.
Place the DateField in Details section

Check if the 3 dates you're looking is displayed in the screen.
if yes,

try this,

Datefield<=?Dateparameter. //note: this is just the same with Datefield>=?Dateparameter and Datefield<=?Dateparameter.


Hope it helps,
IP IP Logged
louisville2k10
Groupie
Groupie
Avatar

Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
Quote louisville2k10 Replybullet Posted: 30 Sep 2010 at 3:06am
Just curious, but why is this thread in the "tips and tricks" section? It seems like this was more of a technical question...
Thanks for your help!
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.