I am confused and in need of help. I want to initiate a report
thru a URL. An application I have written emails a user once complete that reports can now be started.
Instead I would like to have a link to the report. The report has 1 parameter.
Reading around looks like unmanaged reports is...
Where do you find the valid parameters you can pass via URL. For example apsuser, id, etc.... .
I want to initiate a report by passing the login credentials as well as the parameter as well.
That is crazy, There has to be a patch or workaround. I hate access, and I have spreadsheets the change to often. Until I came across this issue with linking to my oracle table threw the zipcode field.
Does anyone know of a way around this and still link to the excel file? I don't want to...
Jeez, my bad... Here is the output I need.........
1st query give me array $main, then I my and clause finds the records that would associate.
<?php
$main[0] = "Application";
$main[1] = "Server";
$main[2] = "Network Device";
$main[3] = "Database";
$secondary[0][0] = "Crystal Enterprise"...
Well first you are missing the 1st header or the "From Header" at the beginning,
($headers = "From: \"Me\"<me@here.com>\n";)
that makes it a malformed header.
There should only be 4 args...
$headers = "From: \"Me\"<me@here.com>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .=...
I was looking at my post, and thought it might be easier to simplify the question.
I have one array built from a query, say like this...
$main = array('foo','bar','test','one');
I then do a foreach($main as $i) {
$sql = "select blah from blah where columna = '$i';
)
This is going to return...
Hey Guys, I am not very good at creating multi-dim arrays, What I am doing is doing a query, returning query results into a array, then for looping the next query based on the 1st array like so: (return_array is just all the oci stuff returning a array back)
$sql = "SELECT...
Depending on the type of database on the backend that you have, you can get this type info from there, we use TOAD for Oracle, and can see a schema browser to see the underlying tables, etc.
RequestID is usually the primary key for evey form, besides that its how you dictate it.
_WL
You can download a demo license of the server with 3 person limit and less then 5000 records in the DB. But you can download and give it a go standalone on any server. I have put it on 133MGHZ Linux box's before, just have to keep in mind of the memory. Need at least 512MB
I do it 2 ways, one just creating a join form and report off that, which is how Remedy would tell you to do it. But thats a
pain. So what I have done like stated above is just using the native odbc driver to my database and query the view directly. You will end up having to do some leg work...
Hmm.... That does work but I dont't seem to get any negative values.
I am consfused big time now. I guess the easiest thing to get me back on track is to see see both months value and mark it.
THis way I can see
(recordid month1.cur1 month2.cur2 chcurr1 %curr)
Know what I mean? Thanks...
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.