Chris T.
|
| Posted: 02/14/2006, 9:49 AM |
|
I figured out how to search between two dates (a date range) and use that for a report. Now I don't know how to display these dates in the header of the report.
I want it to read: [start date] TO [end date] at the top of the report, but I don't know how to pass these parameters to a label or textbox within the report.
They originate in a search dialog box. After choosing your date range, you hit the submit button and then it brings up the report. I know these are URL parameters, but I can't figure out how to print them onto the report.
|
|
|
 |
Walter Kempees
|
| Posted: 02/14/2006, 11:50 AM |
|
Create the labels on the report
for each label's Before Show add
$Component->SetValue(CCGetfromGet(your parameter name, default));
(Without trying, just folowwing CCS logic)
<ChrisT.@forum.codecharge (Chris T.)> schreef in bericht
news:643f21843dd4c7@news.codecharge.com...
>I figured out how to search between two dates (a date range) and use that
>for a
> report. Now I don't know how to display these dates in the header of the
> report.
>
> I want it to read: [start date] TO [end date] at the top of the report,
> but
> I don't know how to pass these parameters to a label or textbox within the
> report.
>
> They originate in a search dialog box. After choosing your date range,
> you hit
> the submit button and then it brings up the report. I know these are URL
> parameters, but I can't figure out how to print them onto the report.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Chris T.
|
| Posted: 02/14/2006, 12:14 PM |
|
that gave me a "invalid character" error.
"s_Date_Issued" and "s_Ap_Date are my two parameters"
so I typed (in each of their respective BeforeShow events):
$Component->SetValue(CCGetfromGet(s_Date_Issued, default));
$Component->SetValue(CCGetfromGet(s_Ap_Date, default));
Sounds like that would be on the right track...thanks for helping. Walter
|
|
|
|
Chris T.
|
| Posted: 02/14/2006, 12:21 PM |
|
I'm thinking your code has some php in it.
|
|
|
|
Walter Kempees
|
| Posted: 02/14/2006, 12:33 PM |
|
Yes it has and where I put the word "default" you have to substitute the
default value not the literal word 
But if you look up the ASP CCGetFromGet, you will Get it from there.
Go on you're close
<ChrisT.@forum.codecharge (Chris T.)> schreef in bericht
news:643f23baf8a4ac@news.codecharge.com...
> I'm thinking your code has some php in it.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Chris T.
|
| Posted: 02/15/2006, 8:30 AM |
|
Here's my ASP code:
Permit.ReportLabel1.Value=(CCGetfromGet(PermitSearch.s_Date_Issued,empty))
Permit.ReportLabel2.Value=(CCGetfromGet(PermitSearch.s_Ap_Date,empty))
(below not part of code)
Permit = Report form
PermitSearch = search form
s_Date_Issued = parameter that I'm getting start date from
s_Ap_Date = parameter I'm getting end date from
Running the report gives me the correct report output. But the labels aren't showing the date ranges.
I'll keep playing with it.
|
|
|
|
Chris T.
|
| Posted: 02/15/2006, 8:37 AM |
|
Walter, I got it! You lead me down the right path.... you da man! I just had to look at the help file examples a little more clearly and noticed I was missing some quotations marks and here is my final code:
Permit.ReportLabel1.Value=(CCGetfromGet("s_Date_Issued",empty))
Permit.ReportLabel2.Value=(CCGetfromGet("s_Ap_Date",empty))
Thanks again for your help!
|
|
|
|
Walter Kempees
|
| Posted: 02/15/2006, 9:08 AM |
|
I'm da'man ??
Urdaman, your selfsufficient, a selfhelper, a hint-taker.
Well done!
Walter
<ChrisT.@forum.codecharge (Chris T.)> schreef in bericht
news:643f358e7c9c12@news.codecharge.com...
> Walter, I got it! You lead me down the right path.... you da man! I just
> had
> to look at the help file examples a little more clearly and noticed I was
> missing some quotations marks and here is my final code:
>
> Permit.ReportLabel1.Value=(CCGetfromGet("s_Date_Issued",empty))
>
> Permit.ReportLabel2.Value=(CCGetfromGet("s_Ap_Date",empty))
>
> Thanks again for your help!
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
