Nimmu_3081
asked on
designing a dashboard report with Asp.net and sql server 2000
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thnx both of you.With your ref i got an idea how to go ahead with my project
Glad i could help
mlmcc
mlmcc
>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