Search results for query: *

MS SQL SERVER 2005 CR XI R2 I have an RTF field that is an (image,null) field in the database. I am able to display the contents of the field in CR using the following SQL Expression: //%Notes {fn substring(BEHOLD_Tasks.TASK_RTF_NOTES,0,100000000)} This field displays in hexdecimal. Is there...

CR XI here.... I have a crosstab report that displays the number of referrals by referral source, by month. Jan Feb Mar Apr Total Referral A 10 10 10 10 40 Referral B 9 9 9 9 36 Referral C 8 8 8 8 32...

Using CR XI, is there a function that allows for dynamic control of "This section will be printed"? The users want to be able to print the report with totals by week or totals by month. They will get one or the other but not both. I have a report that has a detail section of daily...

Is a table with a varchar field size of 1000 bigger than a table with a varchar field size of 500? Or, is the size of the table defined by the actual amount of data in the varchar field?

Is there a way of determining whether you are in a group header or group footer with 1 formula? For example, if GROUPHEADER then "I am the top" else if GROUPFOOTER then "I am the bottom"

Has anyone had this experience? The Progress KB has an unverified solution about this but does not mention cause.

I have an varchar "amount" field that looks like this: 6231883.48;5619475.63;6163582.29;5774570.44;4234819.62;0;0;0;0;0;0;0;0 Each bucket represents a month plus the 13th month. I am open to ideas as to how to break this up into separate buckets.

This might be a two prong question but if I can get two birds with one stone, I would be delighted. I have a Progress v9.1D database and have been using WinSQL to run queries. I just downloaded UltraEdit and would like to use it as an editor and be able to run SQL queries directly from it...

I am interested in finding out if there are other users of Crystal Reports in the Apprise application suite on a Progress database. I am also looking for websites that might have information or forums. Thank you.

I am on 7.6.100 SQL. We have over 10000 records in the Item Master file of which half are obsolete. Some of these have a qty. on hand in the item location file just so that you know I am aware of this. I have been asked to remove the obsolete items from all modules including Inventory...

I have been looking throughout the Access forums for a list of error message numbers. I have not been able to find any. Essentially, I want to replace the "user-unfriendly" MS Access messages with my own. For example, I would like to trap the message "The record cannot be...

In the code behind an object, I have seen Me.Address and Me!Address. Can anyone please tell me the difference between the two? Thanks!

CR 7 here... I have 3 separate prompts for which Crystal uses a box with 3 tabs. On the other hand, I don't have much background in VB and very little time. No...I am not asking for someone's sample code. Has anyone come up with an alternative to the REALLY ugly CR parameter box and no VB...

I have a main report that has a number of subreports. Each subreport is linked to the main report via a common key. Each subreport has more detail than is required for the main report. However, I only want to pass a couple of selected fields from the subreport to the main report, but to...

If the detail section is hidden (drilldown ok), how can I hide the page header?

Fellow geeks, I am developing reports using MS Access 97 connected to an Informix database. Currently, I am using the ODBC driver provided by Merant (Intersolv). Since the data has to be real-time, the tables are linked rather than imported into Access. Unfortunately, this gives a...

Occassionally, I get an ODBC call failed error message when executing an Access '97 query against an Informix Dynamic Server ver. 7.3. And to top it all, my local machine has several difference versions of ODBC drivers for Informix. Are there any Access to Informix geeks out there that can...

I am running Access 97. I have a very large report that could exceed 1000 pages. When I execute the report, I get the first page and I am able to scroll through each subsequent page, one by one. However, when I click on the arrow that will take me to the last page, the formatting report bar...