Go Back   Access World Forums > Search Forums

 
Showing results 1 to 5 of 5
Search took 0.02 seconds.
Search: Posts Made By: pravin3032
Forum: Crystal Reports 04-07-2007, 12:10 AM
Replies: 5
Views: 52,764
Posted By pravin3032
Create Two subreport on your main report. ...

Create Two subreport on your main report.
In subreport 1 create sql query to select distinct record from Table A
In subreport 2 create sql query to select distinct record from Table B
Forum: Crystal Reports 04-06-2007, 10:33 PM
Replies: 5
Views: 15,982
Posted By pravin3032
you can handel it in your SQL also , in where...

you can handel it in your SQL also ,
in where clause just add
column_name is not null

Bob what you suggest is it good to handel this case at SQL level or Report level if its filtering large...
Forum: Crystal Reports 04-06-2007, 10:22 PM
Replies: 5
Views: 15,786
Posted By pravin3032
Other way you can add one detail section for each...

Other way you can add one detail section for each subgroup on your main report and placed your subgroup on detail section.
Forum: Reports 04-06-2007, 10:27 AM
Replies: 4
Views: 658
Posted By pravin3032
mfallon, Now i got why 2nd page comming so. ...

mfallon,
Now i got why 2nd page comming so.
in second page values for column1 and column2 are comming null
but column3 returning with some value.
you have used "_" to concanate three column but...
Forum: Reports 04-05-2007, 11:34 AM
Replies: 4
Views: 658
Posted By pravin3032
Are you sure the second page which you shown is...

Are you sure the second page which you shown is from the same the report.
its really hard to beleive what you shown here.
Showing results 1 to 5 of 5

 
Forum Jump



All times are GMT -8. The time now is 07:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World