Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: crystal report shows only one row Post Reply Post New Topic
Author Message
jone
Newbie
Newbie


Joined: 06 May 2012
Online Status: Offline
Posts: 5
Quote jone Replybullet Topic: crystal report shows only one row
    Posted: 06 May 2012 at 9:01pm
Hello,
I am using crystal report to print a grouping grid control.
I am sending a dataset with 2 related tables like this:

ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath(rptPath));
rd.SetDataSource(ds);

the datatables have many rows
but when i show the report there is only one row(two related rows) in it.

can you please help me?

thanks in advance.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 07 May 2012 at 4:54am
does the report work in designmode?
while i haven't used multiple tables linked in CR this way, I have used a single table with lots of data and a second table for options (a wizard generates the options and the data).
 
i am assuming that the report is set for ADO.net for the datasource and that you have linked the tables in the report. If they are unlinked, I would only expect 1 record as CR doesn't know how to advance through the record set.
IP IP Logged
jone
Newbie
Newbie


Joined: 06 May 2012
Online Status: Offline
Posts: 5
Quote jone Replybullet Posted: 07 May 2012 at 6:45pm
i'm new with CR.

could you please explain me particularly
what i suppose to do?
how can i know if i'm on design mode?
and how can i check if i'm doing the right thing?

thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 08 May 2012 at 4:53am
design mode is what you see when you initially open the CR environment.  When you hit the preview button, then you are not in design mode IMO. Yes you can move items around and change formulas, but it is supposed to be mimicing the display. 
 
Another way of looking at it, and this is if your report is called from an application...when the application calls it, it is not design time but run time.
If you never use an application, then you are probably always in design time as you can change the report.
 
I guess that is the easy way of looking at it, if you can change the layout or functioning of the report, you are in design time, otherwise you are in runtime.
 
so what I am asking is can you click on the preview button for your report and see the report as you envision it is suppose to be displayed. If the answer is no, then the report doesn't work. If it works when you hit the preview button, but not when you call it from the application, then one would suppose that the data being sent from the application is faulty, but if doesn't work in design, then it doesn't work and it is not the application...
 
so in short, I'm trying to determine where one should start looking to find the error.
 
 
IP IP Logged
jone
Newbie
Newbie


Joined: 06 May 2012
Online Status: Offline
Posts: 5
Quote jone Replybullet Posted: 08 May 2012 at 7:26pm
when i'm on preview mode I can see the report the way it suppose to be displayed, but without the data (which i'm sending from code), only 2 rows of headers:1 for parent Table and 1 for child.

and when i see it from running my application - i see this headers with only one (the third) record of the grouping grid (double record)
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 09 May 2012 at 3:55am
here is how I design/debug reports where I push the data to the report.
stop the app right before you set the DataSource on the report.
use the variable.WriteXML("filename", writeSchema).
 
Now in the report, the datasource should already be ADO.Net, set the path to point at the file you just wrote out.  Now when you hit preview, the report will read the file, and you can start debugging.
 
if you change the datasource, you will need t go into Data Expert, right click your connection and refresh each table. Then go into the report and Verify Database...then when you preview, you will see your new data. 
 
HTH
IP IP Logged
jone
Newbie
Newbie


Joined: 06 May 2012
Online Status: Offline
Posts: 5
Quote jone Replybullet Posted: 12 May 2012 at 7:33pm
could you please show me an example, from code and from the CR environment?

IP IP Logged
jone
Newbie
Newbie


Joined: 06 May 2012
Online Status: Offline
Posts: 5
Quote jone Replybullet Posted: 20 May 2012 at 7:26pm
Hi.
i'm still stuck with this problem,
can you please help me with examples?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 21 May 2012 at 3:53am
there isn't really an example that I can give...I write out the data file and then use that as my datasource for the report.
 
the steps are described in previous posts.
create/change the datasource to be an ADO.Net connection that points to your XML file that has both the data and the schema, and go from there...then it's just like any other Crystal Report.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.