| Author |
Message |
Despina
Newbie
Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
|
   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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
Despina
Newbie
Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
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 Logged |
|
Emir_W
Senior Member
Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
|
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 Logged |
|
Despina
Newbie
Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
|
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 Logged |
|
oks911
Newbie
Joined: 01 Jul 2010
Online Status: Offline
Posts: 7
|
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 Logged |
|
godwing
Newbie
Joined: 13 Sep 2010
Online Status: Offline
Posts: 3
|
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 Logged |
|
louisville2k10
Groupie
Joined: 13 Sep 2010
Location: United States
Online Status: Offline
Posts: 45
|
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 Logged |
|
|
|
