Yes, if you input parameters then use them in the formula, you simply print them on the report, typically header or footer area.
If you are hard coding the date, STOP THAT!
If you use address scrubber databases you can standardize them but more importantly you can append lat lon info at street level. this would let you group addresses nearby.
the software is expensive but any bulk mailing company will typically scrub the files for you and return them in identical...
When test data works OK but live tables take a real long time or 'forever', often the problem is no index the join can use. The result is that the whole joined table is scanned for each record. Test files can do this for a few records but large files may hang forever.
Use a tool that shows...
I got it working!
but only on a different web site I have that is windoze hosted. I can't think of any dif except file name upper and lower case is not the same on linux as it is on windoze file system.
Thanks for your suggestions!
One more thing: I checked the web server logs and it gives 404 errors (file missing) for '../notes_flag.gif' and '../embed'.
I swear I copied the whole folder up there but I'll check when I get home, see if that fixes it.
Yes, powerpoint creates a web page save in a new folder. I copied the entire folder, and I can see the jpegs and png's, the same ones in the presentation up on the website, so that shouldn't be the problem.
and it creates a start page one level down. copied that too.
Could this somehow be a...
Hi everyone
I have a powerpoint slide show with 56 slides. I exported it to 'web page' by 'save as'.
This shows an index of your slides on left of web frame, and the slide picture in the middle. Works great! and the slide show feature also works.
However I wanted to share this with the...
You get duplicate records either because the records are actually in the database or its joined wrong.
you can do a group by the field if it turns out the data is repeated in the database and you don't need to show them all. you can show either one figure or total the repeated recs if needed...
CR85User is right.
there had to have been in place some sort of connection, probably ODBC on old computer. Just because you don't know about it doesn't mean it wasn't there. You can go into the windoze menus and check it, test it.
I have a sales report showing GL sales allocations by customer broken down by cost center. One of our account reps wants to take the exported spreadsheet for this customer, delete some lines / columns and have it automatically re-calculate the grand totals (which I currently provide as a value...
I reran this report and it ran OK. User complained was taking a while but it has subreports, took 20 minutes.
They only run this once a year. The .rar file seems to indicate an error, I'm guessing that maybe PC was flaky - low on memory, etc; She only reboots 2x a week or so.
So end result...
no, just display on screen so user can print this.
the .rar file just shows up after taking long time to run.
I just looked and .rpt had not been modified for almost a year.
I tried running it and the parameters box doesn't go away after hitting 'ok'. the bottom part says 'accessing...
Hi everyone
We have some production reports that I developed, haven't touched in a while. User today complained that running slow, didn't come up with any records at the end, and it produced a file with the report name and '.rar' in the directory the report is in.
Does this indicate an error...
You can join their developer network, $500/year. you can then get doc and tutorials online.
Brainbench has an informatica test. ($)
ITToolbox also has informatica thread you can follow. See if you can understand the questions and answers, could help.
I'll try these.
Parts of VB still confuse me so may be a while before I get it working, and I'm just finishing up other parts of the prog.
Thanks both!
Hi everyone
I have a picturebox and wondering if it would be real easy to add a button to rotate right or left. I need to be able to save the rotated picture out to disk also, to the same or possibly a new file name.
I'm scrolling pictures thru the screen from a directory and need users...
I'll try the trim. Was inputting from text box so didn't even think might be interpreted as a number. Only nodeid is a key, no other fields even indexed.
Still haven't figured out why update not working or throwing an error when it fails to update the values.
However I substituted a delete...
Hi all
I've got a vb 2005 form with textboxes for data from fields and buttons: read, write, update, del
I've got it querying an access database, and grabbing data from a table.
Read works, if record already present, does a SELECT
write works, if record NOT present, does an INSERT
del works...
Hi all
I've got a vb 2005 form with textboxes for data from fields and buttons: read, write, update, del
I've got it querying an access database, and grabbing data from a table.
Read works, if record already present, does a SELECT
write works, if record NOT present, does an INSERT
del works...
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.