Solved

Crystal Report (vs2005) - crosstab vs subreport

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

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now