Date in RTC

Troubles_In_Paradise · 2011-04-21

Hi guys!
In a custom page I created an action that launches a Classic report.
But it gives me this error.

Since this error appears before showing the request form I think that the RTC doesn't like function I call in the trigger OnOpenForm().

IF VarBoolean THEN BEGIN
   VarDate := 0D;
   RequestOptionsForm.TextBoxValidityDate.ENABLED := FALSE;
END ELSE
   RequestOptionsForm.TextBoxValidityDate.ENABLED := TRUE;

I'm wondering if it's different the value of 0D in RTC :-k
could anyone give me a suggestion?
Thx in advance!

mohana_cse06 · 2011-04-21

Are you sure that you are getting error at vardate := 0D;?
why because, in the error it is showing different date.. :-k

BTW, did you try with Format(Date)?

Troubles_In_Paradise · 2011-04-21

mohana_cse06 wrote:

Are you sure that you are getting error at vardate := 0D;?
why because, in the error it is showing different date.. :-k

BTW, did you try with Format(Date)?

I'm not sure... but It's the only code that could be executed because the error comes before the request form

mohana_cse06 · 2011-04-21

Identify the place where exactly is coming and you can use Format(Date)

Troubles_In_Paradise · 2011-04-21

mohana_cse06 wrote:

Identify the place where exactly is coming and you can use Format(Date)

ok Mohana I'll use my dear friend Debugger.
Thx for help!

Troubles_In_Paradise · 2011-04-21

In order to find the error I placed a simple message in the trigger OnInit() of Request form.
The message isn't showed because error comes before...
](*,) the date showed in the error is my working date. I changed it many times but nothing changed...

mohana_cse06 · 2011-04-21

In the begining of the OnOpen form, try by adding Format(Workdate)

mihail_kolev · 2011-04-21

is the request form enabled for the report?

Troubles_In_Paradise · 2011-04-21

mohana_cse06 wrote:

In the begining of the OnOpen form, try by adding Format(Workdate)

but to what I assign the return value?

Troubles_In_Paradise · 2011-04-21

mihail_kolev wrote:

is the request form enabled for the report?

yes yes. because if I launch report from Classic Client works as expected.

mihail_kolev · 2011-04-21

then put debug messages in the request PAGE

Troubles_In_Paradise · 2011-04-21

mihail_kolev wrote:

then put debug messages in the request PAGE

I don't have a request page...

mihail_kolev · 2011-04-21

Am I missing something... You use the report in RTC with or without layout? If you have layout, then the request form will never show, you should create request page.

EDIT Ooops, sorry, i missed that. You launch classic report in rtc...

mohana_cse06 · 2011-04-21

You can assign it to a new varialbe or VarDate

From where you are getting VARBoolean and VarDate?

Troubles_In_Paradise · 2011-04-21

mihail_kolev wrote:

Am I missing something... You use the report in RTC with or without layout? If you have layout, then the request form will never show, you should create request page.

I launch it from RTC but it hasn't RDLC. if I'm not wrong... if report has no Layout designed, also if I launch it from RTC, will be launched 2 tier report, isn't it?

mohana_cse06 · 2011-04-21

Troubles In Paradise wrote:

mihail_kolev wrote:

Am I missing something... You use the report in RTC with or without layout? If you have layout, then the request form will never show, you should create request page.

I launch it from RTC but it hasn't RDLC. if I'm not wrong... if report has no Layout designed, also if I launch it from RTC, will be launched 2 tier report, isn't it?

Yes, you are 100% right..

mihail_kolev · 2011-04-21

Troubles In Paradise wrote:

mihail_kolev wrote:

Am I missing something... You use the report in RTC with or without layout? If you have layout, then the request form will never show, you should create request page.

I launch it from RTC but it hasn't RDLC. if I'm not wrong... if report has no Layout designed, also if I launch it from RTC, will be launched 2 tier report, isn't it?

Yes, excuse me, missed some text (I need some sleep I guess). :oops:

Troubles_In_Paradise · 2011-04-21

mihail_kolev wrote:

Troubles In Paradise wrote:

mihail_kolev wrote:

Am I missing something... You use the report in RTC with or without layout? If you have layout, then the request form will never show, you should create request page.

I launch it from RTC but it hasn't RDLC. if I'm not wrong... if report has no Layout designed, also if I launch it from RTC, will be launched 2 tier report, isn't it?

Yes, excuse me, missed some text (I need some sleep I guess). :oops:

no problem Mihail

Thank you Mihail and thank you Mohana for help you're giving me.

mohana_cse06 · 2011-04-21

From where you are getting VARBoolean and VarDate?

Is something else executed before this code

Troubles_In_Paradise · 2011-04-21

mohana_cse06 wrote:

From where you are getting VARBoolean and VarDate?

Is something else executed before this code

They're 2 fields of request form.
edit: no there's nothing before this code.

mihail_kolev · 2011-04-21

And are you sure you are connecting to the correct database - you say that the report works from classic client, but the error on the screenshot is from classic client instance. So I guess you might connect to the wrong database...

Troubles_In_Paradise · 2011-04-21

mihail_kolev wrote:

And are you sure you are connecting to the correct database - you say that the report works from classic client, but the error on the screenshot is from classic client instance. So I guess you might connect to the wrong database...

Checked... It's the right DB

mohana_cse06 · 2011-04-21

Troubles In Paradise wrote:

mohana_cse06 wrote:

From where you are getting VARBoolean and VarDate?

Is something else executed before this code

They're 2 fields of request form.
edit: no there's nothing before this code.

Then you should have added your code in OnPre Report trigger

Otherwise everytime your else part code will be executed..

st0328 · 2011-04-21

Troubles In Paradise wrote:

In order to find the error I placed a simple message in the trigger OnInit() of Request form.
The message isn't showed because error comes before...
](*,) the date showed in the error is my working date. I changed it many times but nothing changed...

how u r calling u r report. Either by Code Or Proporty..

Try to keep a message on Report - OnInitReport()..

and run the report again.. Once..

Troubles_In_Paradise · 2011-04-21

st0328 wrote:

Troubles In Paradise wrote:

In order to find the error I placed a simple message in the trigger OnInit() of Request form.
The message isn't showed because error comes before...
](*,) the date showed in the error is my working date. I changed it many times but nothing changed...

how u r calling u r report. Either by Code Or Proporty..

Try to keep a message on Report - OnInitReport()..

and run the report again.. Once..

already done! the error comes before

Troubles_In_Paradise · 2011-04-21

mohana_cse06 wrote:

Troubles In Paradise wrote:

mohana_cse06 wrote:

From where you are getting VARBoolean and VarDate?

Is something else executed before this code

They're 2 fields of request form.
edit: no there's nothing before this code.

Then you should have added your code in OnPre Report trigger

Otherwise everytime your else part code will be executed..

you're right! I miss an information! before executing this code I put the variable to true and then I execute that code.
that code is called again on the trigger OnValidate() of that VarBoolean.

mihail_kolev · 2011-04-21

something about the Windows Regional settings - the date format

mohana_cse06 · 2011-04-21

If you can, export the report in text format and paste here

Belias · 2011-04-21

Hi guys,
we (me, my colleague Troubles in Paradise and another colleague of mine) have solved the problem:
The installed CLIENT version was 32275, but the SERVER version was 32012.
If i remember well, some hotfix between these versions have fixed something about the date/time zones or something similar, and i guess that this could have generated the problem because of the different date/time management.
Thanks everyone for your effort, it is really appreciated :thumbsup:

Troubles_In_Paradise · 2011-04-21

Thx again for help!

I can put "Solved" on this topic

Howdy, Stranger!

Quick Links

Categories

Date in RTC

Answers