Recent content by gbobbie

I am trying to create a SQL query (SQL Server) that will take what is currently in rows and spread out over a column. For example, the data currently displays like this: lookup_key group_name 100 CARDIOVAS 100 CARDIOVASMS 101...

CR 9 I created a directory from our database in CR and I'm just about finished with it, except one problem. The font size scales down a half size when I export to Word. Which, I assumed, I could just fix easily by using a font in Crystal a half size bigger, therefore getting the needed font...

In addition, I have tried different fonts and exporting to rtf, and neither worked. Thanks.

CR 9 I created a directory from our database in CR and I'm just about finished with it, except one problem. The font size scales down a half size when I export to Word. Which, I assumed, I could just fix easily by using a font in Crystal a half size bigger, therefore getting the needed font...

ACT! 3.0 and CR9 I want to pull some simple reports from ACT because the report builder function is horrible within ACT. I'm using Crystal to build a report grouped by Record Manager, but it seems the field is encrypted. Does anyone know a solution to this problem?? Any help is appreciated!!

We are running a very old version of ACT! (2.0) and a user has asked that her records remain hidden from all other users. Is this possible? The simple security setup in ACT! doesn't show such options, but I was hoping someone knew a trick. Thanks in advance!!

Yes, I am in the same boat as tubbers. If there's anything additional anyone could post regarding Ken's method and multiple grouping, it would be greatly appreciated. Thank you!!

CR 9 I created an index using arrays with the assistance of the following article: http://support.businessobjects.com/communityCS/TechnicalPapers/cr_arrays.pdf However, I'd like to have the index alphabetized and can't figure out how I'd do it. Can anyone lend assistance? Thanks in advance!

I need to delete from the table based on the parameter fields, but I went a different route and figured it out. Thanks!

I need a way to combine two queries in order to run them in unison for a report that needs to call them as a stored procedure. The delete query is as follows: PARAMETERS [{?LinkReceiver}] Text ( 255 ), [{?DateTime}] DateTime; DELETE * FROM TableOfContents WHERE...

There was my problem. Thanks!

It's not working for me. I currently have it in the page header and it continually displays the very first record on the first page.

CR9 I have a report that I would like to display the first record of each page in the page header. I thought it might be possible to use minimum({table.record}) if I could figure out how to have it re-evaluated for each page. Like the following: PH Page 1 Adams County D...

To be more specific about my exact issue, I have a box in the page header that's aligned all the way to the left. I want it to print at the very edge of the page. The groups and details sections are in multiple columns, 4 to be exact. The page header is set to underlay the following sections...

CR9 I have a report with multiple columns and I need to place a index tab on the edge of the upper right hand corner for odd pages and the upper left for even pages. I understand how to conditionally have it switch back and forth via different page headers and conditional suppression, etc., but...