Search results for query: *

How is it possible to convert a time field to a number. The field is hh:mm:ss ie 00:02:30. I need this to be represented as 2.50. Any help would be greatly appreciated.

Im trying to combine a time axis with a data axis in a graph, in the summary options for the time axis i only get the option when Calculating the summary of either 'Distinct Count'or 'Count'. Is there a way of only showing the value of the field rather than the above options. Thanks in advance

ok. im looking to transfer milliseconds ie 165612 into a time format which will be hhmmss. i have used this below so far but need this to be as described above. Format([milliseconds]/86400000,'nn:ss') Any ideas

Thanks for this. Next step.When i run a make table query with the above it transfers as text I want it to transfer as mm:ss. How i can ensure that it goes as mm:ss and not text. Thanks In advance

I have added an additional field to a table in an access database but when i look to add this field in an existing report/chart ive created in CR11 it doesnt appear in the list of tables names?? Any ideas how i can populate my report with the new field. Thanks in advance Ian

I have the following field which is milliseconds but i want to convert this to mm:ss eg. 165612 How i can do this, has anyone done this before. Thanks inadvance Ian

I would say b) Facility to add comments and view them at a later point. If the data can be refreshed at this point that would work well. is this dooable??

Is it possible using crystal reports viewer to add comments to the report and then save these back to the report. I want end users to add comments to the final report. Any ideas how to do this would be much appreciated. Thanks in advance.

Is it possible within crystalreports.com to add comments to the report ie within a designated 'comments box' or does this need to be done externally? Thanks for any help with this

im hoping to develop a platform later on perhaps using crystal enterprise which would host these charts, I havent used crystal enterprise before so is it possible to edit the reports at this point? if so how would this be possible. Thanks in advance Ian

Im in the middle of creating a series of charts/graphs for out marketing dept. They want to be able to add a text box onto the chart so they add comments. Is this possible? If so how? Thanks in advance Ian

im trying to create a chart on CR10 which has data grouped by month only. this data is stored as the first day of the month ie 01/01/2005 all the way up to the current month. Is there a way in CR10 that i can get the data to group by month and compare data from jan 05 to jan 06 and Jan 07 in a...

Help i have an issue with a graph im using. The dates are appearing as dd/mm/yyyy. is there a way of changing their appearance so that they appear as mm/yy instead. I understnd that you can chnage individual ones by Edit Axis label but as this is going to be a rolling graph and dont want to...

its stored in an access database as date/time field

is there a way of getting three years worth of data to appear in a period starting Jan to dec for the last three years using a chart within access? I need to compare this years stats against the matching month from the last two years The fields are as follows Month = dd/mm/yyyy No of hits =...

Can anyone help. I'm attempting to create a chart which goes jan>dec for the last couple of years grouped by subcategory. The report will compare the value of each subcategory by month ie compare jan 04, jan 05, jan 06 etc against each other. How would i produce such a report. The month data is...

Yes i have monthly information which i need to group across the page rather than going down. I have managed to get two columns of data to appear on the report but the 2nd columns alignment is not level with the data on the left hand side of the report. Can this be brought level?

Ive got a report which lists the results down the page is there a way of getting the results to appear horizontally and not vretically?? Any help on this would be of great assistance.

all ive got in my table are the following column headers. This is an example of one of the products. PRODUCTNO REMARKID REMARK 2954 11427 Fourteen bedroomed hotel situated by the old Penhelig harbour with views across 2954 11428 the estuary to the...

Im getting the wizard coming back and saying there is 'Too many Crosstab Column Headers' for me to do it this way.