Hi all:
I read in a csv file and create a visio doc using the Org chart wizzard. It works perfectly except for the ordering. It seems to order randomly instead of the order in the file.
'START THE ORG CHART WIZ
objVisio = CreateObject("Visio.Application")
objAddOn =...
Hi all:
I am using VB.net and Visio 2003. I am trying to take an excel file and make a visio file. I can actually use a .bat file to create the visio file using this command:
c:\Program Files\Microsoft Office\Visio11\DLL\OrgWiz.exe" \wait /FILENAME=C:\Documents and Settings\cdaniels\My...
Hi All:
I have a report running of an ado recordset using the ttx file. I am tring to create an ondemand subreport that will prompt me for parameters and do some calculations.
The problem is I can not get the subreport to prompt for parameter or even link properly, meaning no records in the...
Hi All:
I have a main report which takes in a date parameter. I need to get all the records in the subreport which have a date less then the parameter.
I tried placing the parameter in a shared variable but the select expert will not allow me to use the shared var there.
Any ideas will...
Hello all:
I have been asked to create a report which takes in some values on the report itself. I started with a text object which does allow the input of text. However, I can't seem to refere to the text object to retrieve the value to use in my report.
Any help with this problem...
Hi All:
I passed a comma delimited list of user ids into a parameter. The in the select record use ToText({USERS.user_id}, 0) in {?UserIDs}
The problem is, if the list = 1211,1311,1411, then it will pick up Users with ids of 211 and 131 and 411.
Is there a way in crystal to...
Hi Everyone:
I have seen the question: How do you change the dsn through the url, but have not seen any answers. Does anyone know if this can be done through the web, mabey with the use of asp or cold fussion. Any comments would be appriciated.
Thank you
If my report has no data then it returns a blank report. No report header or page header. Does anyone know how I could rectify this problem so if no records returned I will still get my headers?
Thank you
I created a report (report1) that would get data based on 1 student. This report had subreports for the 1 to many relationships such as last login and max score.
Then I tried to create a report (report2) to run through all students. I used the previous report (report1) as a subreport...
In my main report I bring in a string of ids. Parse one at a time and link to my subreport. Works great but because ids are numeric, it returns 0 after the string is parsed. Therefore I get pages and pages of empty fields.
Is there anyway to prevent these empty fields from getting in the...
If you have a report based on a dsn, but then want to use that report on a copy of a database in a different location. Can you change the dsn for the report or do you have to redo the entire report.
Thank you
I am triing to run a report based on a group. This group is decided by the user on-line. What I did was concat the particular ids and pass them into the report.
This worked fine to get the values into the repot, but if I try parse the data in a formula field I can only get the first or the...
Does anyone know how to pass parameter to a subreport? I have 3 params to pass 2 in the main report and 1 in the subreport. Example that I'm usingis...
Does anyone know how to pass parameter to a subreport? I have 3 params to pass 2 in the main report and 1 in the subreport. Example that I'm usingis...
I know how to pass 1 value to a report but I seem to be having prob passing 2 values. Here is the format to pass 1 value:
Report.rpt?sf={TableName.FieldName}=ValueToBePassedIn&user0=UserID&password0=password
Does anyone know the syntax to pass 2 values (both field names)
Thanks
I know how to pass 1 value to a report but I seem to be having prob passing 2 values. Here is the format to pass 1 value:
Report.rpt?sf={TableName.FieldName}=ValueToBePassedIn&user0=UserID&password0=password
Does anyone know the syntax to pass 2 values (both field names)
Thanks
I have created a report which contains subreports. The subreport is taking the max entry.(the highest) Only one record, but it is big enough for all the records of the query(duplicates are surpressed).
Example!
Database Field Database Field Subreport Field
Database Field Database Field...
I have created a report which contains subreports. The subreport is taking the max entry.(the highest) Only one record, but I get a box around it which is big enough for all the records of the query(duplicates are surpressed).
Example!
Database Field Database Field Subreport Field
Database...
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.