Refreshing database?

[savok]

Ok I have a report which displays a Module ID (1 or 2) + some data

When you run the report it asks you to enter a moduleID (1 or 2) when you select 1 it shows all the fields correctly, but if you select 2 nothing shows up. I looked in the database and its in there. The reason I think it might not show up is because module 2 was added after the report was made and that it doesnt see it for some reason? I tried verifying the database and that did not help.

I made a new test report and it works just fine there. So I dont understand why it doesnt see the new data.

My select formula is simple too
{CLASS.MODULEID} = {?Module}

Anyone have any ideas? I noticed crystal does this a lot, things dont work but if you redo it it works just fine, and I would hate do this over.

Thanks in advance!

 

[MalcolmW]

Try unchecking the "Save data with report" option under the File menu. Malcolm

 

[savok]

Unchecking that didnt help to get module 2 rows to show up, but now even less module 1 rows show up lol

any other ideas?

 

[IdoMillet]

Is it possible you have a conditional suppress
on the section, so the data is there but you are
hiding it?

Do you have an Xbase type data source with an Index
that was never refreshed to reflect the Module 2
data?

Cheers,
- Ido

 

[savok]

Darn I got confused just reading that Ido

I dont think i am suppressing it, as for the 2nd i have no clue

 

[MalcolmW]

What is your data source?
Malcolm

 

[savok]

ODBC

 

[kenhamady]

I work with CR full time, and if it works better the second time, it is usually because something is different the second time.

BTW, ODBC to what platform?

What if you change your selection formula to say NOT equal to the selected parameter. Then select the 1 value and see if anything else comes up. Your 2 might have a space or something that prevents the exact match.

I would also verify the database, and then check that the ODBC connection is pointing to the right place. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)