Say I have a page called issueReport.aspx page, i pass a URL that has fields Comments1, Comments2, and Comments3. Comments2 is derived from selections from a limitless ListBox. Then all data is passed to issueReportViewer.aspx which of, is the viewer for a CrystalReport.rpt...
Some More Info:
So in more detail let's say I'm storing Comments2 in a field on the crystal report that is limited to 511 characters. So I've truncated the string because I was getting an error: Buffer too small for String or missing Null byte.
(I would like to have added extra fields on the report but didn't know how to access new fields I added because it was a special field type in Crystal Reports called Report Comments and I guess you can only have one though you can add as many as you like...however I was unable to find a way to access them by their object name...only by (rpt my CR document) rp.SummaryInfo.ReportComme
nts...but couldn't find away to access ReportsComments2 as opposed to ReportComments1.)
To make a short story long, I couldn't find a way to add entire Comment2 string to CR so i truncated it as stated. However, now the issue is if I select all 150 items in my ListBox since it's multiselect, and pass it to the page by QueryString, I get IE error:
Internet Explorer cannot display the webpage. Most likely causes:You are not connected to the Internet. The website is encountering problems. There might be a typing error in the address.
Any thoughts? Maybe some characters messing up querystring? i don' t think querystrings have a limit to it's length. Example queryString is below (Are / or () messing up querystring?):
Group: All &RC2=Issue Type: A/C, A/C VENTS, AC HOT/COLD, ALUMINIUM COMPRESSOR, ANTENNA (GENERAL), ARTWORK/PICTURES/STATUES, BAND SAW, BATHROOM FIXTURE, BATHTUB, BATHTUB, BED, BEDDING, BEER COOLER, BINGO MACHINE, BLAST CHILLER, BLINDS, BLOWER, BRAISING PAN, BREAD SLICER, BROADCAST CTR EQUIP, BUFFALO CHOPPER, CABINET, CANOPY, CANOPY, CAPUCCINO MACHINE, CARPETED FLOOR, CARVING STATION, CASINO, CEILING, CHAIR, CHEESE GRINDER, CLOCK, CLOSET, COAT HOLDER, COFFEE MACHINE, COLUMNS, COMPUTER, COUNTER, CURTAINS, CUTTER MIXER, DECK CHAIR, DECT PHONE, DEEP FAT FRYER, DESK, DISHWASHER, DISPLAY CASE, DOOR, DOOR, DOORBELL, DOUGH DIVIDER, DOUGH ROLLER, DRAIN, DRAWER, DRESSER/VANITY, DRINKING FOUNTAIN, DRY STORE CABINET, DRY WASTE SHREDDER, ELEVATOR, ESCALATORS, EXHAUST FAN, FAN, FAUCET, FITNESS EQUIPMENT, FLASHLIGHT, FLAT GRILL, FLOOR CLEANING, FLOOR MAT, FOOD CONTAINER/BASIN, FREEZER (WALK-IN), GALLEY, GARBAGE BIN, GLASS CRUSHER, GLASS HOLDER, GLASS WASHING MACHINE, GLASS WASHING MACHINE, GLASS/WINDOW, GOLF SIMULATOR, GRILL, GROOVE GRIDDLE, HAIRDRYER, HAM SLICER, HAND SANITIZER DISPENSER, HANDICAP LIFT, HANDRAIL , HEATING LAMPS, HOT DOG MACHINE, HOT PLATE, ICE CREAM FREEZER, ICE CREAM MACHINE, ICE CRUSHER, ICE MACHINE, ICE/WATER