Can I use a Formula Field or Report Parameter in my SQL Command when using a Command as my datasource?

Instead of having the database tables as my datasource, I'm creating a command (double clicking the Add Command Node under my server connection in the database expert) and using that for the fields on my report.

I need to be able to use a formula field (or even a report parameter) in that command SQL so that I can pass dates that will change at runtime to my SELECT statement. Is that possible?
0
kenp2600
9/29/2004 8:07:40 PM
asp.net.crystal-reports 7043 articles. 0 followers. Follow

3 Replies
1437 Views

Similar Articles

[PageSpeed] 37

Yeah it is possible but you have to preset the filters in your report and then pass the information (i.e. dates) as parameters. To learn how to do this there is an article on www.aspalliance.com/crystal and there is also a great book with full walkthroughs on www.crystalreportsbook.com . If you can't preset the filters you could also use a dataset and fill that dataset with any prebuilt SQL string (with a custom WHERE component) and use the dataset as the datasource.

Ryan
0
RyanSmith
9/29/2004 11:21:23 PM
I actually need to use the formula/parameter right in the SQL command, not separately in the record selection formula.  I haven't been able to figure out the syntax for how to do that.
0
kenp2600
9/30/2004 1:21:35 PM
You can't do that in crystal, the record selection creates a quasi WHERE Statement to append to the end of the SQL statment. Your best alternative is to use datasets and create an SQLCommand with the dynamic WHERE functionality fill a dataset and connect the report to that dataset.

Ryan
0
RyanSmith
9/30/2004 11:57:31 PM
Reply:

Similar Artilces:

Can a .net web service return a crystal report .rpt object to use as a report source?
I would like to have a .net web service return an .rpt object to use as a report source for the crystal reports viewer on a thick client (windows .net form). Is this possible? The documentation -- the lack of it, actually -- on this subject seems to indicate no, but I'm not that familiar with the standard deployment schemes. I don't want to create the reports as web services, because they will be created on the fly by users without vs.net, and I'm also restricted by security concerns from putting new software (e.g., report server, merge modules, et al.) on the server that hosts the ....

How to use Crystal Report Selection Formula manually in my Crystal Report page.
Hello, I have Link button on each gridview row and I want to take priview of that row through Crystal Report viewer when I click on Link Button on Gridview row.  In this  CrystalReports1.aspx.cs page I am using record number '35' and it is showing this record correctly but I want to view the each record which is clicked on Linkbutton.  Default.aspx <asp:TemplateField> <ItemTemplate><asp:LinkButton ID = "commandSelect" text = "Preview" Runat="Server" OnClick="commandSelect_Click"/> </ItemTemplate> ...

how to pass report parameters to the report sql command ?
hi all...i have a parameter called  { ?par } and i want to use it in the reports query .. like this for example :  select * from emp where id=?par ..  but an error at compile time raised :  No value given for one or more parameters..         what can i do ??   i think this error must be at run time but not at compile time ..     Help me plzzz !!! bump...

View report from the crystal report server using .NET
Hi,I am first time dealing with crystal report and I having problem with it. I need to use asp.net to link to the crystal report server and view the report, but don't know how? Is there a way to do that? or is there any better way to using .net and view report from the crystal report server?Thanks....

use crystal report or reporting service in SQL 2005?
I used Crystal report .NET for a couple of years but do not really like it. Now, reporting service is available in SQL 2005. Someone can give me suggestion: use crystal report or reporting service in SQL 2005? Or use another product from third party?...

Can we generate crystal reports programmatically using embedded crystal reports designer in visual studio ide?
I have a requirement like i have to generate crystal report based on the user's requirements during runtime?Can u suggest me how to do?...

Crystal Reports using formula fields?
 Hai,I need to generate a report dynamically using formula fields can any one help me....... Thanks,Aswath.   Hi,can you describe what exactly you are trying to achieve? klin6on Hi,Thanks for ur response,i need to generate a report for employee salary sheet,im having all employee details(name,desg, earns,deducts......) in one DataSet, i need to display all fields in dataset in report.Important Note:In dataset i dono column names and no.of columns thanks,Aswath.  Hi,  how do you populate the dataset? If the data comes from a database or some othe...

Converting Crystal Reports 9 report to Crystal Reports .NET report
I have a web page that is supposed to display a crystal report.  The report is fully written and functional in crystal 9 (non-.Net)  .  Is there a way to convert my .rpt so that I can just include it in the new web site? why you don't try to compile project with .net and include your report. then if crystal report is power tool will suggests you with conversation tool    My blog is here.Please remember to 'Mark as Answer' if this post answered your question! Wow it really was that easy!  I just added the old crystal report into my .NET proj...

how to use Crystal Reports without using VS.net GUI
I have VS.net but I don't use it to develop my asp.net web pages. I use it simply as an overpriced text editor. I do not create projects/solutions etc. It's just a personal preference...it's much easier, I think, to develop without the VS GUI. I have played with Crystal Reports and done some of the samples found in the Wrox CR/VS.net book. All these samples reley on using CR through VS. They work fine when I build them through VS GUI. But, since the rest of my site was built outside the GUI, I'd like to do the same with my CR pages. That way I don't have to create a solution, assembly, et...

Creating Reports using Crystal Reports for Visual Studio .NET
Hi i am trying to create a crystal report using C# coding but instead of creating a web application under new project i decided to choose create an asp.net website with C#. The problem is i get:- The report you requested requires further information. --------------------------------------------------------------------------------XP\SQLEXPRESS  Server name:    Database name:    User name:    Password:    All data is present except my password when i enter it, it works fine and the report works too with no problems. How do i ...

How can I fetch a report using ReportViewer control when Reporting Services uses Forms Authentication?
I followed the standard MS article on implementing Forms Authentication for Reporting Services which can be found at http://msdn.microsoft.com/en-us/library/ms160724.aspx which works correctly when the user browses to <reportserver>/Reports. When I try to display a specific report in the website using ReportViewer like this <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">    <ServerReport ReportServerUrl="http://vmsb-isisdev/ReportServer" ReportPath="TestReport" /></rswe...

Can we use DataView as DataSource for Crystal Report..?
  hhi, i'm want to filter a datatable basing on some condition. so i'm using DataView and filtering with the help of Filter condition. now i want to generate report for this output. but i'm getting "Logon Error" while trying to set DataView as DataSource for the Crystal Report. Can i use a DataView as DataSource for a Crystal Report...? plz help me. i'm stucked up here. Thanks in advance. Regards, Muppidi.~ Muppidi hi i've posted this query 10 days back. but i did not get any reply. i've found one solution for this. i'm sharin...

How to use the printing command of Crystal report 10
Hi! I am making a project of water. I want to work in a report that when the print of a page is completed i want to make another report that saves the info of the first report that which customer bill is printed and which has left. SO i want to know how to use the printing command of a crystal report 10 using DOT NET FrameWork 1.0 .  Regards Zubair Hasan Ansari...

Displaying SQL commands used by IM reports
Windows XP Pro SP3 InfoMaker 9.0.2.7509 InfoMaker 10.0.2.7015 SQL Anywhere 10.0.1.3990 Is there any way to extract the SQL command used in the reports of an PBL file? I need to do some analysis on our reports and determine if a certain DB change (i.e. column rename) will impact our reports. And if so, how many will be affected. We do not use PowerBuilder so that is not an option. Is there anything I can do using InfoMaker to report this information? Is there a way to convert the PBL or report source to an XML format so I can use Grep and other text based tools? Tha...

Web resources about - Can I use a Formula Field or Report Parameter in my SQL Command when using a Command as my datasource? - asp.net.crystal-reports

Datasource - Wikipedia, the free encyclopedia
A DataSource object has properties that can be modified when necessary. For example, if the data source is moved to a different server, the property ...

Inverness Graham Acquires DataSource
Inverness Graham , a lower middle market private equity firm headquartered in suburban Philadelphia, has acquired DataSource , a print supply ...

SmartGlance for iPad for iPad on the iTunes App Store
Read reviews, get customer ratings, see screenshots, and learn more about SmartGlance for iPad on the App Store. Download SmartGlance for iPad ...

Chaitanya Pandit (@chaitanyapandit) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Data source - Wikipedia, the free encyclopedia
... Data source A data source is any of the following types of sources for (mostly) digitized data: a database in the Java software platform, datasource ...

2ndQuadrant - PostgreSQL expertise from specialists with a source code level understanding of RDBMS ...
PostgreSQL expertise from specialists with a source code level understanding of RDBMS PostgreSQL Planets Gabriele’s PlanetPostgreSQL Gianni’s ...

Tagged entries for CLOUD COMPUTING
Alan Williamson's output as a Java Champion, Blog-City Architect, BlueDragon Creator, Author, Speaker and Internet Guru

Private equity deals
... of biometric identity management systems, applications and services. www.crossmatch.com Inverness Graham Investment has acquired DataSource ...

C# C Sharp and Tutorials on C# Friends.com
Learn the c# langauge to build web applications using our online tutorials with live demos. Participate in our forums and learn from others. ...

JavaScript UI Library, Ajax Components & HTML5 Framework - DHTMLX
DHTMLX offers a rich JavaScript library, UI components & HTML5 mobile framework. Build impressive web apps for both desktop and mobile devices. ...

Resources last updated: 12/26/2015 9:23:27 PM