I am using Crystal Report 2008. I have one subreport that displays top 20% summary and I need to pass an unique id which is a string to a detailed subreport of the top 20%. Any information would on how to best resolve this would greatly appreciated.
I am using Crystal XI2. I have the following sample of how the data is structured.
Column A Column B
1 A
1 B
1 C
2 B
2 C
2 D
2 E
3 F
and I need Column B to either column with one row for Column A, or concatenated would work. I can have up to 22 columns.
Column A Column 1...
I am using Cryatal XI r2. I have a crosstab:
The rows are grouping by State and City with column by each week and a count of people over trailing 12 months. The issue is I want state to populate on each row when exported.
7/6/2008 7/13/2008 7/20/2008
IL Chicago 10...
I am using SQL Server 2005. I am trying to get date function where year changes each year but my month and day stay the same. I need for ex... '2008-12-01' current, next year it would be '2009-12-01'. It will always be the beginning of the static month.
Thanks in advance.
The problem I had with using a text box with a vertical line was that one of the fields is "Can Grow" and it give me gaps in the line. The other issue with the text box is that the line didn't need to be at the edge of the field. It is an odd report but that is the format I have to match.[neutral]
lbass
I am using actual lines and boxes (existing format) and the report actlually looks like a spreadsheet so I guess that is why I referred to it as a 'cell', it is actuall just a field with a background applied. I just wanted the line to show over the background.
Thanks
I am trying to format a report with lots of data and I need certain cells to be shaded. I also need to have some vertical lines and boxes seperating the data. What is happening is that as the lines pass through the cell backgrounds they are overwritten by the background.
I have tried moving...
Using SQL Server 2000
I have the following example that is used multiple times through queries
TERR IN('I01','I02','I03')
Terr is VARCHAR.
I am not sure how to do it or if it is even possible to change the example above to the following
DECLARE @ABC VARCHAR(??)
SET @ABC = ('I01','I02','I03')...
Thanks for all the insight on my problem. I will look more into the join factor due this being common request.
The ultimate problem I was having, for some reason couldnt think outside the box, is all fields were text and needed convert to number.
This what I ended up with:
@Match
if...
Using CR10 and SQL Server db. I have a table that has City State Zipcode and I have another table that has State Zip_Start and Zip_End with an Identification Field. I am trying to match Table 1 using State and Zipcode and return the ID field from Table 2. My problem is that linking to stat is...
I am using SQL 2000 and I have the following query.
SELECT C.CONTACT_ID,
TH.TRADE_YEAR,
MAX(TH.POSTING_DATE) AS ENDOFWEEK,
DATEPART(WK,TH.POSTING_DATE) AS WEEK,
ISNULL(CASE
WHEN TH.TRADE_CLASS IN ('S','Z') THEN SUM(TH.GROSS_AMOUNT)...
This is a manual crosstab with 7 columns A-G
//@Week
DATEPART("ww",{Command.POSTING_DATE},0)
//Column A 5wk(repeated for B-G)
SELECT {@Week}
CASE 9 TO 13 : {Command.A}
CASE 21 TO 26 : {Command.A}
CASE 35 TO 39 : {Command.A}
CASE 49 TO 53 : {Command.A}
DEFAULT : 0
//Avg of Column A (Repeated...
I am using Crystal 10 with SQL Server.
Data sample below is currently what I am producing.
With this sample the 5 week Total Sales and 5 week Moving Avg are in the same grouping.
Currently being group by Quarter.
What I am looking to include on this report is on each grouping take the avg...
I am using SQL Server 2000
this statement gives me this error "Incorrect syntax near the keyword 'AND'".
DECLARE @TERR1 VARCHAR(15)
SET @TERR1 ='RM1'AND'RM2'AND'RM4'
SELECT RP.TERR1
FROM dbo.REP_PROFILE RP
WHERE RP.TERR1 =@TERR1
I can get this to work for single item but not for multiples...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.