Search results for query: *

Thanks LittleSmudge, Your answer helped my situation. I have just a basic Access DB which needs to be simultaneously by 3 users (add/modify/delete). It worked perfectly. Thanks, Ashish

Hi, So how do you go about solving this problem? The lock file will be there and it can only be one. Any solutions? IN our case, it is on shared drive. 3 people have access to it and they want to use it simultaneously. Thanks, Ashish

Thanks guys. It was very helpful. Appreciate all the help. Keep up the good work. Sorry about the delayed response from me. Ashish

Hi all, Thanks for your patience. This might be a trivial question but I seem to be stuck on it, partly because I'm new to Access. I have this form in which I have a macro which updates another table based on some selection on this form. This macro is triggered on after update event. I get...

The problem has been solved. Apparently all we needed was curly braces {} for the entire query. Once we put it on, the report started working fine. Just wondering if anyone else ran into this problem or not. BTW, thanks for your response dennydm! Ashish

I have this strange problem. This report (SQL Query Based) worked perfectly fine with version 7.0.702. When I upgrade the report and catalog to 7.1.116.11, the report gives strange errors in prompt variables. Could someone please help. Attached is the exact SQL ******** select T2.SR_NO_TXT...

Dave, Excellent suggestion. Wonderful workworund! I sincerely appreciate your contributions to this forum. Ashish

Hi, First of all, thanks for your time. I have a situation where in I need to sort the columns based on the filter selection. If choice "A" is made then I want the detail records sorted by Column #3, else by Column #4. I have tried looking for anyway to specify dynamic sort order...

Thanks Dave for your reply. It did work. I appreciate your time and effort. Thanks, Ashish

I have the following situation. I have two prompts 1. Emp_Name - Pick Employee Name This list comes from picklist report 2. Emp_Type - Pick the Employee Type Choice are "Creater" or "Owner". It is typed in. My data is like the following Record Number...

I have the exact same situation. I am happy to see someone trying to do the same. I run into some problems with this. I have the following problem. I have a "Wrapper Report". This is the main report. I have a prompt defined here and a variable which gets the value from the prompt...

I am still struggling with trying to get all the sub-reports combine together as one PDF file. The Sub-report function does not really let you stack reports on top of each other. I do not know if I use macro to fire one report after another, will it open multiple windows? What I intend to do...

Dave, Thanks a bunch for the detailed response. I appreciate it. Ashish

Hi All, I am new to Impromptu and here is what I need to do. Before running a report, run an Oracle Stored Proc (which does not require any input or output parameters). I am trying to do this as a macro but do not know how do I go about doing this. I have read the threads which explain how...

Hi Windjuly, Did you find a way to use CLOB fields in Impromptu? I have the exact problem. Could anyone please help. Thanks, Ashish

Thanks for the info. That is a good starting point. Ashish

I have a report package that I am building. This includes several reports which need to be printed one after another. Is there any easy way to create sub-reports which following one after another. I can always create these reports serparately but I would like all of these to be together in one...

Thanks puppyquestion1 and Kaiaulad for your responses. Now that we have decided to go with Cognos, and I 've taken some training on Impromptu, I know a little more about Cognos. I agree with you guys that it is more feature rich. It is intended for a large user groups who are writing reports...

Hi, I am evaluating the reporting software. I have only used Crystal Reports and I have no idea how Cognos Imporomptu works. We normally use J2EE environment for developing software and would use the reporting tool to generate reports on the web. Does someone have any comparisons available...

Thanks for the answer. There is another way I was told I could use and that is as following: ({?s_Compound}='' OR {TBL_COMPOUND.S_COMPOUND_NAME} = {?s_Compound}) and ({?s_Protocol}='' OR {TBL_PROTOCOL.S_PROTOCOL_NAME}= {?s_Protocol}) and ({?s_Country}='' OR {TBL_COUNTRY.S_COUNTRY_NAME}=...