Search results for query: *

I'm on SQL 2008. I'm trying to insert rows into a table from a temp table. Instead of adding new rows it is overwriting the existing rows. Below is what I'm using. The COMMISSION_REV_DET_LC table does have an identity column as the primary key. I have no idea what I'm doing wrong. INSERT...

I'm trying to create a view in SQL 2008. My code uses a temp table and I'm getting the error that I can not have a temp table in a View. I have included my code below. Does anyone have any suggestions on how to get around using a temp table? CREATE TABLE #DASHBOARDLC ([Order ID]...

I have an Excel 2010 file containing a Power Query that executes a Stored Procedure. The users trying to refresh the query are not able to. I have updated the properties of the Stored Procedure to allow them to execute it, but they still can not. What else can I do?

I have an Excel 2010 file containing a Power Query that executes a Stored Procedure. The users trying to refresh the query are not able to. I have updated the properties of the Stored Procedure to allow them to execute it, but they still can not. What else can I do?

I'm using SQL Server 2008. I'm trying to update a temp table with values dependent on the max occurrence of another column. Please be patient with me in my explanation. Thank you! Temp Table - #APPTRACKER Columns - Reason, Remarks Table - History Columns - HistoryID, Date, Comment, Event...

I am working in Excel 2010 with a SQL query. The spreadsheet will be shared with individuals that do not have permissions to SQL, but they will need to refresh the query. Is there anyway to work around this to allow them to refresh the query?

I am using CR11 and working on an invoice report. One employee will have multiple pay codes listed on the invoice. In order to format according to client's request, I am working on aligning all pay codes in one horizontal line versus each pay code listed as an individual line item...

I am working on a report where I want to group by Customer, Billing Profile, and Order. I only want the Customers to show that have active orders. I want ALL Billing Profiles associated with the Customer to show whether they are attached to an order or not. I can not get the Billing...

In my report, I am grouping on a Purchase Order field. Not all Orders require Purchase Orders. Even if the purchase order field is null, I still want the order to show. I tried the following formula to group on: IF (ISNULL({OrderMaster.PurchaseOrder}) OR {OrderMaster.PurchaseOrder} = " ")...

I am trying to insert text into a field without deleting the existing text. I want to insert it at the beginning of the existing text string. Example: Existing text in field = 'Existing Data' Text string to insert = 'UPDATE 123 - ' Desired result = 'UPDATE 123 - Existing Data' Thank you!

I am working in CR11. I am building a report from a store procedure and adding some additional information to it. Everything works fine except for one parameter. There is a 'user id' parameter built into the store procedure that I wish to ignore. Is there anyway to do that?

I have a report that works fine when I run it in Crystal. However, when loaded into our software's report viewer, it give me the error message below: '(ALL' is not a valid integer value I have looked at the parameters to make sure I had the correct field type selected and there doesn't seem...

I know you can create a crystal report from a stored procedure but can you start with a crystal report and create a stored procedure from there?

I am using CR11. I have a report that is looking at Employees and Employees' Assignments. I have the report grouped by Employee and then Assignment. I am trying to look to create a formula that will look at the History table and pull a certain value. My formula is listed below but right...

I am using CR11. I have a Running Total in a Group Footer. It calculates correctly until the Group carries over more than one page. The group to calculate on is CUSTOMER. Within that group there are then the BILLINGPROFILE, TIMECARD, & PAYBILLCODE groups under that. I am trying to SUM...

I am using CR XI. I have the following formula but it is returning the wrong day of the week for the date in the field. DayOfWeek ({History.Actual_DateTime}) For instance, the following date and time is returning '2' (Tuesday) when the date actually falls on Monday. What am I doing wrong...

I am using CR11. I have the following code that works correctly in SQL but will not produce results in SQL. {EmployeeMaster.ServiceArea} like "%AL%" Can I not use the % in CR? Is there another version of the same type of code that is better suited for CR?

I am using CRXI. I need my report to only show fields that contain the following characters. ' - ! $ % * / ? @ [ ] ^ _ ` { | } ~ < > I need the report to ONLY show the EmployeeID for any employee that has the above characters in any of these fields: EmployeeMaster.EmployeeNameFirst...

I am using CR11 and have a report where I am trying to only look at employees whose last check date was greater than or equal to 01/01/2008. I have the report grouped by employee id and check and a maximum check date formula field in the group footer. I'm trying to suppress the group footer by...

I am using CR11. I am trying to do a record select formula that will look at multiple options for a field. The field gives the user the option of checking more than one box. I am trying to pull records for which certain options are selected even if more than one is chosen. Currently, my...