I have design a crystal report in VB.Net 2005 in that i use a subreport in report footer to be print at the end of page.
but when report goes for more than 2 page it will not give me proper result. page header verticle lines mixed in report footer's sub report . here i dont have link to upload otherwise i would have uploaded the output report

Hi,

Please try to uploadthe project topublic folder of http://skydrive.live.com and post the link to it .

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

yup i have draw lines from report header to report footer and now i have changed and restricted to details section but yet my problem not solved. now i am going to attach my output in pdf format plz check when i restricted lines to details section.
plz help me

now i have uploaded my new output file name crView in pdf format as u told me to change the verticle line draw from report header to details section now plz check once again how to design this report means i get expected result. and also i use subreport in report footer as this is my summary of main report.

Hi,

Please try to uploadthe project topublic folder of http://skydrive.live.com and post the link to it .
So that we can see what the problem is .

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

I have upload my project with database. now you can see my problem regarding with crystal report plz help me.
i have upload project in rar file format.

Hi,

Could you please post the link to it?

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

http://cid-fc81048316f8ba40.skydrive.live.com/browse.aspx/.Public/SampleProject
this is the link where i have upload my sample project in that i provide one sample dataabse too
u can set database path and run application u'll see 3 records just click on first record and then click on print button u'll get display of the report. and the second record has some less records thats y the result gets perfect but jst check for 1 and third u'll get my problem. if there is any design problem jst tell me coz i have ask many people they told me design is not de issue. and also the database is in SQL Server 2005

thnx n waiting for your reply

Hi,

When I run the application , a window pops up and askes me to locate database . How to get it?
Could you please upload a simplier sample that we can show the problem?

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Here i have attached another sampleproject.rar file in which it contain Access database with same project. previously i have provided SQL Server 2005 database but you told me that it given some problem i have converted it in MSAccess. So please find the new sampleproject copy and plz help me. After running the application jst choose the record by clicking on the row and click on the print button i have given different 3 records means you can get some different view. run the report with all records and see how the next page get viewed. and also one moew point after copying project jst change the database path coz this time i have hard coded it. thanx m waiting for your reply

Hi,

Could you please post the link to the project? :)

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi http://cid-fc81048316f8ba40.skydrive.live.com/browse.aspx/.Public this is the link to the project. you will find sample project rar file here jst check and reply as early as possible

yes sir :)

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi,

It says the mdb file can not be found , do I have to configure dsn ?

I think just using typed dataset and simplified report that can show the problem would be ok .

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Amol\SampleProject\Database\Atlas.mdb;Persist Security Info=False" This is the connection string i have used to set database path with MSAccess database. You dont need to use DSN jst check this connection string in frmView form's load event and replace the path with your own then run the application and check, coz it is working in my system with this path just remain same strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= up to this now check where your folder located in your system and then add the path next to upper line you'll get all things that you want jst do this application will run on your system too.

Hi did u get any solution on the same?? the line mixing in report footer on next page is my problem coz i want that summary part only on the last page of the report that's y i put that fields on report footer other wise if i use it is in page footer then it prints that summary on every page. So plz reply me

Hi,

Sorry for the delay , It's running now .

But it 's just showing about 4 or 5 rows, not matter what I pressed , nothing happened later.
Could you please tell us what could I do toreproduce the issue?

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi its gud now you get all records. now do one thing select first record and click on print button you will get the reports view My problem you will see in the first records itself then check the report with other records in same way select records and click on print button. also you can check the design of the report

Hi,

I did notice the rows number is not equal to the value of the Total field.

Is it possible you did not get all the records of the table ?
Wheredoes the value of the Total field come from?

I remove the subreport , the issue persists.

You might need to create a new report with just one field or two to see if the error persist.
It's hard for me to get the corresponding field on the report.

I'd guess the records are not retrieved correctly.

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi My records are getting correctly and also i want summary at the end of the report thats y i use subreport in report footer. but i thnk this problem persist because of report footer is too large is this my problem?? plz give me some solution

Hi,

I removed some items of the footer , the issue persist.
You may have a try.

I'd recommend you try to create a simplified project to test what cause it.

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi I am not getting what you want to tell me to make simplified project

Hi,

I mean creating a new report, just drag one or two fields on to it.
Does the error persist?

Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Hi Harry,
hey i have solved that line mixing problem in my report n also i made changes in same report. i didnt made new report as you told me before. Thanx for helping me in some way

thanx n regards
Amol Padalkar