combine reports

[c123456rystal]

I created two reports reflecting summary by customer / by quarter by year (2008 and 2009 qrt 1, 2 etc)
I did that since I was not able to have cross tab report reflecting 2008 1st qrt, 2008 2nd qrt to 2009 3rd qrt

Can I combine the two reports such I see one big report from Jan. 1st 2008 to date by qrt?

thanks

 

[Madawc]

You can make one report into a subreport of the other, if it has no subreports of its own. Put it in the report header or footer.

I also think you could do it more simply if you selected your data by year and quarter. (You can get these values using DatePart.)

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

c123456rystal,

You seem to be creating multiple threads on the same or nearly the same topic. While I suggested earlier that you should start a new thread on new topics, I didn't mean for slight variations on the same topic. At the time I felt you were asking for help on each step of one report--one element at a time--in the same thread.

For the most part your threads lack the necessary detail for the reader to provide you with adequate help. If you spend more time on presenting your problem and also provide some sample data, I think you will have a more successful experience here.

In the current thread, you say you can't show quarters from two different years--of course you can, but you haven't provided enough detail for us to help.

-LB

 

[JoshYeadon]

If you can manage to get all the required data into just the one single report, you can specify a group range in the crosstab.

If you have the 'customer.name' in the Row section & the '.date' field in the Column section, this will do what im thinking you are wanting it to do...

When the date field is in the cross tab, click on the date field and select group options and the cross tab group options will pop up - select "each quarter" from the drop down box & this should seperate your totals by yearly quarter.

I think that is what you mean.

Ta

 

[glasper]

Hello

I need to create a report that will contain county and salesman information which isn't in my db. The user will be able to prompt for customer info by product which will in turn engage a subreport which will include county and sales rep information.

My primary report which will include product and customer information will come from my db but the county and sales rep info will be shown in a subreport.

Since the county information is available as Excel, I decided to imported it into Access because it seems that Access is a better db source than Excel and I thought that it was work out better for both reports to speak Crystal.

In any event, I have a subreport created in Crystal Report that shows all of the information from my Access db that I'd like to includ in my Crystal report (v11.0.0.

I created the primary CR report, inserted the subreport described above into the primary report, linking on State as this is the only field both reports have in commom.

When I run my Primary report nothing is displayed in the subreport. I thought that something was wrong with the subreport so I ran it as stand alone report and all of the information was displayed.

I even tried changing my prompts on the primary report and it still didn't work. The last step was to confirm that both State fields were the same length and they are so; now I'm at a loss.

Is this type of report possible?

 

[lbass]

glasper,

Please repost and start a new thread as your topic doesn't really relate to this one.

-LB