Solved

designing a dashboard  report with Asp.net and sql server 2000

Posted on 2006-06-20
4
389 Views
Last Modified: 2008-02-01
Hi experts,
I am a fresher to IT field,so excuse me if my question is not clear.I will try to make it simpler.My application is built on ASp.net and the database used is sql server 2000,crystal x11.I am a report dsigner.The fields to be displayed in the report are from several tables.The fields are stored with GUIDs.I have to design a dashboard report which includes a Gant chart on the right and Three Headings like  Info,Tasks,Forecast on the left with their fields.I got a clue of designing it if the fields were direct.But,I need help with
1.Pulling the data when they are stored with GUIDS across several table.-(if iam right i have to write a stored proc to retrive appropriate data,in that case can some one give me sample queries to achieve that)
2.After I design the report with Crystal,I have to call it in ASP.net application,what are the steps to be taken care of.(wher shld i publish the report,how can I call it using ASP.net)
3.I need to export it in Excel,so what are the issues i might have to face.
As this is my first job,I am a kind of nervous,my boss is rude with me for some reason and so decided to ask experts assistance to survive in the job.Pls reply asap.
your suggestions will be highly appreciated,
Regards,
Nimmu.
0
Comment
Question by:Nimmu_3081
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Spykair
ID: 16948771
Nimmu,

>1.Pulling the data when they are stored with GUIDS across several table.-(if iam right i have to write a stored proc to retrive appropriate data,in that case can some one give me sample queries to achieve that)
You can use a SP or you can link the tables in your database expert to each other.

2. try this: http://support.crystaldecisions.com/communityCS/FilesAndUpdates/aspxmps8.exe.asp

Good luck,
Spykair
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 16964969
Here are some tips for designing the report to export it to Excel

http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_export_excel.pdf.asp

mlmcc
0
 

Author Comment

by:Nimmu_3081
ID: 16987423
thnx both of you.With your ref i got an idea how to go ahead with my project
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17055384
Glad i could help

mlmcc
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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