If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted.

Filter out fields based on value.

I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)

Re: Filter out fields based on value.

Originally posted by Roddy
I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted. (Ie, no NULL's and no blank lines.)

I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:

Can you pass a formula from a SubReport back to a main report?

I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.

All this are Crystal-Syntax
____________________________
Confucius
Junior Member

Registered: Jul 2003
Location: I'm Here!
Posts: 23
Babu,

I posted this earlier on the main page, I'm hoping you may be able to help me with this. I looked through your responses and didn't find anything that matched this problem:

Can you pass a formula from a SubReport back to a main report?

I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.
The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.
Any help will be appreciated.

Grouping

I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.

Crystal Report for VS2003 installation trouble

Hi,

For VS2002 they used to build a runtime for the subject with the following megre modules:
managed.msm
database_access.msm
database_access_enu.msm
regwiz.msm
VC_CRT.msm
VC_STL.msm
It was also a known issue about ATL.msm, which updated atl.dll, in orderd to eliminate the Load report failed error. All this used to work fine, until I was forced to upgrade to VS2003. I discovered, that the names of all the merge modules had changed, but tried my best guess:
Crystal_Database_Access2003.msm
Crystal_Database_Access2003_enu.msm
Crystal_Managed2003.msm
Crystal_regwiz2003.msm
VC_User_ATL71_RTL_X86_---.msm
VC_User_CRT71_RTL_X86_---.msm
VC_User_STL71_RTL_X86_---.msm
However, this leaves me with the Load report failed error. I tried to find the atl.dll on the target system, and found atl.dll in the system directory (the old one, I suspect), and some atl71.dll in the Application Folder of the installation. To me this looks a bit suspicious, but I can guess no further. Will anybody who knows for certain please help? BTW, the target system is w98.

Re: Grouping

Hi robot96

the onyl fieldtype you cant group on is MEMO.

If you still want to Group on that fields, convert them in your SQL-Clause as Varchar.

Originally posted by robot96
I have created a crystal SQL queire to select my data for a report however when I use the queire in the report I only get the option to group by the numeric feilds where as when I make a connection to the data base through the report I can chose any feild to group by.
Also if I create a report using a specific database can that be changed using a VB or Borland builder to change the source location.

Crystal Reports is ganna make me loose my job...

In this software I included crystal reports, because the standard reports don't have that kind of functionality.

Now the demo went really fine, no issues or such things. I did not change anything to the application, BUT, now when I wanted to install the full application, the reports don't wanna work.

1. I get the error: 'Physical Database not found!'
2. The report references a location eg. 'c:\program files\app\app.mdb
3. This report is using the CRViewer control, and the actual report designed in VB -> 'Designers'...

For some reason the reports don't wanna see the Database, BUT the actual Database, is refelecting, at the location, that the report points to, I have verified the Database, and I also made sure to set the location of the report to the directory where the report resides...

I am using the MyReport.DataSource = (ado recordset). (As explained by Crystal Reports, this actually did work). But now it does not work....?

Question: Is there maybe a property that I can use to programmatically "Set" the report's database location?