Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to pass parameters into a report file ?

Status
Not open for further replies.

dipankarmaitra

Programmer
Apr 9, 2002
2
IN
Hi All,

I am working on a report which needs two subreports be placed side by side in the main report. I need to query a table on "userid(a field)" in the main report. Depending upon this query, two subreports would be generated which would group the records in the two subreports (of the userid) based on a field "type" (values are 0 or 1). If the value is "0", display of the fields will be on one subreport(say type1) and if value is "1", dispaly will be on the other subreport (say type2).

When i am doing it, one subreport shows the actual data but the other does not !!!, when i change the "link to the other subreport" to the 'userid' value in the main report, the other gets going, the first subreport fails.

Can't I bring the regulated values on both the subreports together (based on the 'userid')? I am also facing problems while sending parameters to the "report". I want it to be sent through the VB application I am using and not the "Crystal Report" prompt to popup.

Please help me if you can

Thanx in advance
Dipankar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top