Search results for query: *

I have a report that gives me Customer Number, Name, Credit Limit, Sales Rep, Current Year Sales, Current Year High Balance, and then sales and high balance for last year. The problem is, my high balance that I currently have is the largest invoice amount. I need to work this query --- start...

I have a query that pulls transaction date and amount per customer. I would like to add to my select statement a method to calculate Current Balance owed by the customer and the Highest Balance Owed over his history with us. Thanks in advance! Jason select transdate,amountmst from custtrans...

I have a portion of a select formula {AAcsbycpi.glpostdt} >= Date(Year(Maximum({?Date Range}))-1,1,1) that gives me everything from the current and previous year in my report. I received word that February data for this year and last are off. I presume this is a leap year issue? Thanks Jason

I have a database with products and location codes. fields: itemnmbr,locncode Every item should have a locncode M. We want to find out which items do not have M but have any other locncode. We also need to ignore items that have a blank locncode field. The database has a record for each...

I am using the Fileserver Migration Toolkit to move shared directories from one fileserver to the next. I elected not to use DFS as I prefer my new file server to be simple (sans extra services). The toolkit copies the shares and permissions with ease, but appends the old fileserver name to...

in version 8.x, I have a report that pulls data from two date ranges (this year and last). The problem is, there is no data in my database for days where there is no data entered by a user. How do I display in my report a date from the range that does not have data with a Zero in place of the...

I have a report that pulls data from both a date period in the current year and the same period last year. I would like the report to display by day with the current date range ascending on the left with last year's data on the right. Currently, my report is What programming magic do I have...

I have a date range formula IF {V_Sales_History_w_Ecomm_Attributes.glpostdt} = {?Date Range} THEN {@Shortened GL Date} And I would like to create a second formula that leverages a condition of {?Date Range} minus one year. My report pulls two sets of dates; a date range from this year and a...

My current selection criteria: record Selection Formula not ({RM00101.CUSTCLAS} in ["50IC", "50R", "50W", "IC"]) and {Sales Trx History.VOIDSTTS} = 0.00 and {Sales Trx History.SOPTYPE} in 3.00 to 4.00 group selection formula {Sales Trx History.GLPOSTDT} in {?Date Range} When I add {Sales Trx...

I have a query that pulls product attributes from a temp table and marries the values with data in a table. My intent is to take each of the 13 rows and create a single row with the values from @productAttributes (attributeLabel in the query results) becoming the column name and the values from...

I have a trigger running on a table that contains customer info. When payment terms are changed, the trigger fires to send a message to a couple of people. I am having problems with sp_send_dbmail permissions. If I assign a single user access to msdb and assign that single person the...

I have a report that analyzes data based upon prompting for a date range. Within the report, I am looking at sales data from this range, the same range last year, and the YTD for the current range year and the prior range year. My Select Expert Formula and Show SQL results are below. It...

I have a string parameter (Allow multiples; Discrete & Range) that I would like to display in the header of the report as a reminder of the values sought. Is there a standard function in CR 8.x that will display this? Jason

I have a join (I took the language from a crystal report "show query" window) that returns double records. The views joined v_Combinetable1 v_Combinetable3 v_Combinetable2 are each unions of two identical tables in differing databases. Can anyone shed light onto the below query returning...

I have the following two NICs on a monitoring server Ethernet adapter Local Area Connection 2: (Metric 1) Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.55.10 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . ...

I have a database of all US Zip codes. I've put together syntax to pull all zip codes from a radius of miles. I have two additional tasks to perform: 1. Calculate distance from each record returned to the original zip code 2. Use the result set from the query below to pull customer data...

I have a report that is running through a stored proc in MS SQL Server. When I created the report two parameters were automatically created for @startdate & @enddate I would like to delete those parameters and instead prompt for a single parameter using a range, then use a formula to send the...

I am running a separate SQL server to run reports against and to serve as an audit for our daily backup. I need some assistance with copying user names and passwords over to the reporting sql server (different machine) and would like to automate the update process with scripting if possible...

On my production SQL2005 server, I run a nightly maintenance job that writes all of my user databases to .bak files to be picked up on the nightly tape backup. I have a second SQL2005 server that I want to restore my daily .bak files to for reporting and development. How do I either 1. have...

I have a report that prompts users for a date range, then the date range is split into two formula fields: start prompt date Minimum({?Date Range}) end prompt date Maximum({?Date Range}) For the sake of simplicity, I would like to have the start prompt date be the first day of the current...