Hi Yudi,

In testing my app I discovered a slight problem and I am hopeful you can assist me further. It seems that I should not make the color bar content text ALL black or ALL white, I need a mixture of black OR white text depending on the color bar background color.

If some of my color bars are  dark color and the text is all black, then the text is hard to see/read. If some of my color bars are light colored and the text is all white, then the text is also hard to see/read.

My question is, is it possible to set the color bar text based on the colorbar color? For example:

___________________________

If (SubjectColor == "#800000" || SubjectColor == "#808000")

then make the text white

else

make the text black

------------------------

OR something like this?????????

If (SubjectColor == "#800000" || SubjectColor == "#808000")

then make the text white else

If (SubjectColor == "#FF0000" || SubjectColor == "#FFFF00")

make the text black

------------------------

Is this possble or am I stuck with either all black or all white color bar content text?

Please advise and best regards - Frank

Yudi,

Thank you for your reply. I will look at this next week and post back the results.

Frank

Hi Handy,

I was able to resolve my issue simply by disabling the editing feature, (had not considered that one, thanks for pointing it out!).

Thank you for all your help. Your forum support is truly top notch!

Frank

Hi Handy,

Thank you for your prompt response.

You stated:

"use dropdown only as options to change the query
We have server side selecting event in ISDataSource. I think you can interrupt and change the query based on your dropdown value in this event"

This is EXACTLY what I have been trying to do with no success! In the events table adapter it does not appear that I can use compound queries as I get an error "The Declare SQL construct or statement is not supported" so it does not allow me to utilize two different queries or sub queries in the same single query.

I am able to use query 1 by itself and set the parameter on the ISDataSource Events table fine, and I am able to use query 2 by itself and set the parameter on the ISDataSource Events table fine, however I am NOT able to add a compound query for query 1 AND query 2 without getting the above error.

I also do not see a server side selecting event in the ISDATASOURCE anywhere, I have checked from top to bottom.

Can you adivise further?

Thanks! - Frank

Hi Yudi,

I believe I have resolved the problem.

I changed the LoadOnDemandMode from TripleLoad to SingleLoad and the problem appears to be resolved.  Whether the json reference is included or not in the webconfig file, setting to SingleLoad resolves the problem.

However, I am now wondering if there will be a future or long term performance "hit" due to the setting change?

Also, the answers to your above posted questions are as follows:

1). The mode does not seem to matter, setting for timeline, day, month etc. invokes the json error in tripleload, however my default view is timeline.

2). Client and server paging are both set to True, setting them to False did not make a difference in TripleLoad.

3). Did not troubleshoot with HttpWatch.

4). There are no recurring events in my application, the tables are empty.

Please advise and thanks!

Frank