Issues with Reports

rgates@ttcdas.com

I am finding that if I change data on a form and then run a report, the data that has been changed is not reflected on the report. THe only way the data becomes accurate on the report is if I do a refresh on the page.

tford

Rob,

This may be a silly question, but have you saved the data on the form before you run the report?

How are you running the report?

What mechanism is your report using to gather the data?

Tom

rgates@ttcdas.com

Yes, I am saving the data. I can even navigate the application referencing other data. Once I run the report it shows the original data.

The report is run via a menu option "Create Document". The report uses the Custom Query. The query is pretty straight forward.

FIND Project WHERE (Project.StatusCode='Started' OR Project.StatusCode='Not Started' OR Project.StatusCode='On Hold') OR (Project.StatusCode='Complete' AND Project.StatusDate>=DATE_ADD(Current_Date,-8-)) ORDER BY Project.ProjectName

As soon as I F5 the IE session, the data on the report appears. I have confirmed that I DON'T see the same issue in Firefox.

tford

Rob,

If you do the following, are you saying that the query and the report show different results:

1- Put the query that drives the report on a menu item using RUN QUERY
2- Execute the query from #1
3- Run the report menu item
4- Compare results of #2 and #3.

Tom

rgates@ttcdas.com

I did what you suggested. The query always brings back the updated data. Also, what I have found is that the first time I run the report, after I change the data, the report presents the correct information. After I go back in and change the data and then rerun the report, the data is the original data.

christopherb

Can you post your process that run this report?

rgates@ttcdas.com

There is no process. It is a menu item with type Create Document.

The query on the report is as follows: Also, I created a standalone query using the below and the query brings back the correct data.

christopherb

This may help, we run 20 some odd reports that are all dynamically run by the user. Simply you can do the following in a tidy process.

First off we have an object(search parameters) that handles all information to run a desired report. Here is a simple process to create a report using an attribute.

ENTER NEW SearchParameters USING "Your Form"
FIND myObject WHERE myObject.attribute=SearchParameters.Attribute
DISPLAY DOCUMENT 'My Document'

Of course this can be changed to suit your needs but you should get the idea, With this you can also show your/users search parameter into the report as they will be available in context along with the data queried

Good luck

rgates@ttcdas.com

I appreciate your feedback. I will use your process if I need to go that path. Otherwise, I think this is a bug that needs to be looked into.

aware_support

When you are saying "report", which type of a document do you mean? Is it an Aware IM report translated into PDF or is it a document of some other type?

My guess is that it is the HTML document and the issue you observe is actually the IE caching issue - this is why it doesn't happen in FF. If my guess is right can you try turning caching off and check if it makes the difference?

rgates@ttcdas.com

It is a AwareIM report translated to PDF.

I changed my IE setting for
Browsing History>Automatic versus my orginal setting of Never and that fixed the problem.

Thanks!