Search results for query: *

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

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

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

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

Hi there! I have a report that I am working on that has multiple groups. Each group has a different sales rollover date, and the "from date" needs to be different per group. How would I go about doing this in one report? Example: Car [tab][tab] Rollover Date ====[tab][tab]===============...

Hi! I followed the excellent tutorial from LBass found here: http://www.ml-consult.co.uk/cryst-06.htm, and it worked like a charm! Thank you so much! I'm hoping someone can help me extend the functionality a bit. I've got two dates in my data table (start and end). I would like to have the...

Hi all -- Following MCuthill suggestion, I followed Ken Hamady's solution: http://www.kenhamady.com/form13.shtml to calculate the number of "Work Hours" between two DateTime Values. This worked, however, now Crystal won't let me summarize the resulting value of the field. Do you know how I...

Hi! Is there an easy way to calculate the difference between two datetime fields taking into account working hours (and days)? Thanks!

I would like to use crystal reports to report on a series of files in a series of directories on a drive. Is this possible directly in crystal? If not, has anyone else done something similar to this? Have you got any suggestions as to how to proceed? Thanks!

How do you calculate the difference between two date-time fields? Thanks!

When merging data files into a spreadsheet, is there a way to merge into an XLS file instead of a CSV? Thanks!

I've got a cross-tab I would like to create which shows average time taken to process a task. The data is stored in the database in seconds. However, I would like the report to show minutes and seconds (easier to read, of course). For other similar reports (non-cross tab), I've created a...

Hi -- Quick question -- What is the buffer size for SMDR data on the ICP 3300? Also, where do I look to see what is currently being stored in the buffer? Thanks!

Hi there! Using Crystal 10, I've got a report where I need to combine many records from the details into one field in the group header. The value of the fields in the GH needs to reset for each group. For example, if the 1st group contains "apples", and the second group contains "oranges"...

Hello, I am new to this product, and was wondering if you could offer some of your expertise: I'm looking for a tool which will process incoming and outgoing e-mails, and automatically add the details to the case/opportunity/etc. I know about the "multichannel communications" module, but it...

I'm working with a table with about 200 fields, all of which have completely non-sensicle field names (i.e. application01, application02, etc). Is there a way to change the names of the fields in Crystal so that they will be easier to identify when creating reports?