Showing posts with label app. Show all posts
Showing posts with label app. Show all posts

Sunday, March 11, 2012

Controlling Crystal Reports 9.0 Grids with VB

Hello,
I'm new to Crystal reports and am finishing up my first vb app. I need to be able to control the "Draw Custom Line" property of the Crystal Reports grid within VB 6.0. Does anyone know the Grid property I use in VB to control this?
Thanks so much!
Tricia =)aha! After a full day of searching for the answer, I think I found a comparable solution to this problem. =)

Solution: Split Dual Axis Grid
- Bottom axis range from x to alert level
- Upper axis range from alert level to x

Pros:
- The alert level line can be placed on the grid and it can be a variable amount calculated in VB so that we can normalize the data appropriately.

Cons:
- the grid must have 2 data points in order to have the split axis option available. The problem with this is that we need to show the marker for each point in the event of a first time sampling and only one level to show on the grid. I am using the alert level for the second data point and so the markers are showing only the alert level line, but it still looks a bit funky, but at least I have the line!!!

Friday, February 24, 2012

Contains ..

hi,
what is the diff. between contains(myfield, ' "the app" ') and
contains(myfield, ' "the app*" ')?
i still dunno what is the diff.
Thanks
Q wrote on Fri, 13 May 2005 17:04:43 +0800:

> hi,
> what is the diff. between contains(myfield, ' "the app" ') and
> contains(myfield, ' "the app*" ')?
> i still dunno what is the diff.
The * is treated as a wildcard when used inside the quotation marks. For
example, the 2nd version will find
the apple
as a phrase in the fts index, but the first version won't as app is treated
as a whole word.
Dan
|||Just to piggy back on Dan's remarks. The wildcard applies to each token in
the search phrase, so not only would it find "the apple", but it would also
find "theta apple" - assuming the is not in your noise word list.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:%23$C5rT7VFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Q wrote on Fri, 13 May 2005 17:04:43 +0800:
>
> The * is treated as a wildcard when used inside the quotation marks. For
> example, the 2nd version will find
> the apple
> as a phrase in the fts index, but the first version won't as app is
treated
> as a whole word.
> Dan
>
|||Hilary wrote on Fri, 13 May 2005 09:58:49 -0400:

> Just to piggy back on Dan's remarks. The wildcard applies to each token in
> the search phrase, so not only would it find "the apple", but it would
> also find "theta apple" - assuming the is not in your noise word list.
I missed that bit, thanks Hilary. Something for me to consider in my next
look at optimising my search code ...
Dan
|||ok, thanks!
"Daniel Crichton" <msnews@.worldofspack.co.uk> glsD:eP%23J%23c8VFHA.3424@.TK2MSFTNGP09.p hx.gbl...
> Hilary wrote on Fri, 13 May 2005 09:58:49 -0400:
>
> I missed that bit, thanks Hilary. Something for me to consider in my next
> look at optimising my search code ...
> Dan
>