|
Posted by Jeff on December 23, 2005, 1:27 am
Please log in for more thread options Andrew,
To run that report from the Report button in Properties, RMS creates a View
in memory and passes the memory variables to the report. Look at the
Items - Item Movement History.qrp. The report looks to see if there is a
View in memory and if so uses that memorized Viewed item. Look at the
PreQuery1 and PreQuery2 statements. If the view exists, use it, otherwise
create a new one.
Don't know anything about MS Access. A FoxPro dabbler here.
--
=
> Many thanks for your post.
> To clarify 2nd part of my request - do you know when you run the item
> movement hisory report, it brings up the default filter = itemlookup code
> of
> the item you were on.
>
> Is there any way of passing information into rms reports like you can with
> MS access for example?
> --
> Andrew Murphy
>
>
> "Jeff" wrote:
>
>> Andrew,
>>
>> Open your report and look in the //-- Filters --// section.
>>
>> For your FilterLoLim, you didn't say what you wanted to change it to, but
>> try "<MonthStart>" instead of the date and then change FilterHiLim to
>> "<Today>". This will run the report with Month to date info. If you
>> don't
>> want any dates in there, just change both to "" (that's 2 double
>> quotation
>> marks without a space). If you need some other filter type, ask here or I
>> think they are available on CustomerSource.
>>
>> I'm still sleepy and can't figure out what you are asking in the second
>> part
>> of your question. Please re-phrase.
>>
>> --
>> *
>> I have modified the item movement history report to get an essential
>> output
>> for my client, who's main concern when purchasing is on the history of
>> the
>> item (needs to know when, who, quantitiy, and multi currency + exchange
>> rate
>> at time).
>>
>> The reason i modded the Item movement history report is because it is
>> easy
>> accessible from the purchase order (although he has to double click on
>> the
>> item to bring up the item form and then click on the report button, which
>> brings up the default filer for the itemlookup code in question).
>>
>> The only issue with this report is that it brings up a filter of >
>> 1/12/05,
>> which needs to be removed every time the report is run.
>>
>> Further to this, does anyone know how the report filters operate in RMS,
>> and
>> secondly, is there any way to set parameters of report based on form
>> values
>> (for example item lookup code like in the item movement history report).
>>
>> Sorry for the long post, but my reseller has been impossible to answer
>> these
>> qs and i really cannot believe it is impossible.
>>
>> Thanks in advance......
>> --
>> Andrew Murphy
>>
>>
>>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap