Crystal Rpeort ASP C#

Report LayoutAll,

I am creating an asp website (for the first time) and need to know how I can include each SQL parameter for each record in a SINGLE Page. Please see the attached screenshot.
When I add Crystal Report Viewer and use the Wizard, it designs ALL records vertically along with their headers.
I need to have each record in a single page for employees to sign on the paper for each report. I created a search textbox that user can input a customer number and I need to have a report to ONLY show the information in 1 PAGE for that particular number along with its other information.
For instance, for Customer number 1 record in SQL which also includes (Date, PO  Num, Cmment, etc) there would be ONLY 1 page for that specific customer information.
PLEASE see the attachment.

Thank you,
Paul
pauledwardianAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
The way to do this is to have the user sign in and determine his id.
You can then pass that to the report as a parameter and select that user's information based on the id.

An FYI - Is this an in-house appliction to be used by employees of you company?  
or is it to be on the net with outside people using it?

If the latter, then you need special licensing from SAP/Crystal to use the reports in that manner.  I don't know exactly what it is so you will need to contact SAP/Crystal

mlmcc
pauledwardianAuthor Commented:
mlmcc,

That is not my question.
I am asking how can I change parameters so each row of sql values print in one page in sql report.

Customer1 info in row 1 in page1
Customer2 info in row 1 in page2
Customer3 info in row 1 in page3
etc...
mlmccCommented:
Assuming you have the report grouped by cutomer id you can use the NEW PAGE AFTER in the group footer or new page before on the group header.

Right click the GROUP HEADER in the left margin
Click SECTION EXPERT
Click the FORMULA BUTTON to the right of New Page Before
Enter this
   Not OnFirstRecord

That way you won't get a blank page for page 1

mlmcc
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

pauledwardianAuthor Commented:
I figured that out.
Now..
How can I stop Crystal asking user for putting the server information everytime they are tyring to search the parameters. I used this code but it didnt work. I have SQL developer version:

ReportDocument crystalReport = new ReportDocument();
        crystalReport.Load(Server.MapPath("CrystalReport.rpt"));
        crystalReport.SetDatabaseLogon
            ("ASPNET", "ASPNET123", @"192.168.1.1", "CSDatabase");
        CrystalReportViewer1.ReportSource = crystalReport;
mlmccCommented:
Are they pulling the parameter information from the same database as the report?

What version of Crystal?
That looks like an older method of passing the logon information.  I haven't written a generic application so I am not that familiar with the methods plus all my applications have been in VB6 so the method is different.  

mlmcc
pauledwardianAuthor Commented:
Yes, the report is pooling the information from the same database.
And it is the latest crystal report version.
So, any suggestion.......
pauledwardianAuthor Commented:
Do you think it would solve the problem if I add a generic AD Group into SQL users and give that group Full permission to database. Then add the users AD to that group would solve the problem?
mlmccCommented:
We solved this by using integrated security so the reports could use Windows login.  IN that way all users had permissions tothe database, we put them into a single group and gave the group permissions to the views and stored procedures but not the tables themselves.

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pauledwardianAuthor Commented:
Do you know if it would be possible to include the username and pass in web.config like the sqlstring?
Also, can you provide a C# code? I am not familuar with Vb.net
mlmccCommented:
I don't know C# and haven't seen many examples.

Why would you want to include the username and password in an open file?

mlmcc
pauledwardianAuthor Commented:
Can anyone help with the C# code please?
pauledwardianAuthor Commented:
Never-mind, I use the integrated security.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.