Search results for query: *

I have a client who is using SQL Server as the backend to an Access database ... for some reason everytime a user opens a form to make changes, Access puts a lock on the table and does not release it ... preventing anybody else from making modifications to ANY records. I have yet to find a...

I seem to remember that the drop down list in the select expert only shows the first 500 unique values from the field chosen ... is that correct? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I have already taken and passed 201 and 301 ... but I took them last year before Crystal XI was out. I just noticed (yes I'm a little slow) that you only need 2 exams to get the CRCP now. Does this apply to myself? Or do I need to retake both exams? paqguy - Shaun Beane Instructor/Developer...

I'm trying to do field validation using the form before update event. I cancel the event if the validation fails. I'm trapping for a keydown of F12 so that I can mimic a previous software package used by the data entry people. When the user presses F12, I want to execute the click event of...

I remember reading (at least I think I remember ...) about a new feature in Crystal 10 that displays all the conditional formatting from a report in one place ... Anybody know more about this - like where the menu option is? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I'd like to print my first page portrait and the second page (or subreport) in landscape. I'm thinking I can just setup the second page so that the text is rotated 90 degrees and make it "look" like landscape. Anybody have experience doing this?? paqguy - Shaun Beane Instructor/Developer...

Does anybody know what Crystal's threshold is for formatting numbers to scientific notation - seems to be somewhere around 17-18 digits to the left of the decimal. Also, can I "force" a number to format with scientific notation? ANY information would be greatly appreciated :) Thanks paqguy -...

Has this feature been removed?? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

Is there a way to vertically center text within a text box? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I have a client who has recently changed their Oracle password. Everytime they open up a report now, it prompts them for the password, it never did before. Is this information stored in the report somewhere, or is it just in the ODBC connection? Thanks for any help. paqguy - Shaun Beane...

I've setup a parameter prompt to allow the user to select a sort order of a report. I would also like to allow them to select the direction of the sort - asc or desc. Is this something that can be changed with a formula? paqguy - Shaun Beane Instructor/Developer sbeane@adelphia.net

I created a DTS script using the wizard. Saved the script - all the while logged in as SA. Try to execute the script (still logged in as SA) and get the following error: Error Source: Microsoft OLE DB Provider for SQL Server Error Description: [DBNETLIB][ConnectionOpen(Connect()).]SQL...

I have a multi column report that needs to have labels on the left side in the details section. I have followed the instructions from this knowledge base article http://support.crystaldecisions.com/library/kbase/articles/c2005944.asp but the first record show up underneath the labels, not to...

I need a way of building a report that has my field headings on the left side of my report and fields as column headings. Sort of like a cross-tab but with detail. If you need more explanation just let me know. Thanks for any ideas. paqguy - Shaun Beane Instructor/Developer sbeane@adelphia.net

I'm using the Crystal Report Control to open a report from Visual Basic. I can't find the help files for this and need to be able to pass a parameter to the report. Any ideas? paqguy - Shaun Beane Instructor/Developer sbeane@adelphia.net

Is it possible to customize the text for the Total row in a crosstab report? By default the word "Total" is display. I'd like to display "Total for " & {Orders.OrderDate} Any ideas? paqguy - Shaun Beane Instructor/Developer sbeane@adelphia.net

Is there a way to count the number of checked check boxes on a report. The check box is based off a boolean expression, not a yes/no field. Thanks. paqguy - Shaun Beane

I need to build an expression that will return the difference between two dates in months and days. For example: 9/2/2002 - 8/1/2002 = 1 month 1 day Any ideas? Thanks! paqguy - Shaun Beane

I've never seen this happen before ... Creating a new formula, some fields from one of my tables are not available to be inserted into my formula (they aren't displayed in the field explorer under the appropriate table). They ARE displayed in the report field explorer, but not in the formula...

Does anybody know if there are any barcode functions built into Crystal?? I looked through the help file and online knowledge base but found nothing. Any help is much appreciated. paqguy - Shaun Beane