Search results for query: *

I am using Crystal 9.0 and SQL Server 2005. I am trying to create a report which runs a Stored Procedure in SQL Server. The procedure accepts 6 parameters, 4 of which are comma delimited lists. I want to be able to provide the user a list of values in which to build these parameters. To...

2005 - SP2. 9.00.3042.00

I checked out the columns setting and it is set to one. Any other thoughts? Joy

Thanks for the point in the right direction. I checked out the code in the sp_update_job_step and see the following... -- Check permissions beyond what's checked by the sysjobs_view -- SQLAgentReader and SQLAgentOperator roles that can see all jobs -- cannot modify jobs they do not own...

How do I grant rights to edit all jobs in SQL server 2005? There are roles to edit only jobs ownded by the user, and ones that can view/stop/start etc..., but I don't see one that will let a user updated them. Thanks, Joy

I have a report that is working fine in access, but when exported the data in a sub-subreport is repeated twice for each record. The report looks like <pstyle:Spacer> <pstyle:CLEtopic>1:00[tab]Current Securities Law Developments and exported it returns <pstyle:Spacer><pstyle:Spacer>...

Thanks for the input. The reset function was just what you listed and augustqty was a pasting error. I apologize for that. I tried the running totals and those work fine. I will just redo the report using those instead. I just can't figure out why there was an issue with the totals using my...

I have a formula which sets variables based on the date. My problem is for some of the variables the value is getting updated twice for the last record in the group. It only seems to happen with the Month variables, the Fiscal Year ones have the correct value. Details on the formulas and...

I found it... category in outlook = urn:schemas-microsoft-com:office:office#Keywords Another one I had to search to find was the private flag. http://schemas.microsoft.com/exchange/sensitivity. checked = 0, unchecked = 0

I am trying to pull calendar data from Exchange and use it in other applications based on the category assigned to the appointment. Where would I find this field to query? The other fields I am using are... urn:schemas:calendar:location urn:schemas:httpmail:subject...

SELECT id FROM CaseLaw c join containstable(CaseLaw,CaseText,'("crime and punishment")') ct on c.id = ct.[key] WHERE (c.CaseType=1 OR c.CaseType=2) We are using SQL Server 2000 full-text indexing and the script above isn't returning the result set we are expecting. Along with all terms...

I don't know if I am asking in the right place, but I am hoping to create new and/or modify existing System DSNs via a batch file on login. We are switching Servers and will have to visit each work station if we can't do this via some sort of script. Any help would be appreciated. We are on...

We are running Dues Renewal Forms to a PDF file, the entire report is 42650 pages long. The report looks great in Crystal, but when you open the PDF export the later pages have funky characters. It is like the fonts are getting switched during the export process. I am using a combination of...

In other programs I have a print to file check box on the print dialog box. Is there any way to do the same thing in Crystal? I need to output the prn file to send to our print house. Thanks Joy

I found a solution on SQL Server Central that worked for me. Instead of just running the xp_sendmail, I have to stop and start prior to it. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=17649 example: xp_stopmail xp_startmail xp_sendmail @Recipients =...

I haven't found anything yet, let me know if you do. Joy

We have recently moved and upgraded our Exchange Server to 2003, since this switch the xp_sendmail command is no longer working. We are on SQL Server 2000 SP3 and other email from SQL is working (job notifications and commands from DTS packages). The ones that fail are using xp_sendmail from...

Have you tried a union query? Select MasterOrder as Orderno, Costperlb from Table where MasterOrder <> "" Union Select Order2 as Orderno, Costperlb from Table where Order2 <> "" Union Select Order3 as Orderno, Costperlb from Table where Order3 <> "" Union Select Order4 as Orderno...

I have a job scheduled in Enterprise Manager to run a stored procedure every 5 minutes. It has been running in a timely fashion (3 seconds) for months but this afternoon it has started taking 15-20 minutes. It still runs fine through Query Analyser. Does anyone have any suggestions for...

Thank you for your suggestion. My problem isn't in the data, it is in the way the report exports. Everything wraps fine on screen amd print, but when I exported it actually put in a character where the line wrapped. What I needed was just the text and to then let whatever program it was...