.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Others >> Post New QuestionBookmark and Share Subscribe to Forum

Crystal reports-grouping records and displaying it from multiple tables

Posted By: Ullas     Posted Date: September 16, 2012    Points:5   Category :Others
I am developing a windows application for a Library.I have to create a report using crystal report for Book details languagewise and categorywise.I can do all this .But my problem is in displaying category name.My database structure is as follws

Table-Books
Book_no varchar(30)
Book_Name varchar(40)
Language varchar(2)
catcode varchar(4)

I have four category table for respective languages named "Category_English",Category_Hindi",Category_Tamil",Category_Malayalam"

all these tables have the same fields ie;
cat_id int
catcode varchar(4)
catname varchar(25)

now if Language is English i want the corresponding catname from table "Category_English" displayed and if Hindi ,corresponding catname from table "Category_Hindi" and so on.

so depending on the language and catcode in Table BOOKS the corresponding Category name should be displayed.My report should look like

Book no Book Name
ENGLISH
AUTOBIOGRAPHY (Here now for me it is displaying catcode ie,ENAB(catcode for English Autobiography)
ENAB1 ABC
ENAB2 XYZ
NOVEL
ENN1 CDE
ENN2 FGH
HINDI
STORY
HS1 XXX
HS2 YYY

i WAS ABLE TO GROUP ALL THIS BUT SHOULD GET THE RESPECTIVE CATEGORY NAME DISPLAYED IN PLACE OF CATEGORY CODE.nOW IT IS DISPLAYING CATCODE FROM TABLE BOOKS.i TRIED USING FORMULA FIELD BUT WAS ABLE TO DISPLAY ONLY FOR ONE LANGUAGE
I Created a formula field catname and in the editor I typed

If{Books.language}=”EN” then
{Category_English.catname} . This is working but if I write for all languages the report is empty
Ie;
If{Books.language}=”EN” then
{Category_English.catname} else
If{Books.language}=”H” then
{Category_Hindi.catname} and so on

Is there any way to do this.I am not well versed in this.Please help


Responses
Author: Jack Smith             
Posted Date: September 17, 2012     Points: 20   

This code for Crystal reports-grouping records and displaying it from multiple tables is fully true. it is very nice.

Click Here for More Information about .Net Developer of India


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend