Crystal Reports 10 - Export Function does not work

Hello,

I have Version 8 and Version 10 Professional of Crystal Reports installed on my PC. When I embed a Preview window for Crystal Reports using crpe32.dll (version 8), I can click on the Export option ... and export to anything.

When I use the crpe32.dll (10.0.0.533) for Version, everything works except the Export button. I just get a cursor wait for a second and nothing happens.

If I open Crystal Reports Version 10 Professional and run the report from there, I can select FILE / EXPORT and get the Export Dialog box without any issue.

What is needed to make this work ... and what is needed for end-user distribution. The end-users are responsible for writing their own reports, and I don't want to require a certain version (8, 9,10,etc) -- what am I missing?

Thank you very much.I am having the same problem except I am converting from Crystal 6 to Crystal 9. Let me know if you get a fix for this.

Thanks!|||Still now answer?

Does anyone know - who can help me with this?|||There is a Crystal Reports 10 hot fix for this problem. Go to http://support.businessobjects.com/search/ and search for "crystal reports runtime error export excel". I downloaded and installed it and am able to export now.

Crystal Reports

Sample Code:

-----------------------
g_m_cnnRAM.BeginTrans
ChangeClosingStock // The Function Which Holds Views

crReports.SQLQueryString = Select LotNo, Variety, Cl_Kgs, Value from ClosingStockView

frmViewer.Show
frmViewer.CRViewer1.ReportSource = crReports
g_m_cnnRAM.CommitTrans
frmViewer.CRViewer1.ViewReport
frmViewer.CRViewer1.Zoom (1)

------------------------

The Above is the Sample Code. After the CommitTrans, the ViewReport is Called. At this time if ClosingStockView is Altered, I Get the Someother Modified Data instead of my Data. If I give CommitTrans After ViewReport the System gets Hung.

Find me a solution for this.

Ashok.SSend me the code so that I can check

Crystal Report 8.0, Summary function !

Friends,

I'm working with crystal report 8.0 and SQL server.

I need to create a formula in group section, which should return the summary value of next group.

Or is there any function for get summary value if the group value is 'x'. same as SumIF( , , ) in excel.You need to write a formula having the code

If groupvalue='x' then
{field}

and use the summary using this

CryptoAPI Function failed error

Hi all

I am facing this error can you help me please it is urgent

CryptoAPI function 'CryptAcquireContext' failed. Error 0x80090006: Invalid Signature.

thank you allhttp://support.microsoft.com/default.aspx?scid=kb;en-us;811886

CryptoAPI function 'CryptAcquireContext' failed

Hi,
I am receiving the following error after installing MSDE
on a machine with NT 4.0 SP6a:
MSSQL Server logon. Connection failed. SQL State 42000 SQL
Server error 552
[Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI
function 'CryptAcquireContext' failed.
Error 0x8009001d: Provider DLL failed to initialize
correctly.
I have found the following KB article which addresses
this, but don't know how to sign on to the server using
sysadmin login.
http://support.microsoft.com/default.aspx?scid=%
2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D32 1459
If anyone has seen this before would be very interested to
hear.
Many thanks,
Mark.
Yep... I've had this problem - or rather a customer 4000 miles away did.
As we were unwilling to advise the customer to do the fix - as we'd be the
ones responsible for 'trashing the machine' if it went wrong, we gave the
customer a link to the article. They didn't fancy doing it, their IT
looked at it and did not want to do the BOOT.INI thing either.
They upgraded subsequently to Win2K, bringing forward that users upgrade
window.

Cross-tab query definition problem

Hi there,
I have got this problem. I want to know which concrete combination of 7
variables gives the maximum value of some non-linear function. I have
created 7 tables (per 1 column) with all possible values of each
variable (e.g. for the first variable: 0.00,0.01,0.02,0.03,...,1.00)
and then made the cross-tab query based on these 7 tables: Select
Max(...) from dbo.var1 cross join dbo.var2 ... cross join dbo.var7.
This query finds the maximum value of the function but how should I
find out which concrete combination of the variables is connected with
this max.value?
I know that it is not clever to use relational DBS for this problem but
I want to find out how quickly SQL server calculates the result.
Thanks a lot.
MilanHello, Milan
You are talking about cross joins, not crosstabs.
You can get the values using something like this:
SELECT Col1, Col2, ...
FROM Table1, Table2, ...
WHERE YourExpression=(
SELECT MAX(YourExpression)
FROM Table1, Table2, ...
)
If you have 7 tables with 100 values each, that would be a total of
100000000000000 combinations (that is one hundred thousand billions). I
would not dare to think how many years it would take for SQL Server to
return the result of this query.
Razvan|||Hello Razvan,
Thanks for your answer. I am sorry for that mistake, of course I ment
cross joins :).
The problem with your solution is that expression for every
combinations have to be calculated two-times. Since the total number of
combinations is great (the number of rows in each table is: 100, 20,
10, 10, 10, 5, 20 resp., which gives 200 mil. combinations) there is a
serious problem with calculation. Is it somehow possible to obtain the
concrete combination of variables which yield the maximum value of that
function within one single query'
Thank you.
Milan|||Another way would be:
SELECT TOP 1 WITH TIES Col1, Col2, ...
FROM Table1, Table2, ...
ORDER BY YourExpression DESC
Razvan

Cross Tab function?

I have my data summed and groupd properly to send to Crystal for a cross
tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
fit with the total.
So is there a Cross Tab function that I have missed that will gen the
dataset form me?
TIAHow will doing the work in SQL Server instead of Crystal have any effect on
the amount of data you can fit on a piece of paper? This sounds like a font
size issue to me...
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||Sorry Stephen,
there's no such thing like a cross-tab function in SQL 2000 (it is in
2005) but you can create a cross-tab report by using CASE. There's a
good example in BOL, just search for cross-tab report
M|||Stephen,
Might look at:
http://support.microsoft.com/defaul...b;EN-US;q175574
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:e7yygQB0FHA.1132@.TK2MSFTNGP10.phx.gbl...
>I have my data summed and groupd properly to send to Crystal for a cross
>tab. Unfortunatly I can't get a 12 month dispaly on a landscape paper to
>fit with the total.
> So is there a Cross Tab function that I have missed that will gen the
> dataset form me?
> TIA
>|||"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OGad6VB0FHA.2312@.TK2MSFTNGP14.phx.gbl...
> How will doing the work in SQL Server instead of Crystal have any effect
> on the amount of data you can fit on a piece of paper? This sounds like a
> font size issue to me...
Because Crystal determines all sizes for columns, and I can get them smaller
if I had all the rows preset in the dataset. If I controled it, I may be
able to make it happen.

Cross Apply Function

I am unsure how to select data within one table, and then select additional data from the result set.

There is an audit log table with columns:

Year, Month, Amount, AuditType, UniqueID, DateTime

AuditType: O = Original

AuditType: U = Update

Sample Data:

2007, January, 500, O, 333555, 3/10/2007 3:30:00 PM

2007, January, 1000, U, 333555, 4/10/2007 3:30:00 PM

2007, January, 1200, U, 333555, 5/10/2007 3:30:00 PM

2007, February, 500, O, 333556, 3/10/2007 3:30:00 PM

2007, March, 500, O, 333557, 3/10/2007 3:30:00 PM

I am trying to find all Updates in the table, ie where AuditType = U.

Then, for every Update, I want to see what was updated, ie the last record with that same UniqueID. Im guessing I should use an INNER JOIN or UNION with a SELECT TOP 1 ORDER BY DateTime but not sure how do to this.

Data returned should be:

2007, January, 1000, U, 333555, 4/10/2007 3:30:00 PM, 500

2007, January, 1200, U, 333555, 5/10/2007 3:30:00 PM, 1000

Any ideas greatly appreciated!

Which version of SQL Server do you use?|||SQL 2005 SP1|||

You could use CROSS APPLY statement:

Code Snippet

create table Log(

[Year] int,

[Month] varchar(10),

Amount decimal,

AuditType char(1),

UniqueID int,

date DateTime

)

insert into Log values(2007, 'January', 500, 'O', 333555, '3/10/2007 3:30:00 PM')

insert into Log values(2007, 'January', 1000, 'U', 333555, '4/10/2007 3:30:00 PM')

insert into Log values(2007, 'January', 1200, 'U', 333555, '5/10/2007 3:30:00 PM')

insert into Log values(2007, 'February', 500, 'O', 333556, '3/10/2007 3:30:00 PM')

insert into Log values(2007, 'March', 500, 'O', 333557, '3/10/2007 3:30:00 PM')

--Returns previous update

CREATE function udf_earlyUpdate(@.ID int,@.dt datetime) RETURNS TABLE

AS

RETURN SELECT TOP 1 Amount FROM Log WHERE UniqueID = @.ID and date<@.dt ORDER BY date DESC

select * from LOG CROSS APPLY udf_earlyUpdate(UniqueID,Date)

WHERE log.AuditType='U'

|||

I'm a bit confused about your goals.

You indicate that

the last record with that same UniqueID

, but your expected results show two records for the same UniqueID.

From you description, I would have expected that you wanted only one record for UniqueID 333555.

Please clarify.

|||

Every update should have one record. But a record with the same Unique ID can be updated multiple times.

The results should show every update, even if its the same Unique ID and what was updated.

|||

Here's the basic idea, I'll leave it to you to fill in the specific blanks.

select <alias>.columns

from (<any select statement that you want to specify, if calcing aggregates, alias each column) AS <alias>

Why does this work? A select statement simply returns a result set, which has exactly the same definition as a table. If you make sure each column in the select statement has a specific "column name", then it works just like a table. So, you simply wrap parens around the select statement within the FROM clause. The key to the whole thing is that you alias the select statement so that it really can be referenced in memory looking just like a table.

|||

The CROSS APPLY function works great with a simple SELECT. However, when I attempt to create a VIEW with this function combining two tables, I get an error because they contain the same column.

How can I get the result of the Function without using SELECT *, ie without selection all columns?

"Column names in each view or function must be unique. Column name 'BUDGETAMT' in view or function 'V_BUDGET_UPDATE_ALL' is specified more than once."