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

  1. snowyej

    Pivot Table Sorting

    Is it possible to sort by the Grand Total column in a pivot table? I want to sort descending so I see the highest grand totals at the top. Is this possible? I can't for the life of me get it to sort by that column. Thanks in advance! Elizabeth
  2. snowyej

    Excel Database Query Grouping Question

    Perfect! That worked great. Thank you!
  3. snowyej

    Excel Database Query Grouping Question

    I hope this is the right forum for this question.. I am creating a pivot table report from data in a SQL database. The report is to show the count of patients in each zip code that all of our doctors have seen this year. So it should look something like this: Jones Brown...
  4. snowyej

    Help with multiple totals

    Aha! Got it. Thanks everyone. I turned the report in and the user was very pleased. :)
  5. snowyej

    Help with multiple totals

    That's ok. Every patient must have a value for age so that shouldn't be a factor. I like that it doesn't show an age group if the dr didn't see any patients of those ages. Now I've come across another problem...well something new the user requesting this report has asked me for at least...
  6. snowyej

    Help with multiple totals

    Excellent! THat worked great! I've never used crosstabs but that's exactly what I needed. Thanks so much for your help!
  7. snowyej

    Help with multiple totals

    Hello, I'm not very Crystal savvy, so I'm not sure this can even be done. I have a report that I'm trying to do for a doctor's office I work for. We want to show a list of doctors...each doctor will have a list of ages underneath of patients they've seen and then to the right will be totals...
  8. snowyej

    Need help with zip code report

    Thank you! That worked great! :)
  9. snowyej

    Need help with zip code report

    I am pretty new to Crystal Reports so this may have a simple answer. I am running a zip code report for all patients in a clinic I work for. They want a count of the number of patients in each zip code found in the database. I have the report that lists out the zip codes and gives a count for...
  10. snowyej

    Help with query..

    I'm hoping someone can help me. I have very basic sql query knowledge and am having a hard time wrapping my head around this one. I need to do two queries, one that will find a unique count of all the patients that were seen in a clinic I work for in the last two years (say from 5/1/2004...
  11. snowyej

    How to use Windows Scripting to Print HTML File

    Thanks for the response! I am getting this error when trying to run the script: Line: 5 Char: 19 Error: Invalid 'for' loop control variable Code: 800A0410 Seems to not like the '<>' for some reason? Any suggestions? Thanks! Elizabeth
  12. snowyej

    How to use Windows Scripting to Print HTML File

    Not sure if this is the right forum or not...but hopefully someone can help. :) I have an html file that is autogenerated every hour. I want to create a scheduled task that will run a script (vbscript or batch file) that will print that html file to a network printer every hour. I've...
  13. snowyej

    Automatic Printing of an Online Order

    Thanks everyone, I think option B definitely sounds doable and I am going to check out that program. Thanks for the fast responses! Elizabeth :)
  14. snowyej

    Automatic Printing of an Online Order

    That's not exactly what I'm looking for. Basically a user will submit an order for this restaurant online. When they hit the Submit button it should shoot that order to output on a printer inside the restaurant. The restaurant will not have access to the order website, nor do I want the order...
  15. snowyej

    Automatic Printing of an Online Order

    I tried searching on this (in the forums and elsewhere on the web) and haven't had much luck. I'm not even sure if this is the right forum or not, but since I'll probably be coding the online ordering process in ASP I thought I'd post it here... Anyway, is there a way that when someone submits...
  16. snowyej

    CSS Caching

    Hi Bassguy, Not sure about your caching question, but for the stylesheet question, yes, you can apply background and font-family to stylesheets. Just do something like this: body { background-color:green; } p { font-family:arial, sans-serif; color:blue; } Be sure you link to your stylesheet...
  17. snowyej

    How to pull one webpage into another?

    Chris, the include worked great! And it was so easy to implement! The thing I didn't like about iframes was that I had to do so much configuring to get it to look seemless in my page. The include didn't need any configuring at all. Thanks again to both of you! Elizabeth :)
  18. snowyej

    How to pull one webpage into another?

    Thanks guys! I'm looking into SSI right now (and maybe SWF too). Maybe I'll get that working. Thanks again for the help and suggestions! I appreciate it! Elizabeth :)
  19. snowyej

    How to pull one webpage into another?

    Thanks, that worked great!
  20. snowyej

    How to pull one webpage into another?

    Ok, this may sound like a strange question (or maybe not..), but I have a website that has a contents bar on the left side. I used CSS for the styling, not frames. So anytime I need update something in that contents bar, I have to edit every single page. Is there a way (maybe with the...

Part and Inventory Search

Back
Top