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 derfloh 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: *

  1. jello212

    Dynamic Parameter causing error mssg

    No, I haven't. Anyone?
  2. 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...
  3. 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...
  4. 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...
  5. jello212

    Problem with SQL Server 2005

    I support about 4000 clients and the database is the same on all clients - same tables, views, indexes, columns, etc. The hardware/setup of the servers for each client are controlled by the client, so, that's out of my control. But, I've taken the query and run it on about a dozen...
  6. 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"...
  7. jello212

    Select Expert

    Never mind. It was a problem with the placement of the parenthesis. Mods, feel free to delete.
  8. 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...
  9. jello212

    Summing across Groups

    You rock.
  10. 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...
  11. 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...
  12. jello212

    Crystal - working remotely

    I'll check the AutosmartLinking. But I'm never getting to the point of selecting a table. As soon as I click the new icon (or File --> New), Crystal goes to lunch, and dinner, drinks, etc.
  13. jello212

    Filter not workin correctly

    I've verified the #s and the filter is respecting the left outer. Is there a way to get the command statement to respect the indexes on a table/view? Every time I use a command statement, performance goes to crap.
  14. jello212

    Crystal - working remotely

    You do understand correctly. Unfortunately for me, my company keeps the media in our New Hampshire office so it looks like I won't be working from home any time soon.
  15. jello212

    Filter not workin correctly

    Wouldn't the fact that all of the filters are connected with "OR" instead of "AND" keep the left join in tact? Also, I'd love to be able to establish constraints as part of the ON clause. How do I do that in Crystal?
  16. jello212

    Crystal - working remotely

    That's correct.
  17. jello212

    Crystal - working remotely

    I thought about that, except I'm not even getting a chance to choose my connection. For all Crystal knows, I could be connecting to a database located on lap top.
  18. jello212

    Filter not workin correctly

    No, I'm able to copy and paste the sql statement into MS Query Analyzer and it runs fine. I think I have it figured out. The problem is with the 2nd line of the section. ID.....chgDt.....chgVdDt.....pmtDt.....PmtVdDt 48781..12/29/06..............1/17/07.......... Filter: ChgDt = {?dtRng}...
  19. jello212

    Filter not workin correctly

    {vwGenVouchInfo.Posting_Date} = {?Dt Range} or {vwGenVouchInfo.Date_Voided} = {?Dt Range} or {vwGenSvcPmtInfo.Posting_Date} = {?Dt Range} or {vwGenSvcPmtInfo.Date_Voided} = {?Dt Range} ------------------------------------- SELECT * FROM (vwGenVouchInfo INNER JOIN...
  20. jello212

    Filter not workin correctly

    That is the full record selection formula

Part and Inventory Search

Back
Top