Recent content by jollyreaper

Works great! Thanks a bunch!

Thanks! Trying it out now.

I know that there's a way to do this, I know my pseudocode should be close (hopefully) to correct. I want to be able to take a given table from the database and display all records for all fields without having to manually type in the field names. I remember that you're supposed to be able to...

Thanks!

Ok, so I have a cell that shows 38718. That should be a date. Ah, so it's obvious I should format the cell and say "number is date", right? You followed my line of thinking. Wrong! It refuses to take that formatting. I checked on one of the other sheets in the workbook and it has no problems. If...

Ok, I sussed out the problem. It's called "Crystal Reports is buggier than a Windows Beta." I designed the original report months back and everybody was fine with it. Now all these months later, they want to make a change. No problem, right? I run the damn report from Crystal Server and I...

Well, this is pretty weird. Looking through the site more, it says chr(13) or (10) should work. I made a test formula and it worked ok, still not sure why it's not working in my big formula.

I need to change the way a formula is working. Right now it's taking variables and making them look like this: "variable 1, variable 2, variable3" I need to make it look like: "Variable 1 Variable 2 Variable 3" I'm using logic to remove variables that are blank. dim text as string if...

Anybody have good recommendations for learning up on Active Domain and how permissions work? It's kicking my butt right now with inexplicable craziness. I'm trying to lock down certain directories to make them more secure. I have administrator as owner for everything so I can make sure the...

Not sure whether I should post this in the Office forum or here. Hopefully here is more applicable. We're running an intranet and keep our important company forms on pretty little pages. The company is growing in an ad hoc fashion so we're implimenting some security features a little later...

Well, the reason why I think the separate objects isn't the easy way is because they can be a pain to align properly. Crystal has a ton of stuff it can do that Excel can't even dream of but for other areas, Excel is much faster. The dreaded trade-offs.

Grr, curse of the stupid fonts. The editing window fonts are serrifed, the post renders with arial. How I wanted it aligned was with the right-side zeroes aligned vertically, just like you'd have on an accounting report. The problem with the right aligning is that it will affect everything...

I have a report that is trying to present several calculations lined up properly. What I'm trying to do is something like this: Units: @unitformula Options: @option formula ======================== Total: @total formula When I first started using Crystal, I would have done that by making...

And we can set permissions on exactly who can do what kind of restore? I can see letting a department head do the restore but I wouldn't want to let Dizzy the Plucky Intern do the same thing and overwrite the most current version of the file with an old one. Or would that current version also be...

Cool! We'll start testing that out.