Solved

Crystal Rpeort ASP C#

Posted on 2012-04-06
13
382 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:pauledwardian
  • 7
  • 6
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 37818021
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
0
 

Author Comment

by:pauledwardian
ID: 37818048
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...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37818178
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
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:pauledwardian
ID: 37818508
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;
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37819490
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
0
 

Author Comment

by:pauledwardian
ID: 37819687
Yes, the report is pooling the information from the same database.
And it is the latest crystal report version.
So, any suggestion.......
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37819761
0
 

Author Comment

by:pauledwardian
ID: 37820323
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?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 37820331
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
0
 

Author Comment

by:pauledwardian
ID: 37821902
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
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 37821952
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
0
 

Author Comment

by:pauledwardian
ID: 37822231
Can anyone help with the C# code please?
0
 

Author Closing Comment

by:pauledwardian
ID: 37830519
Never-mind, I use the integrated security.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now