Hi Prasad,
Try this:
1. Create a calculated field(calculation1=?PromptForSubQuery?) containing the prompt variables in main quiery.
2. Use this field in the sub report in a filter (i.e. FieldToFilter=master report.calculation1).
3. Now set the value of ?PromptForSubQuery? from powerprompt...
Hi underwun,
If it is on UNIX or similar platform, try the option of developing scripts for scurbbing flat files using a language called AWK with Shell script. This is really fast. And also AWK is pretty simple. Good luck.
Thanks and Regards,
Srinath M.K
Hi mallareddy,
Data warehousing is about managing intelligently hystorical data. Hence,my assumption of the term RT(Real Time) is "Practical Situation". In this context the replies to your questions are as underneath:
1. Analysis of data is based on the following factors: Broad...
Hi all,
I could not get the solution to question:
"I have a master/detail report that will generate over one hundred pages. To make it easier for the user when the report is printed I would like to insert a page at the beginning of the report that contains a table of contents with the...
Surrogate keys are system generated numeric fields which do not have any business meaning. They are used in data warehousing. These surrogate keys will be primary keys in dimension table which will be mapped as foreign keys in fact table.Ex: Say there is a Customer Dimension table. The...
Hi,
I have a similar problem. I want to upload a file to my server from Windows. I have the userid/pwd. I want to automate the process. Something like, i will click on a batch file which should ask me for a password. When i supply a valid password it should upload the file. The file name and...
Hi,
I have a similar problem. I want to upload a file to my server. I have the userid/pwd. I want to automate the process. Something like, i will click on a batch file which should ask me for a password. When i supply a valid password it should upload the file. The file name and the source...
Hi,
I have a similar problem. I want to upload a file to my server. I have the userid/pwd. I want to automate the process. Something like, i will click on a batch file which should ask me for a password. When i supply a valid password it should upload the file. The file name and the source...
HI vijay,
That was a very extensive one that you provoided.. thanks..I would like to clear on the Question 8. Can it handle exception reporting?. I guess it referes to using conditional formats/alerts. Ex: if a measure exceeds a certain value display it in red.
I also have a set of questions ...
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.