Search results for query: *

Hi, See if the filter you have put in reports to fetch the records for yesterday is getting passed to the database or not. You can see it in Report->Query->Profile and then to SQL radio button. If the date filter is not getting passed to the database, it means report is fetching all data from...

Hi jefRPT, The thing you are looking for can be done using macro in Impromptu. Though I can give u the code but its too long to be written here and I think you should refer to it yourself. Go to documentation for Impromptu. Open the pdf for macros. In the last chapter you will find sample...

Hi, Actually I made a mistake in writing the code for the join in the example problem. If you are using the condition I suggested in the join, the problem u r talking abt will obviously come. The condition I suggested is (substring(number-to-string(TableA.field),1,6)) =...

I think, you have made mistake in naming Global Database and SID. Normally both of these things remain same. I don't exactly recall but during installation if u type in one of fields, that name automatically comes into the other field. If you can do re-install Oracle and specify both the...

Hi BlueBrand, You must have see while creating joins between tables in Impromptu that two option namely definition and diagram come. Select definition while creating the join between the tables. There you can create conditional joins using all of the logical operator. Functions are also...

Try using flexible processing in the Report->Query->Client/Server tab. Some times it happens if you are using comparisons based on calculated columns.