How do I create a report with a checkbox/combobox/ etc

Question

Post reply

How do I create a report with a checkbox/combobox/ etc

benruiz74

Old Hand

Points: 302
More actions
November 19, 2007 at 10:54 am

#176913

Does anyone know how to create a report with a combobox,checkbox, buttons, etc? Going to "Choose Toolbox Items" does not work. Any ideas?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

Mr. Impatient has triple cross-posted...

http://www.sqlservercentral.com/Forums/Topic423754-147-1.aspx

http://www.sqlservercentral.com/Forums/Topic423766-150-1.aspx

http://www.sqlservercentral.com/Forums/Topic423758-1063-1.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

maya potiyevskaya SSCrazy Points: 2091 More actions · Answer 2

Hi there,

SSRS does not have these type of controls, it's not a web page :-). however, you can place an illusion of a checkbox or any other cute bullet before, let's say, the link to another report by using font Webdings and finding out which character it mappes too. i did it and it looks nicer.

if you are looking for these types of controls that absolutely must be there for functionality, i would add a asp.net web application to your project, web forms and such and navigate your report to that web page. keeping colors of that page same as your ssrs will give your user a feeling as if it were just one application.

then, in SSRS Code part, write a function that will navigate to that page 🙂 and call it from your link: =Code.myNavFunction(fld1.value)

does it answer your question?

Robert O'Byrne SSCommitted Points: 1967 More actions · Answer 3

The report parameters section offers a combo box.

1. Create and name a dataset for the report using a stored procedure or sql text.

2. Reference the dataset name in the chosen report parameter and choose "From Query" in the "Available values" section of the report parameter form.

benruiz74 Old Hand Points: 302 More actions · Answer 4

Thanks for the comments Robert and Maya-

Maya - I will look into it. I guess the only issue I see is that we upload these files into our company portal that has some limitations - I know that I can upload the .rdl file, but I am not sure about the web form

maya potiyevskaya SSCrazy Points: 2091 More actions · Answer 5

sure :-).

Well, if you need any combo boxes for the User to filter your report by parameters, let's say, State='CA', do what Robert says :-).

however, if you need to write something back, it's got to be a web form. then, your report will be bound on that table and do all sort of things with it like aggregate, calculate timelines and such.

your report will let you navigate to the web form just like you navigate to anther report, it'll navigate to that URL (the 3rd option).

maya

chethan.chandra SSC Enthusiast Points: 118 More actions · Answer 6

I dont actually understand the need to have such controls on REPORTS! its report afterall..

If I really had to do it.. then would do it like this:

use special characters.. for checkboxes [ ] or [x] / radio buttons O

for drop downs you could always use the drill down / by..

hope its not too funny!

maya potiyevskaya SSCrazy Points: 2091 More actions · Answer 7

Hello back,

you are 100% correct: you do not need anything if it is just a report; tool box has everything you need to display it.

however, from your originala post: "with a combobox,checkbox, buttons, etc? Going to "Choose Toolbox Items" does not work. Any ideas? " you are asking for these controls because you want to do something with them, suppose save data back by clicking the buttons? this was my understanding. am i right? that's why i suggested to integrate a report (rdl file) and a web form (aspx file) for that matter. i was trying to read your mind + help you :-), not confuse. sorry, if i confuse you, it wasn't my plan.

i feel you already know what to do :-).

benruiz74 Old Hand Points: 302 More actions · Answer 8

Maya - again thanks for your input and everyone else who posted. I hope you will be around once I try this and may again need more input. I realize this is a report - trying to give our client some different views, etc. Also, trying to determine if I could do some "What-If" reports where I will need some of this functionality.