If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Crystal Reports

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).

how to set pagesize

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.

Getting error 'Cannot open SQL server.' in Crystal Report 7 using ASP

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

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.

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.

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:

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:

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.

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.