Solved

Generating Report -  CrystalReport / Excel

Posted on 2011-03-02
10
369 Views
Last Modified: 2012-05-11
Crystal Report / Excel

I am working on .Net App / SQL Database. I want to generate a Report as it looks like in the attachment.

As per the requirement, Report looks complicate to design.

Output should be in Excel or Crystal Report.


Sample-Report.xlsx
0
Comment
Question by:chokka
[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
  • 5
  • 4
10 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
ID: 35019346
what is your question?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35019446
I hope the data is bogus otherwise you have a problem.

Do you know how to design a report?

It seems a stright-forward report to design.  What is your issue?

mlmcc
0
 

Author Comment

by:chokka
ID: 35019494
mlmcc .. i have worked with you for many of my report issues.

Question :- How to design this specific report which i attached as excel sheet. This report requires different design - Just like Group By ..! Report Design looks like merger of multiple reports into a single report.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 100

Expert Comment

by:mlmcc
ID: 35019585
Are the 2 parts using the same data?

Will there always be 2 copies?

How you design it depends on what it is doing and what data you have available.

mlmcc
0
 

Author Comment

by:chokka
ID: 35019637

1) This is Group By - a Specific Column - Generic Code

2) In the Excel Sheet - You can see first set of Table :- Which has Generic code : 390. So, it shows all users used medicine for Generic Code : 390

3) Like wise .. it will go 390000 ( Generic Code will grow by Ascending order ) and each every set of Users will be mapped for that Generic Code.

Eventually - we want to know - Total Qty used for that Generic Code. Any previous Balance for that Generic code. Who are the users for that Generic Code.

Its a brief report for Generic Codes.
0
 

Author Comment

by:chokka
ID: 35019921


Will it be possible to do in Excel ? Or, should i have to go with Crystal Reports ?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35021513
It should be very easy to create a report to do what you want.

You should be able to group by the generic code then have a list of the filled scrips in the detail section with totals

mlmcc
0
 

Author Comment

by:chokka
ID: 35021533
Okay, so i have to go with Crystal Reports.
I cant do this on Excel ..! Am i right ?

As because, requirement what i got .. they expected me to do it in Excel. I just want to confirm, do i need to go with Excel or Crystal ?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35021631
I don't know about Excel.  It would seem you could but I don't know how to take data from a database directly into Excel.  I could write a program to create the Excel file from the data.

mlmcc
0
 

Author Closing Comment

by:chokka
ID: 35021651
I think, Crystal Report is much easier as compared to Excel.

Thanks
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…

738 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