Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ordering parameters in bar charts

Status
Not open for further replies.

pb100

Programmer
Joined
Aug 31, 2006
Messages
36
Location
US
In CRXI bar charts with parameter prompts with multiple values, how can the order of the bars in the chart be set by based on the order the parameter values were chosen by the user? Reports are delivered in CR Server.

Thanks for any help!
 
Interesting notion, you might append a value to the front of the field based on the value in the parameter, such as:

whileprintingrecords;
numbervar counter;
stringvar output;
For counter := 1 to ubound({?MyParm}) do(
if {table.field} = {?MyParm}[counter] then
output:= totext(counter,"000") & "-" & {table.field}
);
Output

Now the above formula would replace the field.

Kinda kludgy though as it appends a value to the front of it, but I think that you could then use a different formula for displaying the value using:

mid({@MyFormula},5)

Should work...

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top