Search results for query: *

I have data that I am exporting from an application in CSV format. I'm creating a pivot table with that data and for one larger set of values the pivot table is converting the resulting value to scientific notation. When I try to format the cell to change it to numeric it sets the value to...

I am a novice script writer. I am trying to write a stored procedure that will include some nested IF statements. The basic concept of the first statment in plain English is: If condition A is true AND condition B is true, then execute the next If statement: If Date A is greater than Date B...

Crystal Reports Version 9 I have a very basic formula that does the following calculation: If {Invoice.PRODUCT_CODE} = "BROAD" and {Invoice.BILL_AMOUNT} = 4295 then 11 else if {Invoice.PRODUCT_CODE} = "BROAD" and {Invoice.BILL_AMOUNT} = 895 then 2 else if {Invoice.PRODUCT_CODE} = "REG" then...

I am using a version of Crystal 10 that ships with an accounting software package that we use. I can not run this version of Crystal as a stand-alone app without firing up the accounting app. I'm trying to use Crystal to create mailing labels and I'm using the mail label wizard, but when I get...

I'm a new SSRS user - using Visual Studio 2008. I need to build a report that provides a list of contacts for an organization, like so: Mary Jones Director ABC Company 123 Main Street Anytown, CA 11111 (444) 555-1212 Mjones@abccompany.com Scott Smith ABC Company Sales Associate 123 Main...

Crystal version 9. I have a report that currently has the following group/sorting options: Group 1, sorted ascending: Product Group 2, sorted ascending: Product Subcategory Details, sorted Ascending: Customer Lastname_firstname I need to add a third group for customer parent company, sorted...

Crystal 9.0 I have a report that calculates the count and total balance due for items based on two different codes – A and B. There is a sub-report as well which lists the details for each of the two codes. My issue is that when I run the report, the sub-report is totaling the count and...

I have Table A that contains: ID, Name I have Table B that contains: RelationType I want to be able to create a view that shows one row for each ID in Table A for each of the RelationTypes in Table B. So if there are three different RelationTypes, my results would be: ID...

Crystal 9.0 I need to build a report that lists a board's members. Then, if any member of the board has an administrative assistant(s), those names should be listed in a second column. I am using a sub-report to list the assistant name, which is working just fine if I list the assistants...

Crystal 9. I found an article on this site that seems to be similar to a problem I’m having, but I’m not sure it’s exactly the same: http://tek-tips.com/viewthread.cfm?qid=1582683 I have a report that is grouped by GH1 - task force name GH2 - ranking on task force (chair, vice chair, member...

I followed the FAQ in the forum for how to create a mailing label report to similarly create a 2-column badge report. The data appears in the proper number of rows/columns, but I am having several other formatting issues: 1) The data in the second column is printing ever-so slightly higher...

I am trying to create a 2-sided Name Tent in SSRS. I have created two lists side-by-side on the report and by changing the Writing Mode to tb-rl have gotten the text to rotate so that it prints from top to bottom. Everything appears correctly in the left column using a combination of writing...

I am trying to create a stored proc to be used to insert values into a table. This is my stored proc: USE [My_DB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_TC_MyProc] @MemberID varchar(10), @MemberOption varchar(50) AS BEGIN SET NOCOUNT ON; IF...

Here's an example of my data: ID VALUE 100 A 100 B 101 C 101 D I want the result to be: ID VALUE1 VALUE2 100 A B 101 C D There are always only 2 values for each ID. I am using SQL 2000 so PIVOT is not an option, besides which this isn't exactly similar...

Crystal Version 11 I have a report with multiple groupings that has been created as a 3-column report. The data is grouped as follows: Group 1: Event Name Group 2: Company Name Group 3: Attendee Name The details section of my report is suppressed. My issue is that I don't want the...