Search results for query: *

I took the impromptu exam once but could not get thru it. But I would definitely post you some of questions from the exam itself.

I just passed ReportNet and Metadata Modeling Product Professional Certification. Please feel to post your questions.

I have created a Staic value prompt like Current,Future and Past (dates) using the Macro function. Example... promptmany('Prompt','token','date1>current_date')# promptmany('Prompt','token','date1<current_date and date2>current_date')# promptmany('Prompt','token','date1<current_date and...

Hello Everyone, I am looking for some help in getting the right query creating this report. Here is my scenario…. I have 2 tables class and student name Student A enrolled in History, Economics and Gym Class Student B enrolled in History, Gym and Aerobics class The report should like...

Dont worry about, I figured it out. Thanks anyways.

I have a self join between 2 different query items in the same table. How I resolve this in Framework Manager. If I create the shortcut for the table and create the relationship...its pulling up the same records everytime for different report type. Please help me fix this problem. Thanks KS

I using Report Studio and Sql server 2000 as my database. Thanks KS

I have a column named Address which has CITY, ZIP values stored in it. But I would like to break the column into two with CITY as one column and ZIP as another one. Any help will be appreciated. Thanks KS

I have to create a report with value prompt with static values. For example when user runs the report ,it should ask user to select from 3 prompt values --> Future students, Current students and Past Students. Functionality Future Students = Start date > current date Current Students = Start...

How I Convert Datetime function to date in CRN? Any clues!!! Thanks KS

Thanks Gary ..that helped me.

Hi, I have problem creating a report using 3 tables A,B and C. The relationship between A and B is 1 to 1..between A and C is 1 to many but I dont have any relationship between B and C. There are no common keys to create relationship between B and C. Now when grab columns either from A,B or A,C...

Hi, I have successfully published the package in FM.But When I try to create the reports in Query Studio using this package I am getting an error 'MA-DEF-0011 Unable to find the object'. Please help me out!!!

Thanks Clive!!!

Hi, I have added new tables in Sql server 2000 database. Is there anyway I can update those tables in Framework Manager. Thanks K

Hi - I am working on a database with 1000+ columns. On regular basis, the DBA and developers add new columns to the tables. I was wondering is there a way to update columns in Framework Manager without actually re-importing the entire database again. And also is there any way I can update the...

Thanks Kusch

I am working on a database with 1000+ columns. On regular basis, the DBA and developers add new fields to the columns. I was wondering is there is way to figure which columns has been modified or have new fields added to it. Thanks T

Thanks Dave..that will help me.

How many maximum of sub-reports can I have in a single report?