[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

About Crystal Report

Posted on 2011-03-07
8
Medium Priority
?
397 Views
Last Modified: 2013-11-16
I want to know how we can use the change subreport option for parameter field with example CustomerProfileReport-07032011.rpt
0
Comment
Question by:suvmitra
[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
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 16

Accepted Solution

by:
Kalpesh Chhatrala earned 2000 total points
ID: 35055916
Setting Parameter file in sub Report

http://www.tek-tips.com/viewthread.cfm?qid=135907&page=94
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35056672
What are you trying to do?

mlmcc
0
 
LVL 9

Author Comment

by:suvmitra
ID: 35067113
how to link subreports in main report while using business object  as i am having common customerid column in both the stored procedure for  link in main report and subreport
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 35

Expert Comment

by:James0628
ID: 35068077
When you say "customerid", I assume that you mean the ContactID field.  What you have in the report that you posted looks OK.  Is there a problem with it, or something that you want to change?

 James
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35071539
I agree, it looks correct.  What is the issue?

mlmcc
0
 
LVL 9

Author Comment

by:suvmitra
ID: 35106523
Here i’m unable to pass the parameter through main report and I have already declare one parameter field ‘parasContactID’ in the main report. Please kindly give some sample subreport where the parameter is passed through main report to the subreport
Here-i.docx
0
 
LVL 35

Expert Comment

by:James0628
ID: 35107434
I'm still not sure what you're trying to do, but I'm going to make a guess.

 The datasources for the subreports in the report that you posted earlier are Commands that look like this:

exec spCustomerProfileReportPart5  '1000000102'

 Do you maybe want to replace the fixed '1000000102' values in the subreport Commands with a value that comes from the main report (maybe parasContactID)?

 If so, you could do that by:

 Going into the Command editor (as in your screenshot).

 Use the Create button on the right to create a parameter for the command.  Make it the same data type as the parameter for the stored procedure (?) that the Command is executing (spCustomerProfileReportPart5 in this case).

 Replace the fixed value in the command (1000000102 in this case) with the parameter name.  But if the value is in quotes (ie. it's a string), _keep_ the quotes.  For example, if you created a parameter named param1 for the Command above, change the Command to:

exec spCustomerProfileReportPart5 '{?param1}'

 Go back to the main report, right-click on the subreport, select "Change subreport links" and link the field/parameter/whatever in the main report (parasContactID?) with the parameter that you created in the Command in the subreport (?param1 in my example).


 However, having said all of that, you're kind of doing this the hard way.  You've created Commands that execute stored procedures.  You should be able to use the stored procedures themselves as datasources.  If you do that, CR will automatically pick up the parameters from the stored procedures and add them to the report or subreport.  Then you would just link the field or whatever in the main report to the stored procedure parameter in the subreport.  Using Commands to execute the stored procedures just adds a layer that you normally don't need.

 James
0
 
LVL 17

Expert Comment

by:MIKE
ID: 35135018
You can't modify a Crystal Report using Business Objects, you must modify using Crystal Reports....

0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

656 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