?
Solved

Crystal Rpeort ASP C#

Posted on 2012-04-06
13
Medium Priority
?
388 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 101

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 101

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 101

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 101

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 101

Accepted Solution

by:
mlmcc earned 1500 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 101

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

649 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