Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Solojer

    How to evaluate one line of a memo field

    Sure.. It's in field that contains the text of an e-mail. I need to identify those e-mails that have the text "***Please reply within five days***" in the subject field of the e-mail. I need to exclude replies sent to this original e-mail, which is why it's important to ensure the string...
  2. Solojer

    How to evaluate one line of a memo field

    Sorry about that.. obviously more detail would be helpful. The memo field is varchar(max). SQL Server 2005. Thanks :)
  3. Solojer

    How to evaluate one line of a memo field

    Hi there! I need to select records based on a value in the 4th or 5th line of a memo field. Could someone suggest an easy way to do this? Thanks!
  4. Solojer

    add hyperlink to cross tab

    I'm using Crystal XI and am trying to add a hyperlink to a cross-tab report (one link for each group by) and am having some difficulties -- I right clicked on the field and added the field to the "hyperlink" tab, but the same link is now appearing for each group, and not changing dynamically to...
  5. Solojer

    Show blank value in a report

    I was able to figure this out by adding a subreport in the @longsub section. Thanks for all your help :)
  6. Solojer

    Show blank value in a report

    Hi Ian, I added an extra condition to @longsub and in fact all the "group by" fields, and still nothing, unfortunately.
  7. Solojer

    Show blank value in a report

    Hi there! I'm trying to use Crystal to automate the building of an HTML table, and am running into a bit of a problem: They way I understand HTML tables to work, is that every cell must have a value (even if the value is s space). Otherwise, the remaining cells will be shifter to the left...
  8. Solojer

    Replace multiple values with others in a string.

    And Ian too. Sorry Ian, didn't mean to slight you ;)
  9. Solojer

    Replace multiple values with others in a string.

    Thanks to both Mike and Pete I was able to get this working the way I needed!! :)
  10. Solojer

    Replace multiple values with others in a string.

    Thanks for your suggestion, Mike. I mentioned a few posts up that ultimately, I need the final PX value to be the count in GF2*(200/MAX incident count for any GF2). So, the *5 was simply a placeholder for whatever the value of 200/MAX of any GF2. My problem is, I'm building the original...
  11. Solojer

    Replace multiple values with others in a string.

    Since the text for all the bar colours is stored all together in one global stringvar (bar), how would I use your @replace function to change all the values at once?
  12. Solojer

    Replace multiple values with others in a string.

    Thanks Ian; I'm still not sure I fully understand :( The string '<li class="bar1 purplebar" style="height: 60px;">12 </li>' is in 1 field with many other similar strings (redbar, bluebar, etc, all combined in one string). In GF2, how would I specify for which part of the string the...
  13. Solojer

    Replace multiple values with others in a string.

    ...text in @GF1, like this.. //@GF1 whileprintingrecords; global stringvar bar; bar Ultimately, I need the final PX value to be the count in GF2*(200/max incident count for any GF2). The more I think about it, an array seems the best way to go, but i'm really not sure where/how to implement...
  14. Solojer

    Replace multiple values with others in a string.

    I have the following text stored in a local stringvar in my report: <li class="bar1 purplebar" style="height: 12px;">12 </li> <li class="bar2 redbar" style="height: 7px;">7 </li> <li class="bar3 bluebar" style="height: 3px;">3 </li> <li class="bar4 greenbar" style="height: 2px;">2 </li> <li...
  15. Solojer

    Is Math in Style attribute posible?

    Thanks for your help with this feherke.. I'm a bit in the dark when it comes to many things CSS related, would you mind being a bit more specific when you mention a CSS framework? Also, unfortunately, my audience is using primarily IE8, so the calc function doesn't look like it will work based...
  16. Solojer

    Is Math in Style attribute posible?

    ...some math in the attribute rather than calculating it before the code is generated. I tested it out, and it does not seem to work. I was hoping if someone here could let me know if I have a problem with my syntax, or if it really isn't possible. style ="height:2px*5px;" Thanks in advance!!
  17. Solojer

    Max of count

    Hello -- I'm copying the exact text from another post I found in the SQL forum as I'm wondering how to do this with Crystal XI. When I try to type (Maximum(count({Table.Field})), I get the message that this field cannot be summarized. All suggestions are welcome! Thanks:) I have the...
  18. Solojer

    How to specify multiple start dates across several groups

    Bump.. Can anyone let me know if this is something that is possible? Thanks!
  19. Solojer

    How to specify multiple start dates across several groups

    Yes, rollover dates and car make are held in the database.
  20. Solojer

    How to specify multiple start dates across several groups

    Thanks for the suggestion -- I'm currently using Crystal 10. What if the Car make and rollover date are both dynamic? {table.car_make} and {table.rollover_date}, for example?

Part and Inventory Search

Back
Top