Recent content by snowyej

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

Perfect! That worked great. Thank you!

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...

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

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...

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

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...

Thank you! That worked great! :)

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...

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...

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

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...

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

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...

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...