New to Crystal Reports.

Question

4.00/5 (1 vote)

See more:

I made a report in CR 2013 using a Sql database. I added the report to my web project. I added a new web form and then added a crystalreportviewer to the web form. I then added the report to the crystalreportviewer. The report shows with data from the database. My question is, Do I need a dataset or just use the Sql database? What I am trying to do is build the report for different users. Each user has a session when they login. The report should only show that users data on the report.

Posted 13-Feb-14 3:03am

Computer Wiz99

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2014-02-13T19:39:00

Solution 1

Please read below mentioned great articles for more details.

Crystal Reports In ASP.NET

Creating Crystal Report in ASP.NET

Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]

Posted 13-Feb-14 19:39pm

Sampath Lokuge

Comments

Computer Wiz99 14-Feb-14 11:12am

Sampath Lokuge, Thanks for the links and info. I did follow them and still having problems. When I logon as a different user, the report is not populating with the current users data from the database. Why is that? What did I do wrong?

Sampath Lokuge 14-Feb-14 11:46am

How to retrieve the data from the db ? Can you put that query here ?

Computer Wiz99 14-Feb-14 11:56am

Well, this is what I have. I made a report in CR 2013. I added it to the web project. I added a new web form then added crystalreportviewer. Then I added the report to the crystalreportviewer. All of the data from the SQL database shows for the report but does not change when a different user logs in. I am trying to display the current user data when they click on the print button. When the user clicks on the print button it should show the report in a preview window with the current users data. But it only shows the first record in the database. How can I have the report to populate with the right data from the database with the current user? I do have a session in place also.

Sampath Lokuge 14-Feb-14 14:11pm

Ok,What's your db SQL query for that ?

Computer Wiz99 14-Feb-14 14:34pm

This is what I have after I put the data fields on the report.

SELECT "Table1"."LongName", "Table1"."CITY", "Table1"."STATE", "Table2"."Total_Reve", "Table2"."Instructio", "Table2"."Research", "Table2"."Public_Ser", "Table2"."Academic_S", "Table2"."Student_Se", "Table2"."Institutio", "Table2"."Physical_P", "Table2"."Scholarshi", "Table2"."Auxiliary_", "Table2"."Hospitals", "Table2"."Independen", "Table2"."OtherExp", "Table2"."TotAssets", "Table2"."TotLiability", "Table2"."NonExppermresAssets", "Table2"."EXPENDABLE", "Table2"."UnrnetAssets", "Table2"."TotalRev", "Table2"."TuitFees", "Table2"."CurrDebt", "Table2"."LongTermDebt", "Table1"."INST_ID", "Table2"."INST_ID"
FROM "Password"."dbo"."Table1" "Table1" INNER JOIN "Password"."dbo"."Table2" "Table2" ON "Table1"."INST_ID"="Table22"."INST_ID"

Sampath Lokuge 14-Feb-14 14:43pm

I couldn't see anything you have filtered according to the user id or name or like that ? If so then how can you retrieve the data for specific user ?

Computer Wiz99 14-Feb-14 14:44pm

Ok. If I did it wrong then I'm sorry. I am new to the report. How should be written? :)

Sampath Lokuge 14-Feb-14 14:50pm

I don't know about your db table structure.But if you need to filter something according to the user specific then you have to pass that login user's id or name to the above query.Then only you can filter that.And this is not the report issue.This occurs due to wrong data retrieve from the db.I hope so.

Computer Wiz99 14-Feb-14 14:59pm

The session I have in place is the INST_ID. That is what the session goes by. Table1 has INST_ID, LongName, CITY, STATE. Table2 has INST_ID, .... ... ....Everything else I needed. I am just trying to find out how to populate the report with different user logins using a session. Is it really that hard to do?

Sampath Lokuge 14-Feb-14 15:08pm

What's INST_ID ? At what time you save that filed on db ? At the time when you create a user or what ? If its unique for the user,you can use it for filter as well.But I couldn't see such a filter under the where clause on above query though.

Sampath Lokuge 14-Feb-14 16:07pm

You have to do it on crystalreportviewer at the time when you bind the data into it.

Computer Wiz99 14-Feb-14 16:10pm

Ok. I don't understand. I made the report using CR 2013. I added it to the web project. Then added a new web form and put crystalreportviewer on it and imported the report to the viewer. Did I miss a step? Is there a walk through that you have?

Sampath Lokuge 14-Feb-14 16:22pm

How did you create your report data source at the time when you create a report?

Computer Wiz99 14-Feb-14 16:41pm

I used my SQL connection to the database I needed. The Steps in CR2013: Opened CR2013, Clicked on New Report (Standard Report Creation Wizard pops up), Selected My Connections, SQL Database Name, The Database, dbo, and choose the Tables I needed for the report. Clicked on next, (It took me to the Link part). Linked INST_ID from Table1 to INST_ID Table2. Clicked on finished. The report shows. I just made the text fields and dragged and dropped the data fields from Field Explorer and lined them up the way I needed to. That is all I did and know how to do. Any Help.

Sampath Lokuge 14-Feb-14 17:04pm

Nope.You cannot achieve your task by using that way.So you have to create stored procedure(sp) and then bind that SP as data source.At the time when you load the report, you have to pass your 'INST_ID' as a parameter into that report (i.e. parameter for the SP).By using that parameter your data will be filtered for the specific user.

Sampath Lokuge 14-Feb-14 17:05pm

Please check below links for more info.
http://forums.asp.net/t/1866970.aspx

http://dotnetmentors.com/reporting/crystal-report-with-stored-procedure-parameter-and-visual-studio.aspx

http://www.nullskull.com/a/931/crystal-report-and-parameter-passing-using-stored-procedure.aspx