Search results for query: *

I am using SQL 2008R2 and need some assistance. This query gives me the result I need except the CLIENT_CODE (in the C table) that corresponds with the LASTEST_TRANS: SELECT max(T.TRANS_ENTRY_DATE)AS LATEST_TRANS, P.PAYEE_CODE, P. PAYEE_NAME FROM {PREMIUMS_TRANSACTION] TRANS INNER JOIN...

SSRS 2008R2 Hello, I need to have the results of a certain ID it one row rather than multiple rows. SQL (Simplified): SELECT ID, CAST(CONTACTDATE AS DATE) AS 'DT', DESCRIPTION, CAST(ASSOC_ROW AS INT) AS 'ROW' FROM SERVER.dbo.TABLE ORDER BY 'DT', 'ROW' Expression in SSRS - used in the group...

Hello, Excel 2013, SQL 2008R2 I am hoping this is the right forum and someone could point me in the right direction: I have a Stored Procedure with a "Customer" parameter linking to an excel spreadsheet. So far, I have an input box in Excel where the user can type the value and the command...

SQL Server 2008 R2 I have a stored procedure (simplified) for a SSRS report. The report runs fine but I'm getting an error using a 3rd party product relating to converting parameter value from a String to DateTime. ALTER PROCEDURE [dbo].[usrsp_S_Activity] @Start Date, @End Date, AS SELECT...

SQL Server 2008 R2 I have a query (simplified) within a SSRS report: SELECT CLIENT.NAME ,CLIENT.CLIENT_ID ,ACT_LOG.CREATE_DATE AS [Date] ,CLIENT.ACTIVE_IND ,Convert(Date,ACT_LOG.CREATE_DATE)AS 'DT_CREATE' FROM [CSPRDWEBSRV].[ACTIVITY].[dbo].[CLIENT] CLIENT INNER JOIN...

SSRS 2008 I am attempting to convert a report from Crystal and would love assistance with my issue. The groups are ID and Date. I need to only display the Comment from the most recent date for each ID and hide the rest. ID Row Date Comment 123 1 1/3/13 Remind me to call 123...

SSRS 2008R2 Hello, I am in the process of converting my reports from Crystal to SSRS. I am struggling with the following (which of course, I could do in Crystal): Group 1 Sales Person - Group 2 Client Group (grouped by Client Group, sorted Desc order by Commission): Client Group -- Client...

Hello, We are using GoldMine Premium 8.03. I have the following query (simplified) which I would like to add a column that indicates whether the contact is from the Primary or Additional table: SELECT c1.company ,c1.contact ,c1.phone1 AS Phone ,c1.accountno FROM contact1 c1 UNION...

Hellow, I am using Crystal XI with SQL database. There is a field {CONTACT.NAME} that may contain 2 names: Jones/Smith Smith Jones Evans/Jones I want the name to appear each time it qualifies. Many would be double-counted. Using If/then/else doesn't work becaue it only evaluates in order...

Hello, Access 2007. I have a field "Account" with this data: 12*2222*22 3*88888*779 99*22433*1 I would like a formula for "Location" that would return only the info between the "*": 2222 88888 22433 This formula almost works but returns the numbers with an * at the end: Location...

Hello, Access 2007 I have a field "Account" with this data: 12*2222*22 3*88888*77 999*22433*1 I would like a formula for "Location" that would return only the info between the "*": 2222 88888 22433 This formula almost works but returns the numbers with an * at the end: Location...

Hello, Using Access 2007 I need to have a query than returns the greater of 2 dates. This works if only if there are no nulls/blanks: MaxOfAAndB: IIF([DATE_A]>[DATE_B],[DATE_A],[DATE_B]) Can I use a NZ function with this query? If so, how? If not, what should I use? (I know I can use...

CR XI to an Access 2003 database. I have a formula {@getgroup} - "stringvar array x:=split({CLIENT.NAME}," - ");x[1]" which returns the result I need and matches the group.group field. I tried to incorporate the formula in a Command: select client.name, group.group, group.groupname from...

Hello, We are using MOSS 2007 I have a list and would like to create Choice columns that only show choices based on another columns data: Example: Column 1 Column 2 ClassType Class PPE Eye PPE Hand PPE Hearing Driving Accidents Driving Defensive If Column 1 = PPE then...

We are using Crystal XI against an Access database. The report is named "Client Activity." This report is grouped by Salesperson (GH1) then (Client (GH2). It has a date parameter which we generally run by a month's period of time. We are in need of a 3rd Party Tool tool to accomplish the...

I am using Crystal XI to connect to an Access database. There are 21 linked tables (plus 6 in a sub report) that are producing the correct results. I need to add another "TEAM_MEMBER" table and link the tables in such a way so that I only want the results when "OwnerInd"=1 Relevant...

Hello, Using Crystal XI. There are 2 groups: Group #1 - Salesperson Group #2 - Client In Group Footer #1 I have New Page After (to separate the Salespersons' part of the report using a blank page) and Reset Page Number After In Group Footer #2 I have New Page After What I want to accomplish...

We want to set up Issue Tracking (MOSS 2007) and only have the appropriate choices presented to the user based on another column. Is there some way to use the Calculated column type? Example: Column A - Dept - choices: Math, Science, History Column B - Classes - choices: Geometry, Algebra...

Is there a way to suppress the pop-up box for Email and Web Site entry? The users would be happy with the default and just want to enter the addresses by merely typing as they do with any other field. This is really slowing them down. Thanks! Jackie

We are using the Premium Edition of GoldMine and I need the Additional Contact information along with their Email addresses. Not every contact has an email address so I need the contact even when they don't have an email. This query would be perfect if it included the email: select...