Search results for query: *

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...

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

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!

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...

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

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

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...

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

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

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...

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?

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...

HMM.. maybe I'm making this too complicated for myself. I'm building that string in a GLOBAL stringvar (I noticed I accidentally said local in my original post) in GF2. The code looks like this... //@GF2 evaluateafter ({@CallsPerSubject}); WHILEPRINTINGRECORDS; global stringvar bar; global...

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...

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...

I've written a script that will auto generate CSS for a page I'm making. For the script, it would be much easier if I were able to use 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...

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...

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

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

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?