Search results for query: *

I'm on ReportSmith version 3.11 and I hope someone has the answer to this one. I have a report that calls another report by using the "LoadReport" statement. This statement also allows you to pass a variable off to the report that is loaded before SQL execution. The below example displays...

We have over 50 users of ReportSmith where I work and we recently received new computers. We went from Windows 2000 to Windows XP Professional. Here's the strange part - for some users (not for all)when you double-click on a report that has already been created, ReportSmith opens but no report...

I've just placed Windows XP Professional on my notebook and when I go to look at files in my directories, the file extensions are missing. For instance, when I look inside a file folder that has 5 programs/files inside, I go to my tool bar, hit 'View' then 'Details' I'm still not able to view...

I'm having a problem with the below script and I don't even know if this is possible. I would like to insert a case statement within my where clause to control rates but have received this error when I fire off the sql: invalid relational operator (its pointing to 'THEN' in my case statement)...

Hi everyone. I have a problem that one of you could help me solve. I want to concatenate a string with a date - simple, right? Here's what I get: Column A1 Column A2 7/8/2004 The date is 38176 Here's my formula: =CONCATENATE("The date is ",A1) Why can't excel simply return the date...

Is there a way to do this within an sql script? Here's what I'm dealing with: PROD SQL> / update ps_position_data set descrlong = descr where descrlong <= ' ' * ERROR at line 1: ORA-00997: illegal use of LONG datatype Thank you for your help.

My computer for the last month has been giving me errors but I've always been able to log on to my desktop. I know I must have received a virus, but I always thought that I would just format my drive when it became too much of a nusance. Now I can't even log in. I receive the error message...

I have a situation that has left me feeling like a complete newbie. I've even tried to research this on the internet, but haven't located anything on it. Here's my problem: I'm trying to round a salary amount to a thousand, trying to always round up. So, for instance, if someones salary was...

I've been handed a project at work and I don't know if this can be done using only sql - some tell me that you have to use an SQR to do this. The project is an electronic file feed for one of our vendors. The problem is that the file layout has a header record, 3 detail records per employee...

Please excuse my frustration, but having done some developement on Crystal 8.5, it was rather easy to adjust (or create for scratch) my SQL statement in "Show SQL Query". Now, of course, Crystal has to come up with a new version 9 to make things even more difficult to do the simple things. Is...

Since the ReportBasic language can only go so far with creating decent front-ends - Does anyone know how to call a ReportSmith report from Visual Basic? I know that Crystal comes bundled with VB (depending on version) but I would like to use VB to create my front-ends and call ReportSmith.

Does anyone know how to detach ReportSmith from the catalog that comes with 4.2? I've heard from other sources that there is a utility to do this, but no one seems to know how to get it.

I have an issue with my Internet Explorer 6 not allowing me to fully open a website. I double-click on the IE icon and it trys to load (for my computer it's Yahoo) the website - but once it's fully loaded, it automatically closes the window and all I have is my desktop. I have no problem...

I've included a Word doc on my form report by inserting this as an OLE Object - and it looks great. But when I export the report to a Word doc it has vanished and only the text is displayed. Why is it that pictures will export just fine to Word but another Word doc will not?

I guess my question should be directed to Chris Cook, since he knows both very well, but if someone else also has this answer, please let me know. In ReportSmith, I have an option to control my selection criteria with sql (since adjusting the sql outside the selection criteria doesn't let you...

I do alot of report writing for users within my company and have set up users with custom reports that allow the user to bypass database security for specific reports. Also, I have macro passwords within ALL my reports that enable/disable tool bar features so the user can not tinker with...

I wonder if anyone has any idea of how to adjust the background settings of a dialog box when the macro is linked an event. For example, creating dialog boxes for users to input selection criteria, you can press run from Tools|Macro and your result would have a grey background with a VB look...

I would like to know how you can reset the page number count to Page 1 everytime you start a new page after report grouping?

Does anyone know if there is anyway to do an &quot;If-Then&quot; statement when reporting only from Access tables? I know there is one when in an Oracle enviroment, but for right now I am reporting off of Access tables from my PC. Any help would be appreciated.