Search results for query: *

Thanks k, got it working with formula you provided. ' Create parameter objects Dim myParams As ParameterFields = New ParameterFields Dim myParam As ParameterField = New ParameterField Dim myRangeValue As ParameterRangeValue = New ParameterRangeValue ' Set the ParameterFieldName to the name...

Created StartDate and EndDate parameter fields in Field explorer and it works. But the Enter Parameter dialog box pops up. How can the dialog box be avoided and instead use the param that I pass? Thanks.

I am using CR 9. How can I display parameters in textbox or formula? Thanks. I am doing following: Case "Customer" Dim crReportDocument As Customer crReportDocument = New Customer ApplyLogOnInfo(crReportDocument.Database)...

In CR, I have users select start date and end date and build query using this date range to populate a reporting table. What I like to do is display this start date and end date in report header. How can I do this? Thanks.

It hides the Text_PageHeader in the fax FaxCoverLetter which is good but I would also like to hide Text_PageHeader in following situation. for eg. if a customer (group by customer and customer_contact) has more than 1 page of report, then the Text_PageHeader re-appears in the next page. I would...

makes sense. Changed group by Item Desc and it works. Thanks k.

Order # is same as OrderID. I want to group by Order but sorted by description. I cannot find Report->Sort Order. It is CR 9. Thanks as always.

In CR, I have 3 groups. Group by Customer id, Contact id, Order id. Below Group by Order id, I want to display Order#, Item Desc. I would like to display by Item Desc in ascending order. Currently it is displayed by Order#. How can I do this? Thanks.

Thanks k as always. It worked out great!!

I got two sub reports Text_PageHeader and FaxCoverLetter in a report. Text_PageHeader is in Page Header section and FaxCoverLetter is in group Footer section. FaxCoverLetter will always be in new page. Currently Text_PageHeader sub-report appears in every page, but I want to suppress this...

How do I correctly calculate age from data of birth in CR? I can do following in Access but CR doesn't recognize the format function. Thanks. DateDiff("yyyy",{my_age.birth_dte} , Now())+Int(format(Now(),"mmdd")<Format({my_age.birth_dte},"mmdd"))

I have problem with string concatenation that I need some help with. In the following SQL, I concatenate the contact first name and last name. I fill it in dataset and bind it to datagrid. The problem is if there's no contact name, it inserts a blank string (i.e. a space that I used in...

In Control Panel, the mouse setting has Normal select.

it didn't work, how can I check the mouse setting of your OS?

In listview control, when I hover mouse between the column headers, it displays black object (square). I tried changing the cursor property, and played with various properties, it didn't help. Any suggestions will be appreciated very much. Thanks.

Got it working by passing login info to subreports. Dim crSections As Sections Dim crSection As Section Dim crReportObjects As ReportObjects Dim crReportObject As ReportObject Dim crSubreportObject As SubreportObject Dim crReportDocument As CrystalReport1 Dim...

Thanks LB, got it working. I am using CR that comes with Visual Studio.Net 2001. Another small problem surfaced since I began using sub-report for this report. Login dialog prompting for userid, pwd, db, server shows up. I have the following routine that used to work when there was no...

how can I get Amount summary from sub-report to group header in main report? Thanks.

Hello again, I added a subreport and put it in the detail section in the main report. Strangely, the subreport appears more than once in the main report. What could be the reason? Thanks.

Ran it w/o breakpoints, same result. The items are there, just seeing blank instead of "LName"/"FName". I changed the cb property dropdownstyle to dropdownlist, but it didn't help. HELP!