Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dbaJSmith
  • Content: Threads
  • Order by date
  1. dbaJSmith

    CR 2008 runtime viewer - chart text distorted

    Hello all: I'm designing reports in CR2008 SP2 for use in an application that displays using the CR2008 SP2 Runtime. Everything has been working great except any graph or chart we design. For some reason the text objects in the chart object do not present correctly; they are distorted and...
  2. dbaJSmith

    #ERROR on all expressions in report during print

    Hello all: Running Access 2003. I have a form that collects optional information from the user, who then clicks the button and runs a report. For instance, the user enters "9/14/10" for the review date, leave the "reviewerName" field blank, and clicks the button to run the report. The report...
  3. dbaJSmith

    Multiple columns in report

    Hello all: Using Access 2003, having trouble with a 2 column report. The column setup itself works fine, no issues there. The problem now exists in the page header that I created. I duplicated my headers so that they are labeled correctly; when I only have 1 column of data, however, I'd like the...
  4. dbaJSmith

    Scroll bars fix using setFocus?

    Hello all: I have a form with several vertical scrolling subforms (form view), each placed on a separate tab. Throughout use of the form I am changing the visibility of the tab control, which hides all the subforms (but does not close them). However, each time that I "reveal" the tab, each...
  5. dbaJSmith

    String length issues?

    Hi all: I'm trying to run the following code, and I'm running into issues: dim submitSQL as string submitSQL = "insert into tbl_Record (auditID, clientID, recordAuditNum, medReviewer, medProvider, medDateSvc, reviewToolID, " submitSQL = submitSQL & "finReviewer, finProvider, finDateEntered...
  6. dbaJSmith

    SQL Command problems

    Using CR XI R2 Hello all: I'm trying to create a SQL Command using a series of joins to get multiple columns or results from a single column. The purpose of this is to get a single view of all the data in a single view. The data must be presented this way in order to preserve the current format...
  7. dbaJSmith

    BOE XI and Crystal

    Hello all: Using CR XI R2, is there any way of using the BOE XI Repository as a data source? I want to generate a report of reports; for instance, comparing access dates, upload dates, counts, etc. Thanks for any help!
  8. dbaJSmith

    combining tables while including NULLs

    Using SQL Server 2000 I'm trying to perform a series of joins to get multiple values out of a single set of tables. The purpose of this is to get a single view of all responses to a single responseID. The data is stored as: ResponseAnswer ResponseID[tab]ItemID[tab]OptionID 1 [tab]500...
  9. dbaJSmith

    Font issue in charts

    Using BOE XI R2, and ran into an issue with fonts displaying correctly on the server. Was able to work past that by uploading the proper fonts to the server (thanks to the previous posts from others!). I have one specific report that continues to have problems with fonts. The font displays...
  10. dbaJSmith

    Multiple Columns of Data...?

    CR XI; I have a report created that has a ton of horizontal white space that's not being used, but is taking up 3-4 pages vertically. Is there a way to generate multiple columns of data (similar to the "Columns" functionality of Word and such) to take advantage of that empty space? Thanks!
  11. dbaJSmith

    Rounding Percentages

    Hello all: Using CR XI, trying to create a combined summary in one field. Example of result: Individuals Tested: 450 Yes Cases: 400 / 88.89% No Cases: 50 / 11.11% I can't seem to get the percentages to round to two significant digits: *************** whileprintingrecords; numbervar CountYes...
  12. dbaJSmith

    Specified Order - Formula?

    Using CR XI. I'm working on a report that emulates a crosstab (the crosstab cannot perform the calculations I need, so I'm using a three-formula trick to get my numbers). Right now, the group is sorted in original order. I'm 100% sure that I can't sort the rows by the three-formula trick...
  13. dbaJSmith

    Modelling Engine error

    Using Visio Enterprise 2003 SP2, perhaps SP3 (can't tell, not my system). I want to reverse engineer a database. If I select the "Database Model Diagram" under the Database category to begin, I get a message box: "ERROR - Failed to initialize the Modeling Engine." In addition, the Database...
  14. dbaJSmith

    Logic issue for data selection

    Hello all: I'm using CR11 to pull several tables, and I'm having trouble getting the right data onto the list. The table I end up with (after joins) looks something like this, with other fields: Category | Name | Date | Result 1 | Risk A | 1/1/2007 | True 1 | Risk B | 1/1/2008 | False 1 | Risk...
  15. dbaJSmith

    Drill Down reports w/ Report Header

    Hello: I am using Crystal Reports XI, and have created a drill-down report. I have been working on a solution that will allow the report header to stay on the report at all times, even through a drill-down. Does anyone know if this is possible using the Report Header section, or can it only be...

Part and Inventory Search

Back
Top