Crystal Report

[dixxie]

I have an image field in the database which stores text with its RTF.How can I show this column data in crystal report .Also I want to display it with its RTF.Please give me areply ,thanx

[Ram15]

Hi Babu advance thanks for UR help.

I am working on crystal reporter. I am basically a starter. My problem is

I want to create Crystal reports in VB with Access as a database.

I have to select certain fields from different database tables and display them in the report. Here the condition is I must select records of that pericular day(sys date basis). ie If I am creating a report today I have to select fields from the records I have added today.

And user will key in the date on which he wants the report from the keyboard(using textboxes).

Hope U understand my problem. If U need any other information pl let me know. As it is bit urgent, I await ur earliest reply.

Thank You very much for UR help

Cheers and Regards
Ram

[bikashg]

Hi Babu,

I am new to crystal reports and want to get started on it. could you please suggest me how to gain access some good documentation on crystal reports.

Thanks & Regards,
bikash

[shashibhushan]

Dear Babu

I have made a project for which i need to set page size of 7.5''x8''
with printer driver not supporting this size(note that my printer is DMP.) Is there any way to explicitly define the page size for output.

Regards

Shashi bhushan

[amlooks]

I have crystal reports available which are desgined in CR7.0 & sql server for my client server application.
I was passing query and formula fields from my application throught vb's exe.
All reports are created using report designer & with ODBC DSN for inserting views into report. now i am
upgarding same to web application using ASP & IIS.
Which is the best method to show reports in asp??
Changing sqlquery at runtime means using session("oRpt").SQLQueryString or should i use recordset?
i am attaching code for SQLQuery

<%@ LANGUAGE="VBSCRIPT" %>
<%
reportname = "SimpleSQLQuery1.rpt"
If Not IsObject (session("oApp")) Then
Set session("oApp") = Server.CreateObject("Crystal.CRPE.Application")
End If
Path = Request.ServerVariables("PATH_TRANSLATED")
While (Right(Path, 1) <> "\" And Len(Path) <> 0)
iLen = Len(Path) - 1
Path = Left(Path, iLen)
Wend
If IsObject(session("oRpt")) then
Set session("oRpt") = nothing
End if
Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)

// code to be written to connet to SQL Server

NewSQLQueryString = "Select Product_Master.Product_Name from Product_Master"
session("oRpt").SQLQueryString = cstr(NewSQLQueryString)
On Error Resume Next
session("oRpt").ReadRecords
If Err.Number <> 0 Then
Response.Write Err.description
Response.Write "An Error has occured on the server in attempting to access the data source"
Else
If IsObject(session("oPageEngine")) Then
set session("oPageEngine") = nothing
End If
set session("oPageEngine") = session("oRpt").PageEngine
End if
%>

Using above code i am getting following error ...

Error Type:
cpeaut32 (0x800A5077)
Cannot open SQL server.

How can i connect to SQL Server?? Should i use connectio open methos or logonServer & set logon info.?
i tried that also but getting same error. Should i take any special precaution while designing reports in
crystal designer??
I am using Crystal 7.0 , sqlserver 2000 (mix authorization ) & professional 2000 as my op. system.

[demask]

Dear K. Babu!

Thak you for the answer and sorry for my late reply. Could you show me how to correctly close crystal report and tables using RDC methods? Thanks a lot.

Originally posted by K.Babu
Close first crystal report after that close recordset and then close tables

example:

({[....]}) first open last close, second open second close, last open first close.

Try this sequence, that may slove your problem.

yours
K.Babu

[INSIGHT]

Do you know what' s the syntax of GETLICENSESTATUS method of the APPLICATION object in RDC?

[Delamater]

Mr Babu,

You are kind to help everyone! My question is simple, I have a variable that I would like to pass into a selection formula inside of Crystal Reports. On other words, I want to select only records in Crystal Reports 8.5 where the EntryID = gFindString.

gFindString is a value that is populated when a user selects a record using adodb.recordset.find.

Thanks in advance for the help!

Bob

[K.Babu]

Refer the SectionLineHeight property

Originally posted by sthota
hai babu,

thank you very much for ur reply. but in my application user will select the number of lines per page. based on that i have to show report.

that is the problem. due to this, i cannot fix the report by increasing the page footer. so what should i do now?

thank u
sthota

[stealbreeze]

Is it possible to password protect reports?

- If so, how do you run them from VB with the password?

- If not, how do you keep the integrity of the reports after they are distributed to users?

Any suggestions will be appreciated.

Thanks,
SB

[fahedksa]

i have parameter in my crystal report 8.5 and i want pass value from visual basic and without displaying parameter dialog
Thank you

[K.Babu]

create formula field in crystal report design mode

named as MYNAME
and one more for BASIC

in VB code write

cr.formulas(0) = "Myname = 'Babu'"
cr.formulas(1) = "Basic = 10000"

Originally posted by fahedksa
i have parameter in my crystal report 8.5 and i want pass value from visual basic and without displaying parameter dialog
Thank you

[bikashg]

Hi,

Following is a description of the problem I am facing:

I need to create a report based on two DB tables. For eg, if the 2 tables are called 'x' and 'y'. both 'x' and 'y' have one common field and 'x' to 'y' is a one to many relationship. For eg let the following be the structure of the two tables:

table x table y
column names column names
---------------- -------------------
a c
b e
c f
d

I need to generate a report in the following format
x.a x.b x.c count(y.c) x.d
---------------------------------------------------------

in the above report count(y.c) refers to the count of y.c for each x.c

I have tried the following code:

Form1.CrystalReport.SQLQuery =
"SELECT x.a, x.b, x.c, COUNT(y.c) AS Expr1, x.d FROM x , INNER JOIN y ON x.c = y.c GROUP BY x.a, x.b, x.c,x.d

Form1.CrystalReport.Destination = crptToWindow
Form1.CrystalReport.WindowState = crptMaximized
Form1.CrystalReport.Action = 0

normal execution of the query returns the right result set. but execution through crystal reports does not return the right result set.

your help would be appreciated.

[K.Babu]

Hi,

Instead of 'Sqlquery', you can directly use query table to crystal report design mode. Try this.

yours,
Babu

Originally posted by bikashg
Hi,

Following is a description of the problem I am facing:

I need to create a report based on two DB tables. For eg, if the 2 tables are called 'x' and 'y'. both 'x' and 'y' have one common field and 'x' to 'y' is a one to many relationship. For eg let the following be the structure of the two tables:

table x table y
column names column names
---------------- -------------------
a c
b e
c f
d

I need to generate a report in the following format
x.a x.b x.c count(y.c) x.d
---------------------------------------------------------

in the above report count(y.c) refers to the count of y.c for each x.c

I have tried the following code:

Form1.CrystalReport.SQLQuery =
"SELECT x.a, x.b, x.c, COUNT(y.c) AS Expr1, x.d FROM x , INNER JOIN y ON x.c = y.c GROUP BY x.a, x.b, x.c,x.d

Form1.CrystalReport.Destination = crptToWindow
Form1.CrystalReport.WindowState = crptMaximized
Form1.CrystalReport.Action = 0

normal execution of the query returns the right result set. but execution through crystal reports does not return the right result set.

your help would be appreciated.

[K.Babu]

create formula field in crystal report design mode

named as MYNAME
and one more for BASIC


Pass Value to crystal report:
cr.formulas(0) = "Myname = 'Babu'"
cr.formulas(1) = "Basic = 10000"

filter condition:

crCand.SelectionFormula = "{mytable.EntryID} = 'abc'"
crCand.SelectionFormula = "{mytable.EntryID} = 123"

yours,
K.Babu

Originally posted by Delamater
Mr Babu,

You are kind to help everyone! My question is simple, I have a variable that I would like to pass into a selection formula inside of Crystal Reports. On other words, I want to select only records in Crystal Reports 8.5 where the EntryID = gFindString.

gFindString is a value that is populated when a user selects a record using adodb.recordset.find.

Thanks in advance for the help!

Bob