Solved

Crystal Report (vs2005) - crosstab vs subreport

Posted on 2011-02-28
11
740 Views
Last Modified: 2012-08-14
Hi,

I have developed this crystal report with Visual Studio 2005.
The report is used excel as input.
(please look at attachment files)

I used crosstab method to approach this report.
However i found out crosstab method has  a lot of restrictions and not a flexible method. Even though my final report fit the requirement, but it will be hard for future request change.

Is there other way i can accomplish the result i want (like crystal_report_result.doc).
Please advise,

I am thinking using sub-report and grouping, but that will be very complicated.
So please give me some big idea.

Tommy
excel-input.xls
crystal-report-result.doc
0
Comment
Question by:hongclub
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
11 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 35002732
Does the report only use the one spreadsheet?

There is probably no need for a subreport.

What kind of formula on each field?

Is it the same calculation for each of the formulas?

mlmcc

0
 

Author Comment

by:hongclub
ID: 35002895
eventually the report input is from stored procedure ....

- the excel input i provide will be the same as stored procedure result. But keep in mind ... format structure is the same ... but data will be dynamic depended on input parameters.

- for formulas:
for example formula1 will be
.score1 / .score2  = (.score1 / .score2) x100 %, and the field should be a hyperlink links to URL1
All formulas are slightly different, different logic.

- yes, subreport seems way too complicated ... that's why i raise this topic
but other way better than Cross-tab for this report? cross-tab really didn't give me much flexibility.

Please advise,
Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35003110
So what you need is

                                     Topic1                               Topic2                            Topic3
SchoolName          T1score1/T1score2        T2score1/T2score2          T3score1/T3score2
                              T1anotherformula          T2anotherformula            T3anotherformula
              Row3
              row4

SchoolName2
Repeat

mlmcc

0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:hongclub
ID: 35003187
Not totally, topics are not column header

At first, it should group them as different State, in each State group, it should group it as different topic,
then each topic has the report table

the .doc show you the result exactly.

                                    performance1                              performance2                            performance3
SchoolName          T1score1/T1score2        T2score1/T2score2          T3score1/T3score2
                              T1anotherformula          T2anotherformula            T3anotherformula
              Row3
              row4

SchoolName2
Repeat

Tommy

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35003577
Are the records as you show them in the Excel file?

Your document shows
                                     Math Perf                     Sport Perf                        English Perf
SchoolName          T1score1/T1score2        T2score1/T2score2          T3score1/T3score2
                              T1anotherformula          T2anotherformula            T3anotherformula

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35004515
Take a look at this report.  It simply uses the field values for the "cross tab" so you will have to substitue your formula for the assignments.

Just change the data source  location to your copy of the spreadsheet

mlmcc
Report1.rpt
0
 

Author Comment

by:hongclub
ID: 35040459
oh, wow, it is very great ... it takes you how long to finish this report?
i will spend some time on this report since i am working on other project, i will definitely come back with more questions.

so it seems like a lot of grouping instead of using crosstab method, correct?
Tommy
0
 

Author Comment

by:hongclub
ID: 35129902
Hi,

What  version of crystal you are using ... there is no link issue (the hyperlink was gone on the report i made) I used  VS2005 crystal report module, u?

Please advise,
Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35131396
CR XI

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35399256
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question