Search results for query: *

In Section Expert, check New Page After > x + 2: RecordNumber mod 8 = 0 ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in...

Create a parameter of type string, set default values for it, and enter manually the values: January, ... and do the same for years. ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I...

You can do something like this: {vwj_Cl_AssetAllocation.strategy} = {?Strategy} and {vwj_Cl_AssetAllocation.portfolioid} = {?PortfolioID} and ({?Custody}='' or IsNull({?Custody}) or {vwj_Cl_AssetAllocation.custody} = {?Custody})...

I think that this is like a join between 2 tables: select field1, field2 from (select ...) D3, (select ...) D2 where (join conditions) ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in...

SELECT REPLACE(REPLACE('(800) 223 4114', '(', ''), ')', '') ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

Format the field Default > Suppress > x + 2 and enter: NOT(IsNull({ExtendedDescription}) OR {ExtendedDescription} = "") ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat...

Use the Replace() function if it exists in version 7. ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

This works, thanks! ----------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

lbass thanks for your answer, but, as I said, the report has already too many subsections, I already have 9 Detail subsections, and for each of them I need 10 more sections, that will make 90 Detail subsections. I really want to avoid that...

CR 9 and SQL Server 2000 I Details section a have some formulas like this arranged vertically: @acct1 @acct2 @acct3 @acct4 @acct5 //@acct1 stringVar array accta := Split({Field}, chr(13)); if count(accta) >= 1 then accta[1] else ""; The other ones are very similar. So I have a field...

I think that you cannot give to a column the reserved name Inserted, at least try to put it in []: [Inserted] ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more."...

Yes, you can create a running total that will count the records in Details section. Then in Section Expert, for Details section, Color tab > x + 2: if Remainder({#RTotal0}, 2) = 0 then white else red...

UPDATE Assignements SET assign_less_id = (SELECT lesson_id FROM Lessons WHERE lesson_desc = (SELECT lesson_desc WHERE lesson_id = assign_less_id) and schlyr = '2009' ) WHERE a.lesson_schlyr = '2009'...

For these values your formulas work fine, but I think that in the database are some values for which returns this error. ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any...

The problem might be with: DateTime(date({Detail.DateChangeDue}),time({Detail.TimeChangeDue})) I think that we have to see some sample data. ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in...

So create a formula that will take the first 4 characters: LEFT({table.field}) Then group the records by this formula. Insert a summary for the amount field with results in each group footer. Place also the group name in the group footer. Suppress the Details section...

{@DateTime} in (DateTime(CurrentDate & Time("17:00")) to (DateTime((CurrentDate & Time("17:00"))) + 1)) ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more." Franz...

I think that when you manually distinct count, you cannot see some extra spaces that maybe some records have, that could seem identical to you. ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in...

For today: DateTime(CurrentDate & Time("17:00")) For tommorow: DateTime(CurrentDate & Time("17:00")) + 1 ------------------------------------------------------------------------------------------------------------------------- "Now I can look at you in peace; I don't eat you any more."...

I think that you miss some "(" and ")". SELECT A.[ID], A.StorageLoc, A.SLRRawCardPN, A.StencilPartNumber, A.StencilRev, A.Customer, A.SLRPartNumber, A.JobNumber, A.Comments, A.DispositionedAs, A.DispositionedBy, A.DispositionedDate FROM tblStencils AS A INNER JOIN (Select...