Hello,
I am using ColdFusion MX7 Report Builder. When I try to change the font of a basic text item such as a label and go to the font dropdown box, none of my Open Type fonts are available. Only True Type fonts can be selected. This is also the case in the Properties Font Name box.
My Open...
Hello,
I'm using CR9 with SQL Server 2000. Without creating a view, can someone tell me how I can show details of two different tables that are both filtered separately? I pass parameters to the report to limit the records by account number and date.
For instance, table one is filtered by an...
Hello,
I've created an ActiveX component through VB6 that utilizes the acrobat type library (acrobat.tlb) to view and print pdf files. The problem I ran into is that it only works on machines with the full version of Acrobat loaded.
Could I be missing something in using the type library? Is...
Hello,
I have a report consisting of several subreports that runs without any issues in the Designer. Once I publish the report to Microsoft CRM, I can also view it without any problems, but when I go to print it, I am asked to log into the database as if I wasn't already connected. This only...
Hi Folks,
Is there any way to save a ton of reports from either version 7 or 8.5 into version 9 without going into each report and doing a Save As?
Thanks for your assistance.
Hello,
Can someone please tell me how to sum a field name when it contains parentheses? My field name is
"GT_Sum_(_new_line_COST_)"
That's without the quotes and when I do SELECT max(GT_Sum_(_new_line_COST_)) I receive an error.
Thanks in advance.
Hello,
I am upgrading a vb6 application that uses CR7 to CR9. I have an area that requires an ODBC export of a report. For some reason, I get an error that says "The definition for column 'GT_Sum_' must include a data type".
The report exports fine with the old CR7 code. I have upgraded...
Hello,
I've seen numerous articles explaining how to use the browscap.ini file to detect if javascript is enabled, but seem to be missing something. When I disable javascript by going into Internet Options --> Security settings in IE6 and disable my three Scripting options, my script still...
If a webpage has a built in warning popup box, such as an alert box titled "Warning" and a message that says "Cannot connect", is there a way to suppress the message and not have it show at all?
Specifically, I purchased a D-Link webcam model CS-5300 which uses an Active X control to display...
Is there a way to get the CR9 viewers to export into Excel without adding all of the report formatting to the final file? I would like the final file to simply be a flat file that only contains the data in in the sheet.
I attempted to use the "Excel (Data Only)" option in the ActiveX...
Hi,
I have recently upgraded to Crystal Reports 9 from V8.5 and I am trying to update my ASP application which uses RAS 9 and the ActiveX viewer. My application is modeled after the simpleparameterfields.asp example provided in the ASP examples from Crystal.
I must have something configured...
Hi,
Is there a way to use the MaskEdBox control with a mask that allows for an optional length? For instance, I would like it so I can enter a value like A123 or a value like B45. The mask A### forces four characters and can only be used for A123.
Thanks in advance.
Hi,
I am looking for a javascript-based grid control that allows sorting based on columns, an onclick event when a row is selected, and (most importantly) the ability to begin typing in a row and automatically jump down the sorted list of records as you type.
Has anyone come across this or...
Hello,
I have some ColdFusion code that seems to be duplicating my insert statement (running it twice). Can someone please take a look and let me know where my problem lies? It is driving me crazy. Could this be a server setting?
<cftry>
<cfset variables.strErr = "">
<cfif...
Hi,
Can someone give me the syntax for the best way to go about inserting a row into a table with an auto-incrementing identity column as a primary key and then obtaining the new value after the insert? I am concerned about multiple users inserting at the same time and retrieving the wrong...
Can anyone tell me if there is an effective way of measuring the bandwidth utilization when running reports through the web viewers? I am planning a WAN upgrade and need to know an acceptable bandwidth level. Since I am using v.8.5, the most concurrent reports that may be opened at any given...
Does anyone know how to create a dynamic drop down list from a query if the item and value parameters are given ahead of time? I don't want to hard code the item and value of a select list so that I can consistently use the same custom tag with a new query, item field, and value field.
For...
Hi,
Please excuse me if this thread has already been posted. I can't seem to find it anywhere.
I have a page that I split into top and bottom sections with frames. When I click on items in the top frame, it will refresh items in the bottom frame.
My problem is that my navigation is also in...
Hi,
I have an SQL command that I am executing through some VB code. The code is as follows:
Dim oss_conn as ADODB.Connection
Dim oss_rs as ADODB.Recordset
Dim sql_statement as String
oss_conn.Open "...typical connection string..."
sql_statement = "UPDATE sales SET override =...
Hello,
I had an issue with printing out of the ActiveX or Java viewers from an ASP application where the message "Unable to Print" would pop up on certain workstations when users attempted to print the reports. It turned out that if I installed a default printer on those stations that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.