Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET VB.NET
hello.
 
I am working on a small project, nowadays I am working on crystal report, to generate a crystal report which method is best for, weather to generate with tables or views.
 
and 2nd is that I want more than one row as a heading like subject under subject i want a subject name so how can I do this!!!
Posted 11-Oct-12 11:12am
Edited 11-Oct-12 11:19am
Wes Aday79.2K
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Tables or Views doesn't make any difference to Crystal Reports, or any other reporting for that matter.
 
As for the second thing, I don't use Crystal Reports, so I don't know.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

1.
you need records (Source of data) it doesn't matter you are using table or view or data is coming from sp or simple sql query or xml etc...
the thing is after all process you should have data in table format[ set of column(s) & row(s)] to assign it in crystal report.
 
2.
suppose you have columns like this,
subjId, SubjNm, SubSubjId, SubSubjNm
In crystal report, grouping option is available.
simply, add group for SubjId and another group inside it SubSubjId
and dragdrop SubjNm & SubSubjNm fields in report respectively inside group(s) or detail part.
 
Happy Coding!
Smile | :)
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 250
1 Sergey Alexandrovich Kryukov 184
2 Rob Philpott 100
3 jlopez788 74
4 CHill60 70
0 OriginalGriff 6,837
1 Sergey Alexandrovich Kryukov 5,589
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 12 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100