Creating a Crystal Report With Input Variables 1

[chrissypchy]

Hi All,

I have a project to do where I have to generate a Crystal report that will prompt the user for certain values that are needed by the queries. Is there anyway to do this WITHOUT programming? Thanks.

-Chrissy

 

[synapsevampire]

Sure, select Insert->Field Object->Right click Parameter Fields and fill it in apporpriately to the table.field type you will be comparing to.

Now go to Report->Edit Selection Formula->Record and place something like:

{table.field} = {?MyParameter}

If you need additional help, please post version numbers of Crystal and the database, and adding the data source schema, example data and expected output will net the best results.

-k

 

[chrissypchy]

This works great!!! Thanks so much. The only problem I have is that it only prompts the first time. If I open it again, it doesnt prompt me to change the values. It just keeps the values I inputted before and doesnt allow any changes. Is there any way to fix this.
-Chrissy

 

[smrati]

hello synapsevampire
i had a similar type of question as chrissypchy had..
i tried what u suggested but in my crystal report there is no option as
Field Object in Insert Menu.

Please help me out.I want to pass parameter in my crystal report through VB..I have posted my problem today with the subject :unable to connect ;incorrect logon parameter

please help me out
thanks

 

[dummieq]

Hi,
I am facing a similiar problem. I want to create a crystal report that accepts input parameters. So, I followed the suggestion given above
---
Sure, select Insert->Field Object->Right click Parameter Fields and fill it in apporpriately to the table.field type you will be comparing to.

Now go to Report->Edit Selection Formula->Record and place something like:

{table.field} = {?MyParameter}

If you need additional help, please post version numbers of Crystal and the database, and adding the data source schema, example data and expected output will net the best results.
----
However, after I select the table.field, when I try to put the other field i.e {?MyParameter}, it gives me an error. Where am I going wrong?

Thanks
regards

 

[synapsevampire]

Perhaps you can post what the error is, and what you put in the record selection formula?

You may be comparing different data types, but it's impossible to tell with such a vague description.

-k

 

[dummieq]

Hi,
I have a very simple table with two fields
1.login
2.Password

I want to display a report where after I provide the login, the reports returns a record with login and password. Both are text fields and the table is created in Access.

I am using Crystal reports 9. There is no Field object in the Insert menu as described above..So I used a database field.

Then, when I go to Reports and Edit selection formula->Record and select database field "login" as below
{Users.login} and on RHS I put {?myparams}..like
{Users.login}={?myparams}. Then when I try to accept, it gives me the error as below

THERE IS AN ERROR IN THE FORMULA, THE FIELD NAME IS NOT KNOWN

Thanks a lot for the help...
regards

 

[dummieq]

Hi,
I need to clarify..Crystal reports I am working on is not version 9. ..It is for Visual Basic 5 and the version is 4.6.1.0..
Sorry abt that..

regards

 

[Naith]

Chrissy, I would suggest that you check that you do not have the Save With Data option turned on in the File menu.

Naith

 

[dummieq]

Hi,
I have created a crystal report that takes input parameters. But, how do i display this report on a web page using ASP?

Thanks and regards,
Aravind

 

[tobitza]

Hi!
I have to generate a Crystal report that will prompt the user for a value that is needed for filtering the data in the report. I have Crystal Reports for Visual Basic ver 4.6.1.0 .Is there anyway to do this with this version of Crystal?Has parameter support this version?

Thanx