Search results for query: *

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

Nevermind. I figured it out. You have to group by the common field that's on the datasource 2.

I know there's a thread on this, but I can't seem to find it. Guess that will teach me to bookmark. How do I set up a report to pull only those records on a seperate list? For instance, I'm pulling offices with all respective employees. I only want to pull the offices that are listed on...

Incredible, as always. Worked great, just had to turn the > to <. Thank you!

I currently have a report that is grouped by OFFICE. Individual PROVIDER fields are in the Detail section for each office. A provider number is being populated in our database for each provider and I only want to see those offices with 50% or more of providers without the number. Such as...

Does anyone know how to UNinstall the Crystal add-in for Access?