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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.