Any chance you've got an embedded graphic like a logo that is causing the overhead? Or maybe something else?
If the 'save data with report' is unchecked, that should work. I believe one of my larger reports is 478k, since we don't save data. Smallest is 11k.
When you open this, do you see...
I would rewrite it this way:
(if length({?DeptName}) >= 1
then {DeptName}={?DeptName}
else 1=1)
and
(if length({?EmpID}) >= 1
then {EmpID}={?EmplID}
else 1=1)
and
(if length({?EmpDescription}) >= 1
then {EmpDescription} like '%{?EmpDescription}%'
else 1=1 )
Note the parentheses...
Try this link:
http://technicalsupport.businessobjects.com/cs/forums/10830/ShowThread.aspx
A potential solution is about third in the list.
If that doesn't work, come back.
I personally would just remove the extra slash. But I work in my registry all the time. Usually I would just put the...
Sounds like a memory error.
I'd look through the web server configuration, and check it's logs. Reboot the thing if that hasn't been done in a while. Sometimes a memory leak is enough to cause this kind of grief.
I think I'd just turn the parameters into string parameters, then convert them over to dates as you are doing the field value.
Maybe someone knows a paramter trick with XI. I haven't worked with that version too much.
Umph. Kinda kludgy. I think I'd take the same route.
I would like to see that as well.
I would also like to be able to tell using a function which section the formula is sitting in. I have yet to ask the people at crystal if they'll ever build this but I think they would give some report...
Your selection formula doesn't dictate this. I'll presume for the sake of speed that you don't know some things so forgive me if I'm going over ground you already know.
You first write a formula to determine whether the date in question is in the last full month. It will return a true or...
Depends on what you want to use it for.
DateDiff, DatePart, and WeekdayName all support a first day of week constant. DatePart also supports first week of the year values.
The short answer is no.
If someone has a way to do this, I can easily imagine having multiple uses for it, so hopefully someone else will speak up.
When I've had to do the equivalent my code looked about like this:
shared numbervar array numArrGeneral;
local numbervar numInstance...
Outlook hooked into a server that is over the same vpn will continually send traffic. If you don't see a reduction in problems at that point then either it isn't the vpn causing the issue or the vpn is garbage.
Unfortunately it's not a trick with outlook. It is just using outlook because it...
Probably the problem is with your VPN. I doubt a crystal setting will help.
I've used a vpn that was more friendly and another that was less friendly. It is possible that a VPN setting can solve this. Maybe a conversation with your network person.
What seemed to help me the most was to...
If you need to 'create another row' right under the first, the best way to do that is to add another section and then suppress it unless it needs to show this extra remainder information.
Say you have put all of the above into a detail section. You go to your section expert, then click on...
Of course you'd need to cover the December-January year changeover differently. Which requires a more complicated formula. You might try the dateadd function.
something like this:
dateadd("d",12, (dateadd("m",-1,{@date})) )
The inner version is supposed to subtract 1 month from the...
This might be a slightly easier route.
detail level formula
if {ClientPacket.PK} = 42 then
ToText({ClientPacket.Date}, "mm/dd/yyyy")
else
"Open";
then just insert summary object in your group footer based on this. Set for 'Minimum'. That's your Sigma button if you aren't...
Here is an example:
if {@formula} like "*ABC*"
then true
else false
Another example
if {@formula} like "A?C"
then true
else false
In the first case, the asterisk is for any number of characters, in the second, the question mark indicates one and only one character. You can use fields or...
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.