Search results for query: *

Dataset: I have standalone CR11 running against multiple spreadsheet sources via ADO linked on date columns. The target data is basically all sales volumes to customers by date and product ID. In many cases, a customer doesn't order every sku every month. I've created a supplemental...

Thanks for all of the replies! I've looked at using an access database as a proxy and may go that way. I've tried similar things before, but also added complexity by the access database being linked to a sharepoint list. It didn't seem to work for me. Thanks everyone! Brian

Thanks Bob. Is there anyway to make it movable/copy and paste the formula from one group to another and it automatically summarize for that group. I was hoping it worked the way a chart works, when I grab a chart and move it to another group, I get a chart relative to that group. BG

No one knows how to do this?

Try GETDATE().... Replace ?datefrom with DATEADD(day,-7, GETDATE()), and ?datetill with GETDATE() I think there will be a problem with hours, mins, seconds in that suggestion though. Brian

I know this has to be easy but I'm just stumped. It's been a while since I used Crystal. I'm using standalone CR 11 against a dataset in a spreadsheet (temp as we develop for a stored procedure to supply data). It's almost as if I need a pivot table/crosstab, but I need it to be drill-down...

Is there any way to append to datasources? I have a spreadsheet that is NAME-2013.xlsx and now of course, they have made a NAME-2014.xlsx. I'd like to use both sets of data in an appended manner. I'm using standalone CR2011. Thanks! Brian Garrett

I think I found the category axis idea, but it really hoses up my chart. The odd thing to me is that the overall data has all of the dates that are interesting, but within the group, that subset may not. The chart only shows what the subset has. BG

You're right, thanks for the feedback!! My dates are in fact dates (at the day level per record), and I'm grouping by month. I'm not sure how to change it to a category axis...

I'm using Crystal Reports 11 standalone. I have a large dataset that is grouping by customer, then product type. In the Customer and Product type group headers, I'm showing a bar graph showing volumes. My problem is it skips months with 0 volume. I'm using it to review ordering patterns...