Solved

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

Posted on 2006-06-20
4
408 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
[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
  • 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 101

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 101

Expert Comment

by:mlmcc
ID: 17055384
Glad i could help

mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

630 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