Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Crystal Report (vs2005) - crosstab vs subreport

Posted on 2011-02-28
11
Medium Priority
?
759 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
  • 6
  • 4
11 Comments
 
LVL 101

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 101

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
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 

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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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 101

Expert Comment

by:mlmcc
ID: 35131396
CR XI

mlmcc
0
 
LVL 101

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

886 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