Very Urgent? VBA Code Required

[rrbo]

Dear All,

Its extremely urgent.

In my reports there are two filters like Region and City.
I need to know VBA Code Macros for automation like my problem is If User opens the report that should prompt for region ,if User select One region then that should prompt again for City,then user selects city at that time the report should opened and simultaneously that selected report should export as RTF.

Thanks in advance for your prompt reply .

rrbo

 

[skrandel]

Good luck getting a reply to this. Topics marked as urgent rarely get the attention.

What you are asking for is not very common, so I'd be surprised if anyone has a macro that will help you. But, I would think that what you are asking for is pretty easy if you know the SDK.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[rrbo]

Dear Steve Krandel,

Really I do not know SDK, Now i am learning that SDK.
Please provide me the scipt/Macro that u have .

Thanks and Have a good day.

rrbo

 

[Sridharan]

Hi rrbo,

What are you trying to accomplish??? Are you talking about Cascading Prompts user first select region and then for that region show the city and once city is selected run the report???? If so, do a search in

http://busobj.forumtopics.com

and you will get a bunch of threads dealing with this. If not, provide more details about your problem/requirement.

Sri

 

[rrbo]

Dear Sri,

Thank you for your prompt reply and please send Macro ....

Problem:

we have a report , that has filters firstly on Region and secondly on City.

Now we are doing like, we are opening a report and doing filtering like right click on the

Report and format filters ,there we can find filters of Region and City. firstly we are filtering on Region and then again in the same way City, then we are getting the report.


Now the question is we need to automize these filters and then that automatically export as RTF.

I need to write a macro that should prompt us firstly Region and then City after that report will display and at the same time that should export as RTF.

I think You Got My problem.


Please provide me the script for that .


Thanking You Very Much.

rrbo

 

[rrbo]

Dear Sri,

I have the script for same my task like

http://www.islink.com/pdf/FilterandExportviaVBA.pdf

for Filter and Export as RTF, but in this For Loop is exporting all Regions as Individual PDFs, But i need to get individual as depends on Filtered Region.

I think we can get with change of For loop , ....I am unable to get the solution

Please Give me the solution .

Thanks
rrdw

 

[Sridharan]

Hi rrbo,

You are on track and got hold of the correct link. Now tell me why is that not working. You are looking for filtering and exporting and that is what the doc at islink.com is also doing.

Do you want to do the filter and export it only for some regions and city and not for all possible values of city???

Do you want to show some kind of form where user can enter or select the region and city and only export the report based on user selection????


Sri

 

[rrbo]

Dear Sri,

Please consider this is example and give me the code. I am poor in coding.

We have two columns like Region and City and other data columns.

Region have the values like South,West,East,Midwest.

South has the cities like Austin,Dallas,Houston and Miami.

West has the cities like San Francisco and Los Angeles.

East has the cities like New York, Boston and Washington.

Midwest has the cities like Chicago and Colorado Springs.


If i select region as Midwest and then Chicago , that should diplay only records of chicago under Midwest. and simultaneously export as RTF.


Please consider this as example ,modify the code as in

http://www.islink.com/pdf/FilterandExportviaVBA.pdf

and kindly revert me back.

Thanks
rrdw

 

[Sridharan]

Hi rrbo,

Hmmmm okie send the report to me saved as "Save for All" with some data, I will put the coding and send it across to you. Then you can modify it.

sridharan.n@lycos.com