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!

  • Congratulations strongm 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: jello212
  • Content: Threads
  • Order by date
  1. jello212

    Printer Button not present

    Crystal Reports 11. No matter what I do, the report is printing as if the paper size is 3" wide (or 3" tall in landscape). The paper size = Letter. Left margin = 0.2" Right Margin = 0.2" Top margin = 0.166" Bottom margin = 0.18" There is no button to choose a printer. The report, for...
  2. jello212

    Dynamic Parameter causing error mssg

    Crystal Reports 11.0.0.1282 Report has a dynamic date prompt. The report has been working fine until now. Now, every time the report is refreshed, the following error appears: --------------------------- "Prompting failed with the following error message: 'List of Values failure: fail to get...
  3. jello212

    No Fonts are showing up

    I wrote a report on my machine. All fields were Arial 8. I ftp'd the report to a client's machine that has Crystsal 11 installed. Once it's on their system, all fields are showing up as "Device Font." If you try to change the font, there are no options other than "Device Font." If you go...
  4. jello212

    Problem with SQL Server 2005

    We have some clients that are on SQL Server 2000 and others that are on SQL Server 2005. I have a report with the following query: SELECT "vwGenSvcInfo"."Department_Abbr", "vwGenSvcInfo"."Actual_Dr_Name", "vwGenSvcInfo"."Patient_Number", "vwGenSvcInfo"."Service_Date_From"...
  5. jello212

    Select Expert

    I have the following formula. It's 3 completely self contained conditions - let's call them A, B, and C. Only one of the 3 conditions must be met in order for the row to apply. Assuming the 3 conditions are in the order A,B,C, A & B are working correctly. Rows that meet condition C do not...
  6. jello212

    Summing across Groups

    I'm writing a report for a medical office and the patients can see any of the doctors within the office. They want a report that will appear similar to: Dr 1 Patient A 10 total visits 3 visits for Dr1 30% Patient B 15 total visits 3 visits for Dr1 20% Dr 2...
  7. jello212

    Appt book report

    I'm working on a report for a doctor's office and they'd like a printout of the schedule to view at a glance. Desired Output is: Dr 1 Dr 2 Dr 3 Dr 4 8:00 D Smith M Jordan J Worthy K Smith 8:15 A Jamison V...
  8. jello212

    Filter not workin correctly

    line in question: ID.....chgDt.....chgVdDt.....pmtDt.....PmtVdDt 48781..12/29/06..............1/17/07.......... Filter: ChgDt = {?dtRng} or ChgVdDt = {?dtRng} or PmtDt = {?dtRng} or PmtVdDt = {?dtRng} {?dtRng} = 1/1/07 - 1/31/07 According to the logic, the row should be selected but it's...
  9. jello212

    Crystal - working remotely

    I have crystal loaded on my laptop. My office is in NC, but our databases are in NH. When I'm in the office, I have no problems with Crystal. However, when I try to work from home and connect to the office (NC) via vpn, Crystal hangs indefinitely. I can open the Crystal app with no...
  10. jello212

    Set Datasource

    I am in charge of writing reports for our customers. The database that I am connected to is NTier_BUCL. The database names that the customers will be connected to is NTier_CustomerName. After I send a report to a client, they do the Set Datasource and update the tables/views. For the most...
  11. jello212

    How to only sum certain rows

    I'm running a report off of a single view. The view contains invoices with an invoice id, and a charge amount but also contains payments with payment id's. So the data may look like Inv Chg PmtID PmtAmt 1 1000 A 150 1 1000 B 45 1 1000 C...

Part and Inventory Search

Back
Top