Losing leading zeros

[simongallop]

Have a report showing trunk lines which are 9 / 10 characters long starting with a zero ie 001002015

Have set the row source for the graph as text, set the graph as text set the axis format as text. It looks correct in design mode. Open it in preview it loses the zeros and shows 1002015

HELP PLEASE!!

 

[simongallop]

Did that in the query, yet the axis was still adamant that it wanted to lose the zeros!! The only way around it was to change the format on the axis to custom and 000000000. Problem for the larger trunks, but have split the report and created a duplicate template to show the 10digit trunks. The other way that I looked at solving it was to insert a single quote which worked but it looked slightly weird!!

Thanks

 

[AnalystDBA]

Harry,

Try this.

Open the report in design view and double click the chart to open it in MS Graph.

In MS Grapg right click the graph and select Chart Options

In the Chart Options tab select the Axes Tab and change the primary axes from Automatic to Category.

Cheers.

AnalystDBA

 

[simongallop]

Nope that doesn't work. Will have to stick to format 000000000