Crystal Reports Crosstab

Hello Everyone,
Is there anyway I can repeat the row field values for each record in a crosstab report. Currently they only appear once per group.
Regards,
Omar Malikif u want to repeat row label then
u can repeat by checking repeat row label option in customize style tab of cross tab expert.

if u want to repeat field values
use a formula, assign same field to it and use formula in cross tab.

Crystal Reports 8.5 Objects Location Origin

Dear All, I am stuck up with a report printing in which the textfield's values are set at runtime, and the location of textfields are also set at runtime during report generation.
This report is also printing fine on normal printers. But not working on HP 9050 printer.
Usually when we specify x,y coordinates of an object by the location is calculated from upper left corner of the report page. The trend is normal in Crystal reports as well. But HP 9050 printer prints the Report from Right. (Print direction is from Right to Left). So if I have used a different pagesize in Report, and different pagesize in Printer Tray, the textfields are not printed on their x,y locations exactly.

Is there any solution to the problem?? Can we specify left and top positions of objects with upper right corner of page as origin?In such cases, the only reasonable solution is to use a printer driver that works normally. You can't battle every buggy driver in the world. Try a driver from another (older) HP printer, download a newer driver from internet, or dump the whole **** thing into the nearest trash bin. I mean it.

Crystal Reports - Finding Previous Record Values

Hi,

I'm trying to find out the previous value of a record in Crystal 10.

I know I need to use the previous({recordset}) to get it, however if the previous value is = to "something" I need to keep looking at down the recordset until the value does not = "something"

I know it needs to be something along the lines of

If Previous({group}) like "MGS CCT*" then

Else Previous({group})

Just not sure what fits in the middle.

Can anyone advise ?

Many thanks
Steve[ moved ]

Crystal Report displays wrong value.

Hi,

There is a issue in VB & Crystal report version is 8.5.
I have got a report which displays wrong values though the values returned from the database is correct. It displays all the numbers by dividing 100 to it. I am getting correct values in some of the machines but not in rest. For eg if the value returned from the database is 80 then the report displays the value as 0.8 in some of the machines which is wrong. How do I correct this wierd error? Is there any system based setting where in I could go and change? We have checked the following things and it seems to be correct (DSN settings, Reports Versions)

Crystal report version is 8.5. In users m/c, no crystal report is installed.
Please tell me are there any settings to be set in user machines.

Reply asap.

Regards
Shilpai hope ur problem will be solved if u follow the instructions here...

1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
NOTE: if it is system default then change it according to ur requirement.

if u r using "Customize" then do following
1) Click on "Customize"
2) Click on "Currency Symbol" Tab.
3) Make sure "Use System Default Format" is Unchecked.
NOTE: if it is checked then make it Unchecked.
Mostly people sets the format according to thier need but
ignore this option which makes such type of troubles.

Hope will be helpfull........Cheer up :D|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa|||Crystal report version is 8.5 .

I checked in the crystal reports on the
first step
1) Rt.Click on the Field.
2) choose "Format".
3) check which Style is selected in the "Number" Tab.
there is no system settings enabled.

Also I couldnt find option specified in the Currency Symbol tab...:

Please reply.

Regards
Shilpa

i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.|||i think u did not follow the second step..

1) Rt.Click on the Field.
2) choose "Format".(from the pop up window)

you will see "Format Editor" window like in "1-Second Step"
then watch "2-Second Step" and "3-Second Step" respectively.

I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.|||I have followed the above steps. But there is no Use System Default format option in step 2 that is in Customize section. You can see images attached for this. I think the version which u have worked is different. Here version is 8.5. Please tell me if you know anything.

i m using Crystal Report 8.5 and the problem i was expecting is not in your case.

i got rid of the same situation by the steps i told u.|||U can also change the Number format of those systems to that one on which u getting the correct result by

Start->Settings->Control Panel->Regional Settings->Numbers (Tab)

Crystal Report Datas Export to MS Access

Hi All,
Pls assist me....
I want to export the values from Crystal Report(8.0) to Ms Access. Pls me know if the procudes if itz possible..
Cheers
eam007Export drop down box in the Crystal Reports show "Export to Ms Access Database", but once i click the option, it pops up the 'select database option'. Once the database is selected and click OK, te popup windows closes.
If I oen the database, i find no datas exported from crysal report...

pls assist..

crystal Report

hi All,

i m using Vb 6.0,M.Access and crystal report 9

i have one form in vb which have id and date field,
i want to select values from that vb form and seaching records in table in Access and display record in crystal report....

plz..help ma...it's urgent..

Thanx in Adavance

Regards..

Sabina Maniar

U.A.epass parameters to crystal report , then use those parameter in report query or in record selection formula.|||Hi..

Thankx to reply

i have already pased a para to crystal report ,

but i dont know how to pass CR para in vb in crystal viewer...

plz...if u have any related topics then plz..plz...reply me..

thanx again

Regards,

Sabina Maniar
U.A.E|||Set Report = crystal.OpenReport(App.Path & "\report1.rpt")

Report.DiscardSavedData
Report.Database.SetDataSource rs
Report.ParameterFields(1).AddCurrentValue ("aaa")

You can use this method to set parameters..

Regards,
Ahmed

crosstab and time values

Hello! I'm new to Reporting Services and cross-tab reporting in
general. I
need to create a report that has days (dynamic cols) and a wait time
col (static) and across the top and categories down the left.
Visually I need to see:
Day 1 Day 2 Total
Wait Time Col2 | Wait Time Col2 | Wait Time Col2
______________________________________________________
Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
15
Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
21
______________________________________________________
Total 00:13:00 23 | 00:23:00 13
Is it possible to apply an aggregate function to a time value? If yes,
how?
Can someone point me in the right direction?
Thanks in advance.I forgot to say: i=B4m using reporting services 2000 SP2. I really nedd
help!|||I forgot to say - I=B4m using reporting services 2000 SP2. I really need
help!|||You need to use a matrix to achieve this, instead of a table.
Then have categories as row groups and days as column groups.
Add subtotals to both groups to have the totals.
Add a static column to the data field to have your Col2s.
Matrixes can be a bit confusing at first, but this is definately the control
you need to use.
Kaisa M. Lindahl Lervik
"kaustika" <rosa.cunha@.gmail.com> wrote in message
news:1158867347.399372.184490@.i42g2000cwa.googlegroups.com...
> Hello! I'm new to Reporting Services and cross-tab reporting in
> general. I
> need to create a report that has days (dynamic cols) and a wait time
> col (static) and across the top and categories down the left.
> Visually I need to see:
> Day 1 Day 2 Total
> Wait Time Col2 | Wait Time Col2 | Wait Time Col2
> ______________________________________________________
> Cat1 00:05:00 10 | 00:10:00 5 | 00:15:00
> 15
> Cat2 00:07:00 13 | 00:13:00 8 | 00:20:00
> 21
> ______________________________________________________
> Total 00:13:00 23 | 00:23:00 13
> Is it possible to apply an aggregate function to a time value? If yes,
> how?
> Can someone point me in the right direction?
> Thanks in advance.
>|||I think I didn=B4t explain myself very well.
My doubts are: IN A CROSSTAB static column: (i) is it possible to put
time values? (ii) The sql query must return what? A double, an integer
or a datetime? (iii) And how to apply an aggregate function (SUM, AVG,
MAX, MIN) to a time value?
Thanks in advance.

Cross tab stored procedure

Hi
I have a table with rows of timestamped values for given variables. Each of the variables are periodically inserted at the same time. ie
DateTime Variable Value.
T1 V1 xxxx
T1 V2 xxxx
T1 V3 xxxx
T2 V1 yyyy
T2 V2 yyyy
T2 V3 yyyy
In a SQLserver stored procedure I would like to insert this data into a temp table like the following. I don't need summaries just need a table or query where I can select on a variables value. ie "select * from temptable where V3 = yyyy"
Datetime V1 V2 V3
T1 xxxx xxxx xxxx
T2 yyyy yyyy yyyy
any suggestions for an SQL statement.
thanks in advance.
I don't exactly understand your business requirements. Are V1, V2, and V3 the only possible values for the Variable column? If so, something like this might help to get you started:

SELECT
DateTime,
MIN(V1),
MIN(V2),
MIN(V3)
FROM
(
SELECT
DateTime,
CASE
WHEN Variable = 'V1' THEN Value ELSE NULL
END AS V1,
CASE
WHEN Variable = 'V2' THEN Value ELSE NULL
END AS V2,
CASE
WHEN Variable = 'V3' THEN Value ELSE NULL
END AS V3
FROM
yourTable
) AS subQuery
GROUP BY
DateTime


|||

Thanks Terri

The base table contains many variables. The data in this table is produced by a periodic time base event which inserts a row for each of the variables along with their current value. What I am trying to achieve is a record set where I can compare the values of selected variables in a single row based on the timestamp. ie
DateTime Var1 Var2 Var3
1/1/2005 10:00 Product1 10 20
1/1/2005 10:05 Product2 9 15
1/1/2005 10:10 Product2 12 30
1/1/2005 10:20 Product1 15 16
Once I have this record set I can then do selections based on the value of any variable ie
"select * from recorset where Var1 = 'Product1'"
I tried a statement similar to the one you have posted but my case statement sintax wasn't quite right.
I'm not in the office for a few days so may not get a chance try your code.
regards
Noel

CROSS JOIN query with a TRUE/FALSE values

I am using SQL Server. Having two tables
Table T1:
ID Name
--
1 A
2 B
Table T2:
ID Description
--
1 a
2 b
SELECT * FROM T1, T2 gives:
1 A 1 a
1 A 1 b
2 B 1 a
2 B 2 b
========================================
===================
Question:
How to apply additional column (of a type bit) that would cross join
original query by combinations TRUE / FALSE, resulting something like
this:
1 A 1 a TRUE
1 A 1 b TRUE
2 B 1 a TRUE
2 B 2 b TRUE
1 A 1 a FALSE
1 A 1 b FALSE
2 B 1 a FALSE
2 B 2 b FALSE
Was thinking about creating a temporary table. But hoping for any
single query solutions. Thanks for your time, Boris.In fact there are no TRUE/FALSE values in SQL Server because it doesn't have
an explicit Boolean datatype you can use in columns. BIT is a numeric type
but conventionally developers often use it to represent TRUE and FALSE. I
think this may be the answer you are looking for:
SELECT *
FROM T1, T2,
(SELECT CAST(0 AS BIT) UNION ALL
SELECT CAST(1 AS BIT)) AS T(b) ;
David Portas
SQL Server MVP
--
"rubberbong@.yahoo.co.uk" wrote:

> I am using SQL Server. Having two tables
> Table T1:
> ID Name
> --
> 1 A
> 2 B
> Table T2:
> ID Description
> --
> 1 a
> 2 b
>
> SELECT * FROM T1, T2 gives:
> 1 A 1 a
> 1 A 1 b
> 2 B 1 a
> 2 B 2 b
> ========================================
===================
> Question:
> How to apply additional column (of a type bit) that would cross join
> original query by combinations TRUE / FALSE, resulting something like
> this:
> 1 A 1 a TRUE
> 1 A 1 b TRUE
> 2 B 1 a TRUE
> 2 B 2 b TRUE
> 1 A 1 a FALSE
> 1 A 1 b FALSE
> 2 B 1 a FALSE
> 2 B 2 b FALSE
> Was thinking about creating a temporary table. But hoping for any
> single query solutions. Thanks for your time, Boris.
>|||Pl try code below
create table #t1 (id int, Name varchar(1))
insert into #t1 values (1, 'A')
insert into #t1 values (2, 'B')
create table #t2 (id int, Name varchar(1))
insert into #t2 values (1, 'a')
insert into #t2 values (2, 'b')
select * from #t1, #t2,
(
select [col] from
(
select 'TRUE' [col]
union all
SELECT 'FALSE'
) a
) a
drop table #t1
drop table #t2
Rakesh
"rubberbong@.yahoo.co.uk" wrote:

> I am using SQL Server. Having two tables
> Table T1:
> ID Name
> --
> 1 A
> 2 B
> Table T2:
> ID Description
> --
> 1 a
> 2 b
>
> SELECT * FROM T1, T2 gives:
> 1 A 1 a
> 1 A 1 b
> 2 B 1 a
> 2 B 2 b
> ========================================
===================
> Question:
> How to apply additional column (of a type bit) that would cross join
> original query by combinations TRUE / FALSE, resulting something like
> this:
> 1 A 1 a TRUE
> 1 A 1 b TRUE
> 2 B 1 a TRUE
> 2 B 2 b TRUE
> 1 A 1 a FALSE
> 1 A 1 b FALSE
> 2 B 1 a FALSE
> 2 B 2 b FALSE
> Was thinking about creating a temporary table. But hoping for any
> single query solutions. Thanks for your time, Boris.
>