Solved

Generating Report -  CrystalReport / Excel

Posted on 2011-03-02
10
364 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
  • 5
  • 4
10 Comments
 
LVL 42

Expert Comment

by:zephyr_hex
Comment Utility
what is your question?
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
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
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:chokka
Comment Utility


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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I think, Crystal Report is much easier as compared to Excel.

Thanks
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

13 Experts available now in Live!

Get 1:1 Help Now