Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Report (vs2005) - crosstab vs subreport

Posted on 2011-02-28
11
Medium Priority
?
750 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 

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. …
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 …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

661 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