Recent content by kovas

thanks lbass, i already had something similar as to what you suggested. But when you use this method. How can you get an accurate count of how many records you are displaying? I tried using Summary/Count but it counts the suppressed records.

sort it descending by date? put a count of records and suppress anything greater than 1?

I have duplicate names in my report so to get rid of them, i grouped by Name, and then put a formula that looks like that in the details if not isnull({people.ssn}) then 1 else 0 then in the group footer i sum up the formula and in group selection formula i put this Count ({@SSN}...

Roni check out this thread thread149-160340

I have a few reports that need to be grouped by four quarters, Jan - March, April - June, July - Sept, Oct - Dec. The way it works now is that there is a Formula called Quarter. That looks like this. if {term.termdate} in Date (1999,01,01) to Date (1999,03,31) then "1999/01/01 -...

thanks for the reply but that didnt help. any other idas? thank you!

My CD Rom opens and closes whenever it feels like it. It just started happening this week. It just randomly opens and closes. I am totally clueless as to why this happens. Does anyone know what it could be? thank you!

using listbox is exactly what i am trying to avoid, i could have sworn i saw a way to select multiple items in a combo box before. thanks for the help!

How can I select multiple items in my combo box? I am trying to pass it as a parameter to my crystal report. thanks!

Its xp, sorry a bit clueless here but what is a spooler service and how do i stop it? thank you for the help!

I have a network printer and it has 5 documents in print queue but it tells me Access Denied when I try to Cancel them. The computer the documents were sent to print from is no longer here I dont think. I unpluged the printer but it still had those documents in queue. Any ideas? Thank you.

thanks for the reply, but i got it removed with a paperclip, it was stuck in there somehow ;)

I was intalling some software, put in the cd, it was installing just fine until for some reason the cd rom ejected without the cd. I got the error saying "Error reading from Cd" I aborted the installation and rebooted the pc. The cd was left inside. I tried to access the cd but it kept...

Yes, so does anyone have any idea how to change the resolution for the normal boot? perhaps go into dos mode and edit some settings files? there has got to be a way :) Thanks!

My monitor broke and until i get a new one i am trying to use an old 15 inch one. But the screen is all back when I log into windows. I think it might be because the resolution settings are wrong. I can log in just fine in Safe Mode and the Display settings show 640 by 800 something? And cant be...