VB Crystal Report, sql in a crystal report formula

microsoft.public.vb.crystal - Microsoft Visual Basic


VB Crystal Report >> sql in a crystal report formula

by UGF1bA » Thu, 26 May 2005 08:04:06 GMT

Hi not sure if anyone knows if this is possible but I am using crystal
reports version 9 and ADO, active dataset to populate a report. I have a
vb.net application with crystal report integration. anyhow just wondering If
I can also use SQL in a formula for one of the fields and if so how?
I need to use one if the fields in the data set as the input to an SQL
statement and have the returned record show up where the sql formula is
placed on the report.
thanks.
--
Paul G
Software engineer.

Top
Similar Threads

1. Print option not available in Crystal Report reports using SQL Stored procedure - VB.Net

2. SQL Server Reporting Svcs or Crystal Reports 

Hi,

I'm looking to set up a method for producing PDF outputs from a website
I'm working on (ASP.NET/C#). The requirement is that the user will be
able to either view a standard "printer friendly" page of result data
or generate a PDF document containing several pages worth of data.

The data will be a couple of images and a repeating list of data, which
potentially will also need to contain images.

A further requirement is that the reports themselves must be able to be
laid out by a less techincal person, hence the need for a tool that
lets you set up report templates and populate them in code, rather than
us simply generating the PDFs entirely in code.

Two tools which have been suggested to me are Crystal Reports and SQL
Server Reporting Services. Can anybody on these groups give me some
suggestions as to which might be more suitable? Whichever solution I go
with must be able to be implemented in a distributed environment.

Thanks,
Jon

3. Creating a report from a SQL Server temp table in Crystal Reports.NET - VB Crystal Report

4. Accessing Formula Field Value From Crystal Report .Net to VB.Net 

Dear Sir,
How Can I Access Formula Field Value From Crystal 
Report .Net to VB.Net


Thanks

Shailesh Bapat

5. Formula error in Crystal Report Viewer - VB.Net

6. Crystal Report 9.0 Formula field help

7. Creating a selection formula based on a DateTime feild from crystal report - VB.Net

8. Crystal report - suppresion formulas 

Hi
I have a problem with a crystal reports viewer I have developed with VS.Net 2003. Everything was working fine until I tried to view reports with suppression formulas...
Eg. suppress (no Drill Down) group header 3 when: DrillDownGroupLevel < 
this formula should return True or false and work fine when I run it in crystal report v9
but with the viewer I get the error message

"Error in File ReportPath\ReportName.rp
Error in formula <Section_Visibility<
'DrillDownGroupLevel < 1
The remaining text does not appear to be part of the formula

I am desperate for some help as I can't figure out what is wrong...
Any comments or suggestions would be welcome

Thank you