If I recall correctly ( it has been a while), if you create a text box and place the fields in it, it can be formatted to suppress when blank ( I used it all the time for address labels)
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Hi all,
OK, it seems to have been a Windows 8 'quirk'.
When I checked the notification area on the desktop I saw that an Office update was ready to be installed and, after installing it, everything screensaver related returned to normal. Apparently that action, while pending, prevented the...
Hi,
my screen saver has suddenly decided to not start, nor does the screen dim or turn off as specified in the power settings.
I have turned off all the 'live' tiles (with no effect) and have uninstalled the only new program I installed (a FLV viewer from the Microsoft store) with no impact on...
It reminds me of the prescription instruction:
Take 1 tablet 4 times a day
Difficult without attaching a string to it! [lol]
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Is there a DSN on the machine running the CMC version and is it exactly the same as the one used in development?
What database and connection type is involved?
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Thanks, that really makes sense ( more than the app does)
The new interface does seem to have a steep learning curve, at least for those 'shortcuts' we used in 7 (or in 286 ,3,95,xp,Vista [I'm old![tongue]])
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
When running IE10 from the Metro side, no tool bars are visible and I cannot find a way to set a start (or home) page.
It always goes to whatever site was last visited, which is annoying.
Is there a way to set and go to a 'home' page.
The classic 'desktop' version works as expected.
Thanks...
Be sure that the account that the reportserver is running under has full rights to the source of the dynamic parameters.
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
What backup method/technique is being used?
Does your org have an Oracle DBA, if so, what is their advice? ( If not, why not?)
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
[bigsmile]Nice post Santa, I seem to recall that problem from one of my Oracle classes.
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Try opening the report using the BOE connection not the regular File...Open.. dialog within CR..Then save it back and it might show the correct directory (The Output server's directory )
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Try ( as your record selection formula):
InStr({calldesc},"mobility") > 0
or
InStr({calldesc},"cash edge") > 0
or
InStr({calldesc},"voyager") > 0
If there can be upper or lower case then add those possibilities.
[profile]
To Paraphrase:"The Help you get is proportional to the Help you...
By using a formula in Crystal to do the selection you have most likely moved that step from the database ( fast) to the local machine ( slow).
Take a look at the SQL created by your report and you will probably see that that part of the WHERE clause is not being passed.
Try creating a view that...
Can you explain the primary_code = n part of the formula?
Why does the code Ian posted not work?
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
I have usually found that creating a view in one datasource that incorporates the other datasource is easier to use with Crystal, so if you can do that in your databaae type give it a try.
With that method only one datasource needs to be accessed by your SQL in Crystal.
If not, is a SQL command...
If your parameter is defined as 'allow a range of values' than it should work by using the parameter in the selection criteria.
You do have those numbers in a record field, right?
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
Assuming that your linking fields are correct and that your 'new' table of invoice numbers created from the spreadsheet is the leftmost table with a left outer join to the header table which then is linked to the line table,it should return the records you want- In your report you should group...
Hi,
Why group on Status? If you place that field in the details you can then use that formula to get the #
You can suppress the detail section if you want ( and do not have any other fields in there)
[profile]
To Paraphrase:"The Help you get is proportional to the Help you give.."
One problem I see it that you will not have any values ( or aliases) for any CASE statement that is not met,
that is, if the detail_type is NOT IN 1 0r 10, the alias CHARGES will not be created so it cannot be 'found' by the parser.
[profile]
To Paraphrase:"The Help you get is proportional to...
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.