Error Passing Paramater

Hello Babu,

I am trying to open a crystal report from VB. Everything works fine.
When I am trying to assign a date parameter value, I get the error "Type Mismatch".

ie. txtdate="14/06/2004"
Report.ParameterFields(1).AddCurrentValue txtdate

where txtdate is a date variable.

I also tried cdate(txtdate)

when I try to pass variables other than type date it works fine.

Regards ,
SatishHi,

I passed a value from a DTPicker control. It works fine. Check the datatype which you have set while parameter creation. It'll work.

And try DTPicker. I used the same code as yours.

Report.ParameterFields(1).AddCurrentValue DTP1.Value

Regards,
harmonycitra|||Hi,
When passing the date make sure that the date is of the format of the system date.

Madhivanan

Error on viewing Crystal Report

hello,

i designed an application containing Crystal Report in VB.NET and viewed the application and Report successfully on my system. But when i try to execute the same packaged application on a different system, i get an error message saying that a dll cannot be found or invalid code.

Please help me to debug the application.check the CrystalRuntime|||You need to install Crystal Report Runtime module.
Please check this thread (http://www.dev-archive.com/forum/showthread.php?t=432198).

Error on this query- worked until recently

This is the T-SQL I scraped out of a Crystal Report that worked until 4pm
today:
When I run the following:
SELECT "Account"."OpenDt", "CustRelation"."RelationCode",
"CustRelation"."FullName", "Userfield"."UDFCuthr5", "Userfield"."UDFCufiv1",
"Userfield"."UDFCufiv2", "Account"."AcctId", "CustRelation"."Sequence",
"Account"."OpenedById_CustLoginId", "ViewSessionEvents"."OpenDt",
"ViewSessionEvents"."AcctId", "ViewSessionEvents"."ProdId",
"ViewSessionEvents"."EventStatus", "ViewSessionEvents"."EventCode",
"ViewSessionEvents"."EventTime", "SalesSession"."BranchID",
"Customer"."EvePhone", "Customer"."DayPhone"
FROM ((((("CBSDesktop"."dbo"."ViewSessionEvents" "ViewSessionEvents"
INNER JOIN "CBSDesktop"."dbo"."Account" "Account" ON
"ViewSessionEvents"."AcctId"="Account"."AcctId") INNER JOIN
"CBSDesktop"."dbo"."SalesSession" "SalesSession" ON
"ViewSessionEvents"."SalesSessionId"="SalesSession"."SalesSessionID") INNER
JOIN "CBSDesktop"."dbo"."CustRelation" "CustRelation" ON
("Account"."AccountID"="CustRelation"."AccountId") AND
("Account"."PrimCustId_CustPermId"="CustRelation"."CustPermId")) INNER JOIN
"CBSDesktop"."dbo"."Person" "Person" ON
"CustRelation"."CustPermId"="Person"."CustPermId") INNER JOIN
"CBSDesktop"."dbo"."Userfield" "Userfield" ON
"Person"."PersonID"="Userfield"."CustomerId") INNER JOIN
"CBSDesktop"."dbo"."Customer" "Customer" ON
"Userfield"."CustomerId"="Customer"."CustomerID"
WHERE "ViewSessionEvents"."EventCode"=N'ACCTADD' AND
"ViewSessionEvents"."EventStatus"=N'Complete' AND
"ViewSessionEvents"."AcctId"<>N'null' AND
("CustRelation"."RelationCode"=N'JAF' OR "CustRelation"."RelationCode"=N'JOF
'
OR "CustRelation"."RelationCode"=N'OWN' OR
"CustRelation"."RelationCode"=N'SOW') AND
("ViewSessionEvents"."EventTime">={ts '2005-10-02 00:00:00'} AND
"ViewSessionEvents"."EventTime"<{ts '2005-10-09 00:00:00'}) AND NOT
("ViewSessionEvents"."ProdId"=N'546126' OR
"ViewSessionEvents"."ProdId"=N'587403' OR
"ViewSessionEvents"."ProdId"=N'987001')
ORDER BY "SalesSession"."BranchID", "Account"."OpenedById_CustLoginId",
"Account"."OpenDt", "Account"."AcctId", "CustRelation"."Sequence"
I get:
Server: Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !, <, <=, >, =>, or when the subquery is used as an
expression"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:A2D04ADB-523A-4B82-9D99-BB81292EA90F@.microsoft.com...
> This is the T-SQL I scraped out of a Crystal Report that worked until 4pm
> today:
> . . .
When rows were added causing a subquery which previously returned a single
row to return more than one value:
Server: Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !, <, <=, >, =>, or when the subquery is used as an
expression
It this query appears to lack subqueries, but there could be some in the
views on which it's based.
David

Error Message when accessing Report Manager

Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this? How do I fix this?

Product:SQL Server Reporting ServicesEvent ID:rsReportServerDisabledSource:Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.StringsVersion:8.00Message:Unable to encrypt or decrypt data managed by the Report Server instance. Please refer to the Reporting Services online help for guidance in enabling this functionality.

Explanation

A symmetric key is a single key used to encrypt and decrypt data. Reporting Services encrypts the symmetric key itself, using the public key of a specific user account on a specific computer. This error occurs when the public key that the user account provides does not match the public key that report server is expecting. Conditions that cause this error to occur include changing the name of a report server instance, moving the report server instance to a different computer, or changing the account under which the Report Server service runs.

User Action

A system administrator on the computer running the report server service can use a backup copy of the public key to get the report server running again. Use the rskeymgmt utility to apply the backup key set. If you do not have backup of the key, you must run the rskeymgmt utility to delete all of the encrypted content, run the rsconfig utility to respecify the encrypted connection values used to connect to the report server database, restart the service, and retype stored credentials for all reports that use stored credentials. For more information this utility, search Books Online.

---

The encryption keys are tied to the service account user. If any of those programs reset the ASP.Net account, it would cause this error.

Have you tried following the steps listed under "User Action"? Depending on which accounts were reset, you might be able to use rsactivate -r if you do not have a backup key.|||Brian:

Pardon my lack of knowledge but exactly how does one access the "rsactivate -r". Do I type this into the "run" text block?

I have found the rskeymgmnt.exe & rsconfig.exe files. Rvery time I click the executable the command window pops open & immediately closes.

I apologize for asking such elementary questions but it is difficult to get answers outside of the expert forums.

Thanks, Jack|||Brian:

Can you tell me how to retrieve a backup key? I default installed SQL Server 2000 and later Reporting Services. I do not recall setting up a backup key. Can I use rekeymgmt -e to extract a key to a text file? Can I use rekeymgmt -a to apply it before I try to get into Report Manager?

When you say "any of those programs reset the ASP.Net account", I assume you are referring to either Oracle Express or Crystal Reports?

Do I type rsactivate -r into the "run" text box? Do I type any other characters with it? Do i need to type a specific account name with the reset commandor will a generic "rsactivate -r" reset all.

I am obviously a beginner. I would appreciate the help.|||Rsactivate and rskeymgmt are command line tools. You will want to open a command window and run the programs from there. You can run rsactivate /? and rskeymgmt /? to get more help on other flags you will need. Also see the MSDN documentation at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_29ly.asp for example usage and a description of what the various flags do.

Error message "E"

Dear All,
I am trying to deploy my application (develop in VC++ and for reporting i used crystal report 9).

I am getting an error message while trying to view the report, the error message is just "E".

I have registerd the control crystl32.ocx and also copy the CRPE32.dll file on the system.

But still this stupid message is appearing ...

Any suggestion ?Dear All,
I am deploying the following two files with my exe file
1- CRPE32.dll and
2- CRYSTL32.dll

but my application is unable to display the report on client system, I need some other files necessary to run this report with my exe.
But don't know what other file names are :(

any body can help me in this regard ... ?|||Any body here ?