Recent content by scan2k

Hello plsh, Were you able to find a solution to this problem? I am also looking for SRS to allow multiple parameter selection within a single list box. Hope to hear a response soon. Thanks, scan2k

This is SQL 6.5 does this matter? The ['xyz'] method is not working...it yields a syntax error. Still puzzled....

Also, cannot drop using Enterprise Manager...it gives an error. Error near 'xyz'

Thanks for your response but this does not work. I tried single and double quotes before and after the table name and I cannot get the table to DROP. Help Help!!!

I created a table named 'XYZ' and now I can't drop the table. I mistakenly included the single quotes in my create table statement. How do I DROP a table with single quotes around it? Thanks for your help....!!!

Hello, I am new to CE. I have over 40 reports which are scheduled to run on the 1st day of every month which accept 3 parameters. How can I change the scheduled run time AND delete scheduled reports that no longer need to run? Thanks for your help!!! scan2k

Hello, hope one or more of you can shed some light. I am using Crystal 8.5 and have a string variable I created to show parameters entered in a report. For example if the user enters, DB, AC, CD etc. then this formula will print the parameters entered at the top of the report. What I'd like...

Hello, I'm hoping someone can help out with the below error message. I am able to login to Goldmine but when I go to click on the REPORTS button or run reports from the File menu I receive the below error. I was able to see which user(s) have the SysReps.DBF file open and ask them to exit then...

Hello, I have a very large spreadsheet with over 12,000 rows. I have approx. 200 shaded cells in one column. Can anyone tell me how to sort this column based on the shaded cell. All shaded cells are shaded the same color (e.g. Yellow in this case) Any help would be appreciated. Thanks!!! :)

Thanks to synapsevampire and bdreed35. I used bdreed35's method because it yielded Q1/2001, Q2/2001, Q3/2001 etc. synapsevampire's method yielded the original Q1/2001, Q4/2001, Q7/2001 etc which I was trying to get away from!! Thank you both for your contributions!!!

Hello, I am grouping by a date field (Ver. 8.5) and utilizing the built in "grouping by quarter" choice from the drop down menu. However, the data groups appear as 1/2001, 4/2001, 7/2001, 10/2001, 1/2002 etc. Can anyone suggest how to name these quarters as Q1/2001, Q2/2001, Q3/2001...

Okay, to eliminate any possible 'user' error I've eliminated some complexities. I started a brand new report which is blank. In the detail section I created a box. In the X+2 for the details section I allowed the conditional expression to be: pagenumber = 1 This suppressed the box in the...

Thanks brownbird but this is exactly what I'm trying to accomplish and it is not working. Any further recommendations? When the section is conditionally suppressed all fields disappear except for the box. Hopefully someone else has an answer!! Thanks!!

Hello, I've created a report footer section (b) which contains a shaded box. There are text fields within the shaded box. I want to suppress the entire section based on a parameter chosen by the user. The only suppression which works is the text fields within the box. The box still remains...

Hello, I recently loaded some Marketing Leads into Goldmine using the CAL table allowed these to show under a users Pending tab. How do I get these to show up in their Calendar so they can call down on the list? Any help is greatly appreciated!! Thanks, Scan2k