Solved

Crystal Report (vs2005) - crosstab vs subreport

Posted on 2011-02-28
11
744 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 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
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 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 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 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

627 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