Hi Jakes,

In the reports that do not switch folders as expected, are you using the "tsDataFolder" and the "SDesc" formulas?

Thanks,

Hi John

I have a 2 Formula Fields setup, tsDataFolder, and tsCompanyName. When I go and change the company and execute the report, the company name and folder show as selected, however the data is not that of the company. I do not have SDesc. What is this used for?

Thanks,

Hi Jakes,

Sorry, the formula is tsDesignMode and it should be set to "SDesc" in the formula (with the quotes). This forces the system to recognize "standard descriptions" as the design mode (as opposed to "custom descriptions" or "dictionary names"). It is one of those that should be on every report along with tsDataFolder.

So, just to clarify, the data in the report is showing the correct folder and company name on the report but is not populating with the correct folder's data? Is it showing data from the folder where the ODBC DSN is configured?

You are running these through Sage and not in Crystal Reports, correct?

Hi Jakes,

Sorry, the formula is tsDesignMode and it should be set to "SDesc" in the formula (with the quotes). This forces the system to recognize "standard descriptions" as the design mode (as opposed to "custom descriptions" or "dictionary names"). It is one of those that should be on every report along with tsDataFolder.

So, just to clarify, the data in the report is showing the correct folder and company name on the report but is not populating with the correct folder's data? Is it showing data from the folder where the ODBC DSN is configured?

You are running these through Sage and not in Crystal Reports, correct?

Correct. It is showing the company name and folder as selected in the menu, only it is using the data of DSN that was used to create the report.

I have made the changes to my report and it seems to be working now. I just need to do some more testing, but now my report is asking me questions, current, archive, etc. Is this triggered by the tsDesignMode variable? Will this effect the select statement?

That can be triggered by tsAskFile, but I have seen it happen without that formula. Crystal by default does not allow on-the-fly joins of multiple transactional tables. You would have to craft a select statement as a command if you wanted say, current and history together.

I have also experienced a prompt for "New, Current, or History" in a Crystal Job Cost report design that I created, without using tsAskFile, and where the only transaction file included in the design is the JCT_Current_Transaction.

Is there a way to suppress Timberline asking these questions? The tables I have selected and the conditions I apply do not require these additional questions...

So apparently just adding this variable to the report suppress all the questions...