473,320 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Crystal Report Problem

Dear sir,
In details my problem is:

What I want to do:
Populate data from database in the crystal report with a specific query
What I have done:
I have decleared a dataset YWStatus.xsd
in xsd file I have decleared a DataTable Named YWSdt
the columns are
Year,
CountOfIDN,
CountOfsent_spno,
CountOfrep_sp_no &
CountOffinal_rep_no
My query retrieve data from database in the same order
then the Real problem began...

Now, What I want to do is...
Assign the values of the query-result into the datatable of .xsd file
Populate the values into the Crystal report (I got the table definations from the database field in the Field Defination pane)
Load the crystal report from .aspx file through CrystalReportViewer

I am using .net ver. 2 and Crystal Report that embeded with .NET

Sir, this is my problem in details.
I hope you will help me in this problem, I am waiting for your reply.


With Regards
Sushanta K Debnath
Mar 29 '07 #1
1 1162
dip_developer
648 Expert 512MB
Dear sir,
In details my problem is:

What I want to do:
Populate data from database in the crystal report with a specific query
What I have done:
I have decleared a dataset YWStatus.xsd
in xsd file I have decleared a DataTable Named YWSdt
the columns are
Year,
CountOfIDN,
CountOfsent_spno,
CountOfrep_sp_no &
CountOffinal_rep_no
My query retrieve data from database in the same order
then the Real problem began...

Now, What I want to do is...
Assign the values of the query-result into the datatable of .xsd file
Populate the values into the Crystal report (I got the table definations from the database field in the Field Defination pane)
Load the crystal report from .aspx file through CrystalReportViewer

I am using .net ver. 2 and Crystal Report that embeded with .NET

Sir, this is my problem in details.
I hope you will help me in this problem, I am waiting for your reply.


With Regards
Sushanta K Debnath



Expand|Select|Wrap|Line Numbers
  1. Dim dsRpt As New DSMyxsd
construct your sql query .....populate a dataset(say dsRpt) with your data from table.
assignthe DSMyxsd to dsRpt
Now...

Expand|Select|Wrap|Line Numbers
  1. Dim oRpt As New Rpt// Rpt is the  report object
  2. oRpt.SetDataSource(dsRpt)
  3. crvRpt.ReportSource = oRpt//crvRpt is the Crystal report viewer object
Mar 29 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

13
by: kristoff plasun | last post by:
I have a problem with a C++ DCOM application that prints Crystal Reports with data from Oracle. The SQL query is relatively complex but when the report is printed from the Crystal Reports...
4
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO...
2
by: GC | last post by:
HI, I'am using Crystal Report with visual Studio .NEt 2003 When i make a report using a store procedure, I can not see all the fields of the store proc and i'm suppose to see those fields. I'm...
6
by: Robin Cushman | last post by:
Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...
3
by: Deasun | last post by:
I need some help please! Crystal is driving me nuts. Heres my code so far, see below. Problem: On the .export() line it comes back with error #5 Login failed! I know the login info is good so...
3
by: Milan Todorovic | last post by:
Hello, I need help. I have experience in ASP.NET programming, but this is my first dealing with Crystal Reports. I'm trying to make the most basic report purely for testing purposes: connect to...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
17
by: Peter Proost | last post by:
Hi Group, I've got an interesting problem, I don't know if this is the right group but I think so because everything I've read about it so far says it's a .net problem. Here's the problem, we're...
3
by: FeveZ | last post by:
I've been stuck on a problem now for ages and i'm about ready to pack my project in because of it lol. OK here is my scenario. I have an existing Crystal Report, which I have added to my...
11
by: =?Utf-8?B?cmtibmFpcg==?= | last post by:
How can I stop receiving this message while calling a crystal report? "The report you requested requires further information." Thanks
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.