Search results for query: *

Vidru: I did use the parameter in the stored procedure and when I looked at the report it gave me both periods in the detail section. I also wanted to have all time periods available in case a user wanted to look back at a historical period --yes they should save reports but they ultimately...

Fields {Period_1} to {Period_12} are float fields in a temporary database created by a stored procedure. The report fields come from that stored procedure and everything else works great. Could the fact that a temporary table is being used be affecting the report?

I'm using CR 8.5 and connecting to a SQL 2000 financial database. The database lists information by accounting period (varchar(2) field) and financial information is also split up by account period (period 1, period 2, with money amounts). In the CR I'm using a parameter value so a user can...

synapsevampire, Thank you for your effort in helping -- the formula you suggested did not work. It doesn't seem that this should be so difficult. Here's some background. The data behind my report (it will be used in Crystal Enterprise) comes from a large table containing financial info...

I apologize for the confusion and put the wrong version of the formula I was trying (I've tried several different iterations). The {?Acctgper} field is a varchar(2) type field. When a user chooses the {?Acctgper} field, then I want to display the previous period via the formula below. The...

I'm using Crystal Reports 8.5 and I've written a stored procedure for my data. It comes from a financial data source that can be selected by period, not time but numerical (period 01, period 02, etc.). In my report I have a parameter field where the user can select the period they want to see...